Statement Cycles

Form ID: (AR202800)

You can use this form to create statement cycles, which make it possible to track customers' outstanding balances and send electronic or printed statements to the customers. You can define five aging periods for AR documents and use them to prepare an accounts receivable aging schedule. Alternatively, you configure the statement cycles so that the system will age documents by financial periods. By analyzing your accounts receivable aging schedule, you can more easily identify potential cash flow problems.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Regenerate Last Statements Initiates the process of again generating the most recent statements of customers of the selected statement cycle with an updated date.
Delete Last Statements Deletes the most recent statements of customers of the selected statement cycle.
When you click this button, a warning message is displayed, in which you can click Delete or Cancel. Once you click Delete, the system deletes the last generated customer statements of the selected statement cycle.
Note:
This button is available only for the users with the Financial Supervisor role assigned on the Users (SM201000) form.

Statement Cycle Area

You use the elements in this area to define a new statement cycle or to select an existing one and view its details.

Table 1. General Settings Section
Element Description
Cycle ID The unique identifier of the cycle. An alphanumeric string of up to 10 characters can be used.
Description A detailed description of the statement cycle. An alphanumeric string of up to 60 characters can be used.
Schedule Type The day or days when the statement should be generated. The following options are available:
  • Weekly: The statement will be generated each week, on the day specified in the Day of Week box.
  • Twice a Month: The statement will be generated twice a month, on the days specified in the Day of Month 1 and Day of Month 2 boxes.
  • Fixed Day of Month: The statement will be generated each month, on the day specified in the Day of Month 1 box.
  • End of Month: The statement will be generated on the last day of each month.
  • End of Financial Period: The statement will be generated on the last day of each financial period of the current year—that is, on the End Date specified for each financial period on the Master Financial Calendar (GL201000) form.
Day of Week The day of each week when the statement should be generated. This box is available only if Weekly is selected in the Schedule Type box. The default value is Sunday.
Day of Month 1 The day of each month when the statement should be generated. The box is available if either Fixed Day of Month or Twice a Month is selected in the Schedule Type box. The default value is 1.
Day of Month 2 The day of each month when the statement should be generated for the second time. This box is available only if the Twice a Month option is selected in the Schedule Type box. The default value is 1.
Last Statement Date A read-only box that displays the date when the statement was generated most recently.
Require Payment Application Before Statement A check box that indicates (if selected) that the payments should be applied to invoices before each statement is processed.
Print Empty Statements

A check box that indicates (if selected) that the system will print and email empty statements (that is, the statements of the Open Item type with no open documents and statements of the Balance Brought Forward type in which there was no activity in the period and the outstanding amount from the previous statement was zero). If the check box is cleared (the default value), the system will generate but not print or email empty statements.

Note:
Selecting this check box for a statement cycle may cause performance degradation when the system prepares customer statements for this cycle.
Table 2. Aging Settings SectionYou use this section to define the periods for aging the AR documents to which this statement cycle applies.
Element Description
Use Financial Periods for Aging

A check box that indicates (if selected) that the system uses the financial periods as aging periods in customer statements and accounts receivable aging reports. If this check box is selected, the system uses the financial period to which the statement date or the aging date belongs as the first aging period.

Aging Period (Days) In general, the number of the starting and ending day of the aging period. (The first and last rows, respectively, contain Current and Over x, where x is a number of days.) The system suggests the starting days of aging periods based on the ending day that you have specified for the previous aging period. The aging periods are defined as follows:
  • The Current aging period (the zero period in the first row) includes the documents that are not overdue.
  • The first, second, and third aging periods (in the second, third, and fourth rows) include the documents that are overdue for a number of days that is not less than the specified starting day and not more than the specified ending day of the aging period. For the first aging period, the starting day is always 1. After you enter the ending day for the first period, the system suggests the starting and ending days for all other periods, based on the assumption that all the aging periods will have the same length.
  • The fourth period (in the last row) includes the documents that are past due for a number of days that exceeds the value specified in the Over box.

If you decide to age documents based on their document dates, the system will distribute documents to the aging buckets by using the time passed from the document date until the aging date. For more details, see Preparation of Dunning Letters: Using the AR Aging Report.

These settings are available only if the Use Financial Periods for Aging check box is cleared.

Description The text (up to 60 characters) to be used for the particular aging period in a customer statement based on this statement cycle. If you leave this box empty for a particular aging period, the system will automatically generate the aging period's description in each customer statement based on the aging period settings.

If the Use Financial Periods for Aging check box is selected for the cycle, the system will use the descriptions of the applicable financial periods instead of those specified for the aging periods' descriptions.

In AR aging reports, the system always uses system-generated descriptions instead of the descriptions specified in this box.

These settings are available only if the Use Financial Periods for Aging check box is cleared.

Age Based On

The type of date the system will use to determine the appropriate aging bucket in customer statements and AR aging reports for outstanding invoices, debit memos, and overdue charges. The following options are available:

  • Due Date (default): The system compares the due date of the outstanding document with the statement date or the aging date.
  • Document Date: The system compares the document date of the outstanding document with the statement date or the aging date.

Also, if the Age Credits check box is selected on the Accounts Receivable Preferences (AR101000) form, the system will age unapplied credit documents by their document date in customer statements and AR aging reports. For more information, see the Accounts Receivable Preferences topic and Preparation of Dunning Letters: Using the AR Aging Report.

Table 3. Finance Charge Settings SectionThis section is available if the Overdue Charges feature is enabled on the Enable/Disable Features (CS100000) form.
Element Description
Apply Overdue Charges A check box that indicates (if selected) that calculation of overdue charges is required for all customers assigned to the statement cycle.
Require Overdue Charge Calculation Before Statement A check box that indicates (if selected) that the system should calculate overdue charges before processing a statement.
Overdue Charge ID The overdue charges to be used for customers assigned to the statement cycle. The overdue charges that are actually applied depend on whether the Set Default Overdue Charges by Statement Cycle check box on the Accounts Receivable Preferences (AR101000) form is selected; if not, the charges from the customer class will be applied.