Statement cycles (AR202800)

Search line in list window

If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view.

There are two types of search fields:

White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or % and get different results:
- space: the result contains the words in any order,
- %: the result contains the words in the specific order, and the % functions as a wildcard as well.
Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.

The window toolbar

Button	Description
Regenerate last statement	Initiates the process of again generating the most recent statement with an updated date.

The 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 30 characters can be used.
Schedule type	The day 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 1 field. Twice a month: The statement will be generated twice a month, on the days specified in the Day of month 1 and the Day of month 2 fields. A fixed day of the month: The statement will be generated on the day specified in the Day of month 1 field. The end of the month: The statement will be generated on the last day of each month. The end of the financial period: The statement will be generated on the last day of each financial period of the current financial year.
Day of month 1	The day of each month when the statement should be generated. The field is available if either Fixed day of the month or Twice a month is selected in the Schedule type field.
Day of month 2	The day of each month when the statement should be generated for the second time. This field is available only if the Twice a month option is selected.
Day of the week	The day of each week when the statement should be generated. This field is available only if Weekly is selected in the Schedule type field. The default value is Sunday.
Last statement date	A read-only field 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	If you do not want the statements with no details to be printed, unselect this check box for statement cycles. After the process of preparing the statement, you can view these statements with the Do not print and Do not email check boxes selected in the Statement history details (AR404300), Customer statement history (AR404600), and Print statements (AR503500) window.

The Ageing section

You use this section to define four periods for ageing the customer ledger document. Each period is defined by the following elements.

Element	Description
Use financial periods for ageing	A check box that indicates (if selected) that the system uses the financial periods as ageing periods in customer statements and customer ledger ageing reports. If this check box is selected, the system uses the financial period to which the statement date or the ageing date belongs as the first ageing period.
Ageing period (days)	In the fields you can select the current period or the number of days the documents to be included overdue. The first period includes documents that are past due or outstanding for the specified number of days or fewer. The second and third periods include documents that are past due or outstanding for the number of days (or fewer) specified in this box and greater than the number of days specified for the previous period. The fourth period includes documents that are more than x days past due or outstanding, where x is the number of days specified for the third period.
Description	You can write and edit the descriptions of the defined ageing periods. The descriptions will be printed to the customer statement reports.
Age based on	Select whether the age of the documents is based on their due date or document date.

The Finance charge settings section

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 in the Customer ledger preferences (AR101000) window is selected; if not, the charges from the customer class will be applied.