Accounts Receivable (CC00)

The CC00/Accounts Receivable folder defines the parameters that effect the Accounts Receivable (AR) system.

The following list defines every field on the Accounts Receivable folder:

1. In the Charge Interest when Overdue section:

   Select the option that identifies the overdue balance upon which Interest charges begin calculating. This is applicable for Customers with the Charge Interest field set to 'M' (Memo on Statement) or 'I' (Produce Interest Invoice) in Customer Master (SU13). Interest will only be calculated on Invoices that match the overdue level specified on this window.

   Valid options include:

   • (1-30 Days) Interest charges are calculated on all items OVERDUE.

   • (31-60 Days) Interest charges are calculated on all items that are more than 30 days OVERDUE.

   • (61-90 Days) Interest charges are calculated on all items that are more than 60 days OVERDUE.

   • (91-120 Days) Interest charges are calculated on all items that are more than 90 days OVERDUE.

   • (121+ Days) Interest charges are calculated on all items that are more than 120 days OVERDUE.

2. The Interest Rate (Percent) field is used by AR80 to calculate the Interest amount applicable to overdue accounts. An Interest invoice will be generated and posted to the customer’s account and will update the AR sub-ledger and Interest Income GL accounts accordingly.
   • The Interest Rate entered here is ONLY used by the AR80 program. If calculating 'Memo Interest' or 'No Interest' on your overdue accounts, this field can be left blank. The system will default this value to 0.00 in this case.

     Note: The Interest rate for 'Memo Interest' is maintained as a Restriction in Print Statements (AR85).

     For more information on calculating Memo vs Generated Interest Invoices, click here.

3. In the Aging of Credits Method section, enter the code that controls the aging of credit items. You have the following options from which to select:
   • Date - Credit items will be aged according to the item’s posting date.

   • Oldest - Credit items will be aged against the oldest aging balances.

     Note: The option selected here impacts the aging/overdue balances only; it does not control the application of credit items to debit items behind the scene within the Open Item Master file.

4. The Current Period End Date field is only available when running this program for the first time. Enter the Period Ending date for the first open period that will be processed on the system. The date entered must be a valid Period Ending date as previously defined via program CC90. Once established, this date may not be revised. The Close AR Fiscal Period (AR89) program will increment this date to the next closing date as each month end is closed.

5. In the G/L Accounts section:
   • Interest Income - Enter the Interest Income general ledger account number, defined in Maintain Chart of Accounts (GL01). This is the account that is credited whenever a Customer’s payment includes payment of Memo Interest charges. If no record exists for the general ledger account entered, the query will open allowing you to select a valid GL.

6. In the Invoice Display Sequence by section:
   • Invoice No. - The default to print invoice detail lines on the A/R system will be by invoice # sequence.

   • Invoice Date - The default to print invoice detail lines in the A/R system will be by invoice date sequence.

     Note: The default will be read from the master-file but there will be an override option at the report level to change the default from invoice # to invoice date or visa versa.

7. The Aged Trial Balance Method affects how an Invoice (open item) is aged on the Print Aging Report (AR84), Print Overdue Analysis Report (AR83), Print Statements (AR85) and Display Customer Account Details (SU45/C3-Account Detail).
   • Daily - will age open items in 30-day increments based on the Invoice date. On the Aging Report, which reports how OLD an Invoice is, the again columns are captioned:

     Current, 31-60 (days old), 61-90, 91-120, 121+

     On the Overdue Analysis Report, Customer Statements and Display Customer Account Details, which take the Invoice terms into account and report how OVERDUE an Invoice is, the aging columns are captioned:

     Current, 1-30 (days overdue), 31-60, 61-90, 91-120 and 121+

   • Monthly - attempts to age items into the month that they occurred. The captions on the Aging Report, Overdue Analysis Report and Customer Statements print 'Month' captions instead of 31-60, 61-90, etc. For example, the captions on an Aging report printed as of Jan. 31/05 would read:

     JAN/05, DEC/04, NOV/04, OCT/04, SEP/04

     The captions on an Overdue Analysis Report or Customer Statments, which take the Invoice terms into account and report how OVERDUE an Invoice is, printed as of Jan. 31/05 would read:

     Not Due, DEC/04, NOV/04, OCT/04, SEP/04

     Here are a few examples:

     • An Invoice dated Nov/04 with Net 30 terms reports in the DEC/04 column.
     • An Invoice dated Dec/04 with Net 30 terms reports in the Not Due column.
     • An Invoice dated Jan/05 with Net 30 terms reports in the Not Due column.

     Note: Technically, the Monthly option changes the 'Day' portion of every open item to a "15" and ages/calculates overdue analysis as if the item occurred on the 15th of the month.

8. In the No. of Days to Pay - Averaging Method section:

   This section dictates the method used to calculate a customer’s Average Days to Pay statistic, which is reported as part of the Record of Collection information in Customer Inquiry (AR45), Overdue Analysis (AR83) and Print Aging Report (AR84). There are two options:

   • Straight - at month end, the Close AR Fiscal Period (AR89) program is run to close the fiscal month for Accounts Receivable. For each Invoice reduced by a payment during the month, '1' is added to the 'Total # of Payments' and the number of days that the Invoice was outstanding is added to the 'Total # of Days to Pay' in the Record of Collection for the Customer. The Straight method calculates/updates the Average number of Days to Pay field as follows:

     Average Days to Pay =	Total # Days to Pay
     	Total # of Payments

     Here is an example:

     Invoice 1: 31 days outstanding
     Invoice 2: 60 days outstanding
     Invoice 3: 90 days outstanding

     Total # of Payments = 3
     Total # Days to Pay = 181

     Average Days to Pay = 181 / 3 = 60 days (rounded)

   • Weighted - as cash receipts are processed, Print Cash Receipts/Adjustments (AR31) updates the 'YTD Weighted Payment $' and 'YTD Payment $' fields. Whenever Weighted Average Days to Pay is enabled, these fields are used to calculate the value.

     The Payment Value is multiplied by the days the Invoice was outstanding and that value is accumulated in the 'YTD Weighted Payment $' field. The Payment Amount is accumulated in the 'YTD Payment $' field. These fields are used to calculate the Weighted Average Days to Pay as follows:

     Average Days to Pay =	YTD Weighted Payment $
     	YTD Payment $

     Here is an example:

     Inv.	Inv. Date	Pay Date	Pay Amount	*	# Days To Pay	=	Weighted Value	YTD Wgt Value	/	YTD Pay $	=Average Days
     1	Jan 1	Feb 1	10	*	31	=	310	310	/	10	= 31
     2	Jan 1	Mar 1	1000	*	60	=	60000	60310	/	1010	= 59
     3	Jan 1	Apr 1	10000	*	90	=	900000	960310	/	11010	= 87

9. When all of the information is correct, click on Update.

^{Accounts Receivable (CC00/Accounts Receivable)}