1. Home
  2. Knowledge Base
  3. Accounts Receivable
  4. Ledgers Sales or Accounts Receivable: Customer Statement and Report Options

Ledgers Sales or Accounts Receivable: Customer Statement and Report Options

Customer Statement and Report Options

Customer Statement and Report Options

This function enables you to selectively produce statements, account reviews and summary reports for customer accounts.

You can report customer records only meeting any combination of restrictive ranges in a similar manner to other customer selection windows. The Only those with balances outstanding checkbox adds a further option, which, if checked, omits customers with nil outstanding account balance.

Note NOTE: This window contains fields introduced with version 5 that enable additional search (and sometimes sort controls), such as Adhoc extra where. For more help on their use and examples see the Client-Server SQL Introduction help.

The Balance all cleared option is only applicable to the Accounts Review and Statement type reports. It causes the system to summarise all cleared transactions into one balance-brought-forward transaction on the report.

For Account Reviews there is the additional option of forcing each customer onto a new page. You will be offered the option of a review report in the foreign currency or local currency.

An account review is a detailed list of all transactions listed on file against each supplier. Statements are more compact and consolidate transactions with the same document reference, making the results less detailed but more readable. The summary report analyses transactions but only prints a summary line showing aged amounts and balances. Normally an extra line of contact details is also printed, however, to suppress the printing of this line, check the option.

Date and or Period: You can enter a date/period other than the default of today’s date and no period on which aged amounts will be calculated. On reports, transactions dated after this date, or in later periods, are ignored and the ageing is based on the date you enter. By setting the date back, you can get a pseudo statement for a previous date/ end-of-period.

However, great care should be taken with this as the system can only retrospectively view transaction credit allocations for credits after the date/period. Because of this there are a number of circumstances that mean that a report printed on the actual date of concern differs from one printed later and set to an earlier date/period:

  1. Currency adjustments made by post-date allocations can not be reversed.
  2. The system does not know when the allocation actually took place. It has to assume that a post-date/period credit that has been allocated would not have been allocated as of the date. If the credit was in fact post-dated but allocated before the date, then the retrospective view is inaccurate.
  3. The user’s freedom to manipulate date/period after the real date can not be reversed automatically, so any report trying to look backwards can be manipulated.

Having set the date, it will remain the ageing date during the current user session. Windows and reports showing ageing will be affected. This date is a different date to the equivalent in the A/R.

Customisation CUSTOM CAPABILITY: All A/P and A/R statements and reviews can have aged amounts inside the record section as well as in the total section. These are available as variables iAgedDue.C1 to iAgedDue.C4 for local currency values and iAgedDue.C5 to iAgedDue.C8 for foreign currency values.



Customer Selection

Enter a restrictive range if needed. See Customers Selection subwindow for details.

Report Type List

Select a report type. Any custom reports entered in the Settings will appear at the bottom of the list.

Use custom

To turn on and off the use of the custom search design.

Only Outstanding Accounts

Check this if you only want accounts that have a current outstanding balance within the selection range entered.

Balance All Cleared

Check this option to consolidate all cleared transactions into one brought-forward balance.

New Page for Each Account

Check this option for each account to start a new page.

Show Contact Details

Check this option to show contact details for the account.


Enter a date that the statement will be based on. Transactions will be ignored after this date. Note that other options still relate to the current status of the account.



Custom Search

Click to design your own special search.


Aborts the process currently in session. The keyboard equivalent is the Esc key for Windows computers and Command-.(full stop or period) for the Mac.


Will cause a report to be printed of the subject matter. Right-click to change the report destination.

Tip TIP: Most reports are typically printed as a single print run for a range of documents. This may be inappropriate for some report destinations, which are, by default, HTML, PDF, Email where each document needs to be printed individually. You can generally override these default destinations with the optRepDestIndivid option that allows you to set a selection of destinations for which documents will be printed individually.

See also: –

Compiled in Program Version 5.10. Help data last modified 3 Jan 2015 10:14:00.00. Class wAcArStPrint last modified 17 Oct 2017 04:29:53.

Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support

Get started.

Try our state-of-the-art ERP Manufacturing Software today.