Receivables Aging - CI_RCVAGA
Parameters
Parameter | Parameter Code | Description |
Cutoff Date | P_CUTOFF_DATE | The date from which the arrears buckets are calculated. If no value is entered, the default is the current date minus 7 days. |
First Bucket High Limit | P_B1_LIMIT | High limit of first bucket. |
Second Bucket High Limit | P_B2_LIMIT | High limit of second bucket. |
Third Bucket High Limit | P_B3_LIMIT | High limit of third bucket. |
Report Description
This report lists all accounts and their arrears information as of the input cutoff date using a balance forward accounting method.
Outstanding debt is placed into the buckets provided as input using the age of the debt as of the cutoff date. Credits are applied to the oldest debt first. For each account a separate bucket is used to display new charges. In addition, the total accounts receivable balance is displayed for each account.
Note:
Performance Consideration. If your implementation chooses to use this report, you may consider adding an index to the CI_FT table on ARS_DT to aid in performance. When making this decision, carefully weigh the benefit of improving report performance against the possible degradation to the performance of day-to-day processing as a result of defining a new index. In addition, many companies opt to create a reporting database that is a shadow of production to ensure that indexes defined to benefit reports may be created without any affect on the production environment.
Parent topic