ARSQRY: Customer Query
The Customer Query business object lets you view information held against a customer in the Accounts Receivable module.
Properties
| Syspro Module | Accounts Receivable |
| Class | Query |
| Methods | Query |
| Functional Area | AR Primary Query |
| Initial version released | Syspro 6.1 |
Input XML
The .XML and .XSD input files indicate the parameters schema and an instance of an XML document for this business object.
ARSQRY.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2026 SYSPRO Ltd.-->
<!--
Sample XML for the Customer Query Business Object
-->
<Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="ARSQRY.XSD">
<Key>
<Customer><![CDATA[000019]]></Customer>
</Key>
<Option>
<MultiMediaImageType>GIF</MultiMediaImageType>
<IncludeFutures>N</IncludeFutures>
<IncludeTransactions>Y</IncludeTransactions>
<IncludeInvoices>Y</IncludeInvoices>
<EinvoicesNotSubmitted>N</EinvoicesNotSubmitted>
<EinvoicesSubmitted>N</EinvoicesSubmitted>
<EinvoicesCompleted>N</EinvoicesCompleted >
<EinvoicesFailed>N</EinvoicesFailed >
<EinvoicesRejected>N</EinvoicesRejected >
<EinvoicesCancelled>N</EinvoicesCancelled >
<IncludeCheckPayments>Y</IncludeCheckPayments>
<IncludePostDated>Y</IncludePostDated>
<IncludeZeroBalances>N</IncludeZeroBalances>
<IncludeRetained>N</IncludeRetained>
<IncludeCustomForms>N</IncludeCustomForms>
<IncludePaymentRequests>N</IncludePaymentRequests>
<CustomerPortal>N</CustomerPortal>
<AsOfPeriod>C</AsOfPeriod>
<AgeingOption>S</AgeingOption>
<AgeColumn1>30</AgeColumn1>
<AgeColumn2>60</AgeColumn2>
<AgeColumn3>90</AgeColumn3>
<AgeColumn4>120</AgeColumn4>
<AgeColumn5>150</AgeColumn5>
<AgeColumn6>180</AgeColumn6>
<AgeColumn7>210</AgeColumn7>
<XslStylesheet/>
</Option>
</Query>
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2026 SYSPRO Ltd.-->
<!--
Schema for Customer Query Business Object
-->
<xsd:schema elementFormDefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="Customer">
<xsd:annotation>
<xsd:documentation>The customer for which the statement is required</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Key">
<xsd:complexType mixed="false">
<xsd:all>
<xsd:element ref="Customer"/>
</xsd:all>
</xsd:complexType>
</xsd:element>
<xsd:element name="Option">
<xsd:complexType mixed="false">
<xsd:all minOccurs="0">
<xsd:element ref="MultiMediaImageType" minOccurs="0"/>
<xsd:element ref="IncludeFutures" minOccurs="0"/>
<xsd:element ref="IncludeInvoices" minOccurs="0"/>
<xsd:element ref="EinvoicesNotSubmitted" minOccurs="0"/>
<xsd:element ref="EinvoicesSubmitted" minOccurs="0"/>
<xsd:element ref="EinvoicesCompleted" minOccurs="0"/>
<xsd:element ref="EinvoicesFailed" minOccurs="0"/>
<xsd:element ref="EinvoicesRejected" minOccurs="0"/>
<xsd:element ref="EinvoicesCancelled" minOccurs="0"/>
<xsd:element ref="IncludeTransactions" minOccurs="0"/>
<xsd:element ref="IncludeCheckPayments" minOccurs="0"/>
<xsd:element ref="IncludePostDated" minOccurs="0"/>
<xsd:element ref="IncludeZeroBalances" minOccurs="0"/>
<xsd:element ref="IncludeRetained" minOccurs="0"/>
<xsd:element ref="IncludeCustomForms" minOccurs="0"/>
<xsd:element ref="IncludePaymentRequests" minOccurs="0"/>
<xsd:element ref="CustomerPortal" minOccurs="0"/>
<xsd:element ref="AsOfPeriod" minOccurs="0"/>
<xsd:element name="AgeingOption" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Indicates the ageing option that should be used for the run of the program. If no ageing option is used then the default ageing option for the company will be used. Valid ageing options are S - By Statement or A - By aged statement or I - By invoice date or D - By invoice due date.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="S"/>
<xsd:enumeration value="A"/>
<xsd:enumeration value="I"/>
<xsd:enumeration value="D"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AgeColumn1" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The value supplied will be used for the first column of ageing. If no value is supplied then the ageing value against the customers default statement format will be used.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AgeColumn2" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The value supplied will be used for the second column of ageing. If no value is supplied then the ageing value against the customers default statement format will be used.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AgeColumn3" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The value supplied will be used for the third column of ageing. If no value is supplied then the ageing value against the customers default statement format will be used.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AgeColumn4" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The value supplied will be used for the fourth column of ageing. If no value is supplied then the ageing value against the customers default statement format will be used.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AgeColumn5" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The value supplied will be used for the fifth column of ageing. If no value is supplied then the ageing value against the customers default statement format will be used.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AgeColumn6" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The value supplied will be used for the sixth column of ageing. If no value is supplied then the ageing value against the customers default statement format will be used.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AgeColumn7" minOccurs="0">
<xsd:annotation>
<xsd:documentation>The value supplied will be used for the seventh column of ageing. If no value is supplied then the ageing value against the customers default statement format will be used.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="XslStylesheet" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Indicates what style sheet should be used.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:all>
</xsd:complexType>
</xsd:element>
<xsd:element name="MultiMediaImageType" type="xsd:string">
<xsd:annotation>
<xsd:documentation>Image type to retrieve (for example: GIF, JPG)</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="IncludeFutures" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include future invoices ? (Y - Yes, N - No))</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeTransactions" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include invoice transaction details ? (Y - Yes, N - No))</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeInvoices" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include invoics ? (Y - Yes, N - No))</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="EinvoicesNotSubmitted" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include e-Invoices in status 'Not submitted'? (Y - Yes, N - No - default).
Only applied if 'IncludeInvoices' is set to 'Y' and customer uses e-invoicing submission.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="EinvoicesSubmitted" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include e-Invoices in status 'Submitted'? (Y - Yes, N - No - default).
Only applied if 'IncludeInvoices' is set to 'Y' and customer uses e-invoicing submission.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="EinvoicesCompleted" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include e-Invoices in status 'Completed'? (Y - Yes, N - No - default).
Only applied if 'IncludeInvoices' is set to 'Y' and customer uses e-invoicing submission.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="EinvoicesFailed" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include e-Invoices in status 'Failed? (Y - Yes, N - No - default).
Only applied if 'IncludeInvoices' is set to 'Y' and customer uses e-invoicing submission.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="EinvoicesRejected" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include e-Invoices in status 'Rejected'? (Y - Yes, N - No - default).
Only applied if 'IncludeInvoices' is set to 'Y' and customer uses e-invoicing submission.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="EinvoicesCancelled" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include e-Invoices in status 'Cancelled'? (Y - Yes, N - No - default).
Only applied if 'IncludeInvoices' is set to 'Y' and customer uses e-invoicing submission.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeCheckPayments" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include check payment details ? (Y - Yes, N - No))</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludePostDated" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include post dated check details ? (Y - Yes, N - No))</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeCustomForms" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include fields from custom forms ? (N - No, Y - Yes,). Default is N - No.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludePaymentRequests" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include payment request details ? (N - No, Y - Yes,). Default is N - No.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeZeroBalances" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include invoices with a zero balance ? (Y - Yes, N - No))</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeRetained" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include retained invoices ? (Y - Yes, N - No))</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AsOfPeriod" default="C">
<xsd:annotation>
<xsd:documentation>This element specifies the period from which to return data (C - current period backwards, P - the previous period backwards, 2 - previous period two backwards). If this element is not provided the default is C.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="C"/>
<xsd:enumeration value="P"/>
<xsd:enumeration value="2"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="CustomerPortal" default="N">
<xsd:annotation>
<xsd:documentation>This element specifies whether the program is being run by a portal user or normal user (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Query">
<xsd:annotation>
<xsd:documentation>The root element</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element ref="Key"/>
<xsd:element ref="Option" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
1. If the operator is denied access to the customer's branch and the option to filter reports and browses is selected (Setup | Security | Operators | Security | A/R Branches), the query cannot be performed.
2. If a salesperson code (with access control applied) has been defined against the operator (Setup | Security | Operators | Security | Salesperson), the query cannot be performed if the salesperson defined against the operator does not match the salesperson defined against the customer.
3. The query cannot be performed if the customer being queried is not on the list of customers that may be accessed by the operator or the salesperson attached to the customer is not the specific salesperson to which the operator is allowed access (Setup | Security | Operators | e.net | Customers).
4. Any blank lines contained within Credit Management or Customer Notes will be returned with the non-blank lines.
5. If the element, AsOfPeriod is defined as C, the current date will be returned in the element StatementDate otherwise, if AsOfPeriod is defined as P or 2, the applicable period end date (Setup | Financial Setup | Accounts Receivable | Periods tab) will be returned in the element StatementDate. These dates are also used for ageing.
6. Refer to ARSQRY.XSD and ARSQRY.XML for the schema and an instance of an XML document for this business object.
Output XML
The OUT.XML indicates a sample of the XML returned by this business object.
ARSQRYOUT.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2026 SYSPRO Ltd. -->
<!--
Sample XML for the Customer Query Business Object
-->
<ARStatement xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="ARSQRYOUT.XSD">
<SystemInformation>
<CssStyle/>
<DecFormat>1</DecFormat>
<DateFormat>01</DateFormat>
<Role>01</Role>
<Version>6.0.012</Version>
<CompanyId>0</CompanyId>
<CompanyName>The OUTDOORS Company</CompanyName>
<OperatorCode>ADMIN</OperatorCode>
<OperatorName>SYSPRO Administrator</OperatorName>
<OperatorGroup>ADMIN</OperatorGroup>
<OperatorEmailAddress/>
<OperatorLocation/>
<ReportDate>Thursday November 2006 11:09 AM</ReportDate>
<UseSeparatorOnReports>N</UseSeparatorOnReports>
<SeparatorToUse>,</SeparatorToUse>
</SystemInformation>
<Header>
<CompanyName>The OUTDOORS Company</CompanyName>
<CompAddress1>P O Box 777</CompAddress1>
<CompAddress2>Great Outdoors</CompAddress2>
<CompAddress3/>
<CompTaxNo/>
<CompRegNo>1978/035534/04</CompRegNo>
<Customer>0000009</Customer>
<Name>Grand Adventures</Name>
<SoldToAddr1>P O Box 98-978</SoldToAddr1>
<SoldToAddr2>Eastway North</SoldToAddr2>
<SoldToAddr3>Faraway</SoldToAddr3>
<SoldToAddr3Loc/>
<SoldToAddr4>Overseas</SoldToAddr4>
<SoldToAddr5/>
<SoldPostalCode/>
<SoldToGpsLat/>
<SoldToGpsLong/>
<SALSLS_Name>Sandra Jenkins</SALSLS_Name>
<StatementDate>2006-11-09</StatementDate>
<TermsCode>2</TermsCode>
<TBLART_Description>60 Days - Net</TBLART_Description>
<AgeingCode>07</AgeingCode>
<AgeingDescription>7 days Fixed</AgeingDescription>
<AgeingHead1>Current</AgeingHead1>
<AgeingHead2>7 days</AgeingHead2>
<AgeingHead3>14 days</AgeingHead3>
<AgeingHead4>21 days</AgeingHead4>
<AgeingHead5>28 days</AgeingHead5>
<AgeingHead6>35 days and over</AgeingHead6>
<Currency>EUR</Currency>
<TBLCUR_Description>Euros</TBLCUR_Description>
<Contact>Carol Donald</Contact>
<CreditLimit> 0</CreditLimit>
<CreditCheckFlag/>
<ShortName>Foreign</ShortName>
<CustomerType/>
<CustomerTypeDesc/>
<MasterAccount/>
<StoreNumber/>
<CreditStatus>0</CreditStatus>
<CreditStatusDescription/>
<InvoiceCount> 3</InvoiceCount>
<Salesperson>101</Salesperson>
<CustomerClass>F</CustomerClass>
<CustomerClassDesc/>
<InvDiscCode/>
<LineDiscCode/>
<BalanceType>I</BalanceType>
<BalanceTypeDesc/>
<Area>O</Area>
<AreaDesc/>
<TaxStatus>E</TaxStatus>
<TaxStatusDesc/>
<SpecialInstrs/>
<DateLastSale>2006-11-09</DateLastSale>
<DateLastPay>2006-11-09</DateLastPay>
<OutstOrdVal> 66850.00</OutstOrdVal>
<NumOutstOrd> 2</NumOutstOrd>
<Telephone>+ 1 (444) 666 7895</Telephone>
<AddTelephone>+ 1 (444) 666 7897</AddTelephone>
<Fax>+ 1 (444) 666 7002</Fax>
<Telex/>
<TelephoneExtn/>
<UserField1/>
<UserField2> 0.00</UserField2>
<GstExemptFlag>E</GstExemptFlag>
<GstExemptFlagDesc/>
<GstExemptNum/>
<CompanyTaxNumber/>
<ContractPrcReqd>N</ContractPrcReqd>
<BackOrdReqd>Y</BackOrdReqd>
<ShippingInstrs/>
<StateCode/>
<DateCustAdded>2006-03-01</DateCustAdded>
<Nationality/>
<NationalityDesc/>
<HighestBalance> 64500.00</HighestBalance>
<CustomerOnHold>N</CustomerOnHold>
<EdiSenderCode/>
<Email>Carol.Donald@GrandAdventures.com</Email>
<DocFax/>
<DocFaxContact/>
<ShipToAddr1>4545 Ferryway Drive</ShipToAddr1>
<ShipToAddr2>Eastway North</ShipToAddr2>
<ShipToAddr3>Faraway</ShipToAddr3>
<ShipToAddr3Loc/>
<ShipToAddr4/>
<ShipToAddr5/>
<ShipPostalCode/>
<ShipToGpsLat/>
<ShipToGpsLong/>
<LanguageCode/>
<TaxExemptNumber/>
<Branch>10</Branch>
<SALBRN_Description>Receivables - North</SALBRN_Description>
<BranchAddr0/>
<BranchAddr1>34 Fifteenth Street</BranchAddr1>
<BranchAddr2>North</BranchAddr2>
<BranchAddr2Loc/>
<BranchAddr3/>
<BranchAddr4/>
<BranchAddr5/>
<BranchGpsLat/>
<BranchGpsLong/>
<BranchLanguageCode/>
<DispatchWholeOrderOnly>N</DispatchWholeOrderOnly>
<SalesAllowed>Y</SalesAllowed>
<UnappPayAllowed>Y</UnappPayAllowed>
<PaymentsAllowed>Y</PaymentsAllowed>
<QuotesAllowed>Y</QuotesAllowed>
<CrNotesAllowed>Y</CrNotesAllowed>
<DrNotesAllowed>Y</DrNotesAllowed>
<QueryAllowed>Y</QueryAllowed>
<DunningGroup>0000000001</DunningGroup>
<DunningFax>0110110111</DunningFax>
<DunningEmail>Customer@Email.com</DunningEmail>
<PriceGroup>PG1</PriceGroup>
<PriceGroupDesc>Price Group For Customers</PriceGroupDesc>
<AverageDaysToPay>5</AverageDaysToPay>
<EinvoicingRequired/>
<EinvoicePrintOption/>
<DateFormat>CCYY-MM-DD</DateFormat>
<Bank/>
<StockCodeOverride />
<FbpApplyFlag>N</FbpApplyFlag>
<FbpProfile></FbpProfile>
<CustomerNotes>
<DateLastModified>2006-11-09</DateLastModified>
<Text>09/11/04 ADMIN</Text>
<Text>Please collect after 11:00am</Text>
</CustomerNotes>
<ManagementNotes>
<DateLastModified>2006-11-09</DateLastModified>
<FollowUpDate/>
<IsFollowUpDateDue>N</IsFollowUpDateDue>
<Text>09/11/04 ADMIN</Text>
<Text>Pls coLlect after 11:00am</Text>
</ManagementNotes>
<AdditionalNotes>
<Text/>
</AdditionalNotes>
<Image>C:\Program Files\SYSPRO60\base\SAMPLES\ARTSY.GIF</Image>
<CustomForm>
<Field>
<Sequence>1</Sequence>
<Name>ALP001</Name>
<Prompt>Alpha Input</Prompt>
<Type>A</Type>
<Length>10</Length>
<Decimals>0</Decimals>
<Default>{Spaces}</Default>
<AllowNull>Y</AllowNull>
<Value/>
</Field>
</CustomForm>
</Header>
<InvoiceDetail>
<DocumentType>I</DocumentType>
<Invoice>100493</Invoice>
<InvoiceDate>2006-03-29</InvoiceDate>
<DueDate>2006-05-28</DueDate>
<CustomerPoNumber>147</CustomerPoNumber>
<CurrencyValue> 64000.00</CurrencyValue>
<TBLART_Description>60 Days - Net</TBLART_Description>
<InvoiceBal> 64000.00</InvoiceBal>
<MonthPosted/>
<OriginalAmount/>
<Edited_OriginalAmount/>
<Salesperson/>
<SalespersonName/>
<Area/>
<AreaDesc/>
<Branch>10</Branch>
<SalesOrder>000810</SalesOrder>
<LastDelNote>000258</LastDelNote>
<ProofOfDelivery/>
<PodReference/>
<PodEntryDate/>
<BaseCurrencyValue> 55161.60</BaseCurrencyValue>
<ConvRate> 0.861900</ConvRate>
<MulDiv>M</MulDiv>
<ForeignToLocalConversion> [ 64000.00 EUR X 0.861900 = 55161.60 $ ]</ForeignToLocalConversion>
<DunningGroup>01</DunningGroup>
<DunningStatus>000000</DunningStatus>
<DunningDate>2006-03-29</DunningDate>
<DunningInvoiceBal>64000.00</DunningInvoiceBal>
<DunningUser>Test User</DunningUser>
<EinvoiceStatus/>
</InvoiceDetail>
<InvoiceDetail>
<DocumentType>I</DocumentType>
<Invoice>100534</Invoice>
<InvoiceDate>2006-11-09</InvoiceDate>
<DueDate>2006-01-08</DueDate>
<CustomerPoNumber>12345</CustomerPoNumber>
<CurrencyValue> 500.00</CurrencyValue>
<TBLART_Description>60 Days - Net</TBLART_Description>
<InvoiceBal> 0.00</InvoiceBal>
<MonthPosted/>
<OriginalAmount/>
<Salesperson/>
<SalespersonName/>
<Area/>
<AreaDesc/>
<Branch>10</Branch>
<SalesOrder/>
<LastDelNote/>
<ProofOfDelivery/>
<PodReference/>
<PodEntryDate/>
<BaseCurrencyValue> 430.95</BaseCurrencyValue>
<ConvRate> 0.861900</ConvRate>
<MulDiv>M</MulDiv>
<ForeignToLocalConversion> [ 500.00 EUR X 0.861900 = 430.95 $ ]</ForeignToLocalConversion>
<DunningGroup/>
<DunningStatus>000000</DunningStatus>
<DunningDate/>
<DunningInvoiceBal>0.00</DunningInvoiceBal>
<DunningUser/>
<EinvoiceStatus/>
<TransDetail>
<Invoice/>
<TrnType>A</TrnType>
<Type>Adjustment</Type>
<Reference>Ref 123</Reference>
<TrnValue> -500.00</TrnValue>
<PmtJournal/>
<JournalDate>2006-11-09</JournalDate>
<DiscValue> 0.00</DiscValue>
<BaseCurrencyValue> -430.95</BaseCurrencyValue>
<ConvRate> 0.861900</ConvRate>
<MulDiv>M</MulDiv>
<ForeignToLocalConversion> [ 500.00-EUR X 0.861900 = 430.95- $ ]</ForeignToLocalConversion>
<MultCurPay/>
<MultCurPayDescription>Non multi-currency payment</MultCurPayDescription>
<PayRecCurrency/>
<PayRecNetValue>0.00</PayRecNetValue>
<PayRecDscValue>0.00</PayRecDscValue>
<PayRecConvRate>0.000000</PayRecConvRate>
<PayRecMulDiv/>
<PayRecMulDivDescription/>
<PrimaryCompany/>
<SecondaryCompany/>
<PaymentRunNumber/>
<GroupPayFlag/>
<InterCompanyFlag/>
<InterCompanyTrx/>
</TransDetail>
</InvoiceDetail>
<PayDetail>
<ChequeReference>Ref 123</ChequeReference>
<PayDate>2006-11-09</PayDate>
<PayValue> -500.00</PayValue>
<PaymYear>2006</PaymYear>
<PaymMonth>02</PaymMonth>
</PayDetail>
<PostDated>
<Cheque>CH001</Cheque>
<AvailableDate>2006-11-09</AvailableDate>
<Amount> 250.00</Amount>
</PostDated>
<SalesHistory>
<Period01/>
<Period02/>
<Period03/>
<Period04/>
<Period05/>
<Period06/>
<Period07/>
<Period08/>
<Period09/>
<Period10/>
<Period11/>
<Period12/>
<Period13/>
<Period14/>
<Period15/>
<Period16/>
<Period17/>
<Period18/>
<Period19/>
<Period20/>
<Period21/>
<Period22/>
<Period23/>
<Period24/>
</SalesHistory>
<TotalSection>
<BalBroughtFwd> 64000.00</BalBroughtFwd>
<CurrentBalance> 64000.00</CurrentBalance>
<ValueFutureInv> 0.00</ValueFutureInv>
<Current> 64000.00</Current>
<Days30> 0.00</Days30>
<Days60> 0.00</Days60>
<Days90> 0.00</Days90>
<Days120> 0.00</Days120>
<Days150> 0.00</Days150>
<Days180> 0.00</Days180>
<DiscountAvailable> 0.00</DiscountAvailable>
<CreditBalance> 0.00</CreditBalance>
<UnallocatedPDChqs> 250.00</UnallocatedPDChqs>
<UnavailablePDChqs> 0.00</UnavailablePDChqs>
<CurrentLessPDChqs> 63750.00</CurrentLessPDChqs>
<CurrentMsg> 0</CurrentMsg>
<Days30Msg> 30</Days30Msg>
<Days60Msg> 60</Days60Msg>
<Days90Msg>999</Days90Msg>
<Days120Msg>999</Days120Msg>
<Days150Msg>999</Days150Msg>
<Days180Msg>999</Days180Msg>
</TotalSection>
</ARStatement>
Refer to ARSQRYOUT.XML for a sample of the XML returned by this business object.
Prerequisites
The Accounts Receivable module must be installed to run this business object.
The A/R Primary Query functional area must be licensed.
Limitations
No limitations apply to this business object.
Copyright © 2026 Syspro PTY Ltd.