SA Administrator Options - Customer - Balances overview

Customer Setup uses the number of days you specify for the aging periods to determine the correct length of time in each period. The Customer Entry Roll Balances Report uses the number of days you specify for each aging period to determine which invoices to roll into an older period. Each time the balances are rolled, the dates roll forward as well.

In addition to manually specifying the number of days, these options are available to determine the aging periods:

• Click Set Per Month to automatically calculate the appropriate number of days for periods 1-4. This is based on the number of days in the current month and the number of days in the past three months.
• Schedule the Customer Administration Set Aging Periods Report to assign the number of days in each aging period to coincide with the calendar month. Schedule this report should as a stored report. Run it automatically each month before rolling balances in the Customer Entry Roll Balances Report to automatically update the values at the end of each period. This report calculates the appropriate number of days for Periods 1-4.

  This is based on:

  1. the number of days in the current month, which is Period 1
  2. the number of days in the past three months, which is Periods 2 through 4, based on the current system month

On this page you can also perform these actions:

• Indicate how service charges, miscellaneous credits, and unapplied cash are applied to period balances when you run the Customer Entry Roll Balances Report.
• Indicate whether to include COD totals in the total balance on the customer record.
• Indicate how to adjust the cash discount and due dates when the cash discount date is greater than the invoice due date.