1. Accounts Receivable Implementation Guide
  2. Understanding the Statistics History Update Program

Understanding the Statistics History Update Program

As part of the customer analysis activities, you can update statistical information about customer accounts by running the Statistics History Update program. This enables you to review the activity of a customer's account for a specific period, which is helpful for trend analysis and cash forecasting. The update includes information about both closed and open transactions, such as:

  • Invoice amount

  • DSO

When you run this batch process, the system includes posted information only. The system also updates inception-to-date statistics for the customer accounts. This information is similar to the periodic statistics except that the system accumulates statistical information from the time the customer's account is opened. It includes:

  • The date of the first and last invoice.

  • The last receipt date.

Running this batch process is time consuming. You should run this process during off-peak hours.

When updating statistical information, the system gathers information from these tables:

  • Customer Ledger (F03B11)

  • Invoice Revisions (F03B112)

  • Receipts Header (F03B13)

  • Receipts Detail (F03B14)

After the system gathers the information, it updates the F03B16 and F03B16S tables. The F03B16S records are a summary of a subset of F03B16 records. You define the subset by using processing options. The system stores summary information at the parent/child level. The parent record contains information that pertains to the account and all associated child accounts.

The system also updates these fields in the Customer Master by Line of Business table (F03012):

  • Invoiced This Year (ASTY)

    The system updates this field using the gross amount (AG) of the invoice record in the F03B11 table, regardless of whether the invoice has applicable taxes.

  • Invoiced - Prior Year (SPYE)

  • YTD Finance Charges (AFCY)

  • Last Applied Amount (ALP)

  • Date of First Invoice (DFIJ)

  • Last Invoice Date (DLIJ)

  • Date Last Paid (DLP)

After invoice and receipt information is included in the F03B16 table, the system updates the processed records with 1 in the A/R Post to Cash Management (ISTC) field, which prevents the records from being processed a second time. If you do not want to include all posted transaction information in the statistical tables, you must update the ISTC field with a value of 1, using a data file utility. The ISTC field is located in the F03B11, F03B112, F03B13, and F03B14 tables.

The system does not process R5 deduction records from the F03B14 table or RU (unapplied receipt) and R1 (draft) records from the F03B11 table.

To run the Statistics History Update program successfully:

  • Set up credit and collection date patterns for company 00000 for all fiscal years for which you have invoices and receipts entered on the system.

  • Post all invoices and receipts that you want to include.

  • Do not change the data selection or data sequence of the program.

  • With the exception of calculating the high balance, do not change the processing options after you run the Statistics History Update program.