This topic provides an example of the A/R Aging Report (RAG) and definitions of the fields on the report. For more information about RAG and procedure steps for running the report, click here to go to the online help topic. This report is available from both the Eagle Browser and Network Access.
The following is an example of the report. There are two pages, the Detail page and the Totals page. Click a field in the report to take you to the field definition.
RAG Detail page
RAG Totals page
The following is a list in alphabetical order of the fields on the RAG report.
RAG Detail page:
Account Name— The name of the account from the customer record in Customer Maintenance (MCR).
Action— This field is only included if the report is run with Option P (Purge). It is an explanation of the purge activity applied to a specific transaction.
Added— Balance Forward and Revolving accounts only. A B-type transaction was added to the customer account.
Adjusted— Balance Forward and Revolving accounts only. An existing B-type transaction was changed.
Deleted— The transaction was deleted.
Unchgd— Balance Forward and Revolving accounts only. An existing B-type transaction was not changed.
Bal Subj to Chrg— Balance subject to finance charge. The dollar amount upon which the RAG report calculates the finance charge for the account.
Balance— The total amount owed by this account based on the Items to Include and Closing Date used when the report was run.
Contact— The contact name for this account from the account record in Customer Maintenance (MCR).
Cr Limit— Credit limit, for this account from the account record in Customer Maintenance (MCR).
Current— The total dollars of transactions with due dates after the Closing Date but on or before the next close date.
Cust— The customer number of the account.
Doc#— Document number, a unique number assigned to the document.
Fin Chrg— Finance charge. The dollar amount of the finance charge and/or late fee document that was added to the account.
Future— The total dollars of transactions with due dates after the close date.
Job— The job number of the account.
Lst Pmt $— Last payment dollars. The dollar amount of the last payment, from Customer Maintenance (MCR).
Lst Pmt Dt— Last payment date. The date of the last payment, from Customer Maintenance (MCR).
Options— The option codes used when running this report. For a definition of each Option, click here to go to the help topic.
Past Due— Amounts that are past due for this account. The sum of these categories (1 -30, 31 - 60, 61 -90, over 90) equals the total dollar amount of transactions that have due dates on or before the Closing Date used when the report was run.
Phone Number— The phone number of the account from the customer record in Customer Maintenance (MCR).
RAG Totals page:
Accounts Receivable Total— The sum of the individual account totals included on the report.
Cumulative %— The accumulated percent of the TOTAL amount in each aging bucket, from oldest (Over 90) to newest (Future), is added to the running total. Note that the highest percentage may not equal 100% due to rounding.
Curr Min— Current Minimum. For revolving charge accounts, this is a total of the current minimum payments calculated by this RAG report.
Finance Charges Calculated— The total number of F type documents calculated by this RAG report. If the report was run with Option F, then it is also the number of F type documents added to the Open Item file.
Finance Charges Calculated/Amount— The total dollar amount of F type documents calculated by this RAG report. If the report was run with Option F, then it is also the total dollar amount of F type documents added to the Open Item file.
Future— The sum of the Future fields for all accounts included on this RAG report.
Now Due— For revolving charge accounts, the total of all minimum payments now due. The now due amount is calculated by adding together Curr Min + Past Due + amount over credit limit.
Number of Accounts— The total number of customer accounts that were selected for this RAG report, based on how the report was run (Options, From / To, etc.).
Number of Records Purged— A count of the documents marked as Deleted in the Action column of this RAG report.
Options— The option codes used when running this report. For a definition of each Option, click here to go to the help topic.
Outstanding— For revolving charge accounts, the total amount that is currently payable. Outstanding is calculated as Total minus Future.
Past Due— For revolving charge accounts, the total of the Past Due Min fields for accounts included on this RAG report.
Period %— The dollar value for each aging bucket expressed as a percent of the total accounts receivable amount.