Customer Statement and Report Options

Document path Reference Contents > Ledgers Sales or Accounts Receivable > 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.

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 aging 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 aging date during the current user session. Windows and reports showing aging 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.

Field

Description

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.

Date

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.

Button

Action

Custom Search

Click to design your own special search.

Cancel

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.

Print

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 printind 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 3.10. Help data last modified 25 JUL 2009 05:34. Class wAcArStPrint last modified 27 OCT 2009 13:34:43.

Document path Reference Contents > Ledgers Sales or Accounts Receivable > Customer Statement and Report Options