Understanding Statistical Information

As part of the credit and collection activities, you can analyze the payment trends of a customer within a specific time period. For example, you can review the average number of days that a customer is late in paying an invoice or review the total amount that is invoiced for a customer. In addition, you can review these types of statistical history:

  • Date that the account was opened.

  • Amount and number of invoices that were paid late.

  • Amount and date of a customer's high balance.

  • DSO.

You can review statistical information by fiscal period, as defined in the credit and collection date pattern, or that is summarized based on the processing options that you set when you run the Statistics History Update program.

The system displays statistical information for each customer by company and provides a total for all companies in the company 00000 record.

The system stores summarized statistical information in the F03B16S table and period statistical information in the F03B16 table.

Note: The system does not update information from a previous period to the next period until at least one invoice is posted to that period. For example, if an invoice appears in an aging category for the period ending June 30, 2008, it does not appear in the aging category for July 31, 2008, even if the invoice is still outstanding, until at least one invoice is posted to the July period.