Use this field on the RAG report to specify what you want the report to do.
B = Create Business Advisor Data. This option creates the accounts receivable data for Business Advisor. Use this option with Select Options set to CAZ, Print Options set to T, and Items to Include set to A, and the Closing Date set to blank.
Run the report with these options at least once a week keep the Business Advisor data up to date.
C = Close (Prepare for Stmts). To determine the break point between the future and current aging buckets, the system looks at the Closing Date field and uses the same day of the next month.
For example: Your Closing Date is 6/25/99. Transactions due on or before 7/25/99 are current. Transactions due after 7/25/99 are future.
If you do not use this option, the system determines the break point between the future and current aging buckets as follows:
Look at the Closing Date field and the Closing Date field in Terms Maintenance (MTM) for each customer.
Use the next occurrence of the terms closing date AFTER the RAG closing date.
For example:
The Closing Date for RAG is 6/25/01. In Maintain Terms (MTM), the Closing Date is the 28th. Transactions due on or before 6/28/01 are current. Transactions due after 6/28/01 are future.
The Closing Date for RAG is 6/25/01. In Maintain Terms (MTM), the Closing Date is the 24th. Transactions due on or before 7/24/01 are current. Transactions due after 7/24/01 are future.
This option also affects the due date of your finance charges. The system looks at the Closing Date field and assigns a due date of the same day of the next month.
For example: Your Closing Date is 8/25/01. The system assigns a due date of 9/25/01 to the finance charges.
If you do not use this option, the system assigns a due date of the next occurrence of the terms closing date (in Maintain Terms--MTM).
For example: Your Closing Date is 6/25/01. In Maintain Terms (MTM), the Closing Date is the 25th. The system assigns a due date of 7/25/01 to the finance charges.
F = Finalize. For balance forward and open item accounts, update aged account balances in Customer Maintenance, the Payment tab, to the aged balances calculated by this report.
If you have open item accounts, you must use Update Option H in addition to F so that when you are applying unapplied payments and credits in backoffice ROA, the system has the "Last Updated" aging date. The "Last Updated" date is required in order to apply the payment to the same aging bucket as the applied-to invoice.
For revolving charge accounts, update the Current Min, Past Due Min, and Min Now Due fields in Customer Maintenance, the Credit tab. If you use this option with option X, the system posts the finance charges to the customer's account.
You can use this option more than once during a statement period (for all account types except revolving charge).
H = Update Credit History in MCR. You should run this option only once each month. The best time to run it is after you run statements. To ensure that all accounts are updated, use this option with Select Options A, C, and Z.
When updating the # of Times field, the system only updates the aging column of the oldest portion of the account balance.
For example: An account has a positive balance over 90 days past due and a positive balance that is 1-30 days past due. The system adds 1 to the # of Times field in the Over 90 column. It does not add 1 to the # of Times field in the 1-30 column.
When updating the Last Occur field, the system uses the RAG closing date. If the closing date is equal to or less than any of the account's Last Occur dates, the system will not update the expanded credit history. This prevents you from updating the Last Occur field more than once during the same month.
If you use a closing date that is equal to or less than one of the Last Occur dates, the following warning message prints on the report: Warning: Credit History not updated--RAG (H) already ran for this month. Account should be XXX not YYY. (XXX = the correct aging bucket, for example, Over 90; YYY = the aging bucket if you had updated the history twice in one month, for example, 61-90)
P = Purge transaction detail from the customer's account. A special column (ACTION) prints on the right side of the report. It indicates what type of purge the system completed for a specific transaction. The system purges transactions based on the account's balance method and the Past Due Periods Kept After Purge field in A/R Control File Maintenance (MCT).
For open item accounts, the system purges any transactions that:
have been fully paid
are not disputed
meet the Past Due Periods Kept After Purge field requirements in MCT
have a valid apply-to number (only for transaction type A, C, and P)
For balance forward accounts, the system creates a balance forward transaction and deletes individual transactions that:
are not disputed
meet the Past Due Periods Kept After Purge field requirements in MCT
For revolving charge accounts, the system:
creates a current balance from those items that have appeared on a statement
deletes individual transactions if they are not disputed
R = Recalculate Running Balance. Reset the customer's running balance so it equals the sum of the open items. Use this option with Option F.
V = Recalculate Variable Discounts. Recalculate the terms discounts using the appropriate discount percentages in Maintain Terms (MTM). The system:
adds the customer's purchases for the month (subtracting any credits or negative adjustments)
determines the customer's terms discount level (from Maintain Terms--MTM)
updates the Terms Discount PTD field in Customer Maintenance, the Sales tab
updates the Terms Disc field in Open Item Maintenance (MOI) and the Discount Amount field in the Transaction Viewer with the allowable discount amount
You can use this option more than once during a statement period.
X = Calculate Finance Charges. Calculate finance charges and late charges, and print a list of them. If you don't use Option F with this, the report allows you to preview the finance charges before you post them to the customer's account. If you use this with Option F, the system posts the finance charges to the customer's account.
Y = Age Unapplied Credits for Open Item Accounts on Due Date. To use this update option, you must set option 3556 “Calculate due dates on unapplied credits same as invoices” set to Yes in Options Configuration so that unapplied credits have a due date based on terms. Without option Y, unapplied credits age based on Due Date, but if a credit balance exists, the system applies the credit to the next most current aging bucket.