About customer ledger ageing reports

You use the Aged past due (AR631000) and its multi-currency version, Aged past due (currency) (AR631100), to determine which documents are overdue for payment and for how long.

These reports show all open documents recorded in the system, regardless of the current business date or the date specified in the Ageing date field in the report window. That is, the reports show open customer ledger documents, even if they are posted to periods later than the ageing date period. The documents are grouped by statement cycle and by customer.

For each customer, the report shows the outstanding customer balance in the system and lists open documents, which are broken down by ageing periods. That is, the balances of the documents are sorted into columns that represent ageing buckets. The system forms ageing buckets by using the ageing periods defined for the customer's statement cycle.

In the report, debit documents are aged based on their due date and the ageing date specified for the report (in the Ageing date field). If the due date of a debit document is earlier than the ageing date, the document balance is reflected in the Current column of the report. Otherwise, the document balance is reflected in the corresponding ageing bucket.

Credit documents are aged based on their document date and the ageing date specified for the report if the Age credits check box is selected in the Customer ledger preferences (AR101000) window. By default, the check box is cleared and the credit amounts are shown in the Current column. With the check box selected, if the document date of a credit document is earlier than the ageing date, the document balance is reflected in the Current column of the report. Otherwise, the document balance is reflected in the corresponding ageing bucket.

The Aged outstanding (AR631500) and its multi-currency version, Aged outstanding (currency) (AR631600), are designed to show when you should expect to get payments for the outstanding documents.

These reports show all open documents recorded in the system, regardless of the current business date or the date specified in the Ageing date field in the report window. That is, the reports show open customer ledger documents, even if they are posted to periods later than the ageing date period. The documents are grouped by statement cycle and by customer.

For each customer, the report shows the outstanding customer balance in the system and lists open documents, which are broken down by ageing periods. That is, the balances of the documents are sorted into columns that represent ageing buckets. The system forms ageing buckets by using the ageing periods defined for the customer's statement cycle.

In the report, debit documents are aged based on their due date and the ageing date specified for the report (in the Ageing date field). If the due date of a debit document is later than the ageing date, the document balance is reflected in the Current column of the report. Otherwise, the document balance is reflected in the corresponding ageing bucket.

Credit documents are aged based on their document date and the ageing date specified for the report if the Age credits check box is selected in the Customer ledger preferences (AR101000) window. By default, the check box is cleared and the credit amounts are shown in the Current column. With the check box selected, if the document date of a credit document is later than the ageing date, the document balance is reflected in the Current column of the report. Otherwise, the document balance is reflected in the corresponding ageing bucket.

You use the Aged period sensitive (AR630500) to determine the state of the open documents at the end of a particular period.

The report shows the customer ledger documents that are open at the end of the financial period you select in the Financial period field in the report window. The documents are grouped by statement cycle and by customer.

The report ages the balances of the debit and credit document in the same way as the Aged past due (AR631000) does. For details, see the Aged past due section in this topic.