Accounts Receivable Analytical Reports

 

AR Analytical Reports

Concept

Print analytical reports to review and analyse the following information:
• Totals by customer and pay status
• Collections
• Credit limits
 • Customer trends and statistics

The following analytical reports are available in the AR system:
• Open AR Summary Analysis (R03B155)
 • Statistical Trend Analysis (R03B165)

Procedure

In this task, you will review the Open A/R Summary Analysis report (R03B155).

Step

Action


Navigate to the Open A/R Summary Analysis program (R03B155) on the AR_Accounts Receivable menu.


Click the Open A/R Summary Analysis program.


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.


Tick the “Data Selection” box and click the Submit button.


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 Open Amount to be Exceeded processing option to specify the amount against which the customer balance will be compared to determine whether to print the customer on the report. The system uses the currency specified in the Open Amount processing option for the amount specified in this processing option. The system retrieves the exchange rate to use to restate customer balances from the Currency Exchange Rates table (F0015), and then compares the restated balance with the amount specified in this processing option to determine whether to print the customer on the report. The system prints only customer balances with amounts greater than or equal to the amount specified in this processing option.


Use the Currency Code of Open Amount processing option to specify the currency of the amount entered in the Open Amount to be Exceeded processing option. The system calculates open amounts based on the currency specified, and then compares the customer’s balance with the amount entered in the Open Amount to be Exceeded processing option to determine whether to print the customer on the report.

If you leave this processing option blank, the system uses the currency code USD.


Use the Standard or Insured Credit Limit processing option specify which customer records will be printed on the report. Values are:

• Blank: Print all records.

• 1: Print records with the open amount greater than or equal to the credit limit that is set up on the customer master record (F03012).

• 2: Print records with the open amount greater than or equal to the insured credit limit.


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.


Click the OK button.


Access and review the Open A/R Summary Analysis report.


Use this report to review these types of information:

• Account balances at the parent or child level.

• Open amounts and their associated aging categories.

• Customers who have exceeded their standard credit limit at the customer and company level (based on how you set the processing options).

• Customers who have exceeded their insured credit limit.

• Customers who are under their credit limit.

• The customer’s currency of open amounts.

• Summary information at the company level.


When you print the report, the system uses information from the Credit and Cash Management table (F03B15) and the Credit Insurance table (F03B29).


You have reviewed the Open A/R Summary Analysis report (R03B155).

End of Procedure.