Updating Statistical Information Updating Accounts Receivable Statistics for Customer Analysis by Ayman Refat - March 21, 2018March 22, 20180 Updating Statistical Information Concept As part of the customer analysis activities, you can update statistical information about customer accounts by running the Statistics History Update program (R03B16A). 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 and 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 and 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) The system updates information to the A/R Statistical Summary table (F03B16S) and A/R Statistical History table (F03B16). 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 this field with a value of 1, using a data file utility. The system stores this value 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. With the exception of calculating the high balance, do not change the processing options after you run the R03B16A program. Prerequisites Before you complete this task, you must: • Set up credit and collection date patterns for company 00000 for all fiscal years in which you have invoices and receipts. • Post all invoices and receipts. • Verify that the UDC values that you want to use to accumulate amounts for bad debt and minor write-offs are specified. • If you are converting information from another system, you might want to run the Statistics Annual Close program (R03B16A1) to update the invoiced prior year amount. Procedure In this task, you will use the Statistics History Update program (R03B16A) to update customer statistical information. Step Action Navigate to the Statistics History Update program (R03B16A) on the Credit/Collections Management menu (G03B15). Click the Credit/Collections Management menu. Click the Statistics History Update menu. Use the Available Versions form to select a version of the batch program. In your work environment, the system might display additional versions. Step Action Click the XJDE0001 option. Click the Select button. Use the Version Prompting form to access data selection and data sequencing for the batch program. If the Data Selection or Data Sequencing options are disabled, you cannot review or change the data selection or sequencing for the version. Do not change the data selection or data sequence of the program. Step Action Click the Submit link. Use the Processing Options form to set parameters for how a batch program processes data. Processing options are unique to a version. You should review processing options to ensure that the settings are correct. Use the DSO Calculation Method processing option to specify how you want the system to calculate the value in the Days Sales Outstanding field (DSO). Use the Number of Periods processing option to specify the number of fiscal periods, based on the credit and collection date pattern, that you want the system to use to calculate the value in the Days Sales Outstanding field (DSO). Step Action Click the Calculations tab. Use the Calculate DSO processing option to calculate the value in the Days Sales Outstanding field (DSO). To calculate this value, the system retrieves the values in the DSO Calculation Method and Number of Periods processing options. Because the system performs complex calculations to arrive at DSO figures, you might decide to calculate DSO periodically, instead of nightly, to reduce the overall processing time. Use the Calculate High Balance processing option to calculate the high balance amount. The system runs the Calculate High Balance program (R03B162) when you select this option. If you do not need to calculate the high balance each time that you update statistics, you can save processing time by setting this option to blank and then activating it only when necessary. Values are: • Blank: Do not calculate the high balance. • 1: Calculate the high balance. The system calculates the high balance by using the beginning balance (the ending balance of the last period) and adding invoices and subtracting receipts for each day between the last day of the ending balance and the day that you run the program. If the ending balance for a day is higher than the previous day’s ending balance, then it becomes the new high balance amount. Click the Summary Record tab. Use the Number of Days for Summary processing option in conjunction with the Thru Date processing option to specify the subset of detail records from the F03B16 table that you want the system to summarize into records to include in the F03B16S table. Use Thru Date processing option in conjunction with the Number of Days for Summary processing option to specify the subset of detail records from the F03B16 table that you want the system to summarize into records to include in the F03B16S table. Click the OK button. Use the Printer Selection form to identify printer information for the report. In your work environment, the printer settings will be different. Step Action The system does not create a PDF for this report. Click the OK button. You have successfully used the Statistics History Update program (R03B16A) to update customer statistical information. End of Procedure.