Customer Receivables Aging Report

SAP Business One displays the results of this report according to your selection criteria (see Customer Receivables Aging).

It displays documents together with the respective receivables. The report provides the value of the debt the customer has acquired and the length of time that the debt has remained unpaid.

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.

Customer Receivables Aging Report

Currency
Specify the currency for displaying the report results.

Aging Date
The aging date specified in the selection criteria window

Age By
Specify by which date to calculate the age of the receivables: due date, posting date, or document date of the document/journal entry.

Type
Displays the document type and provides a link to the document window

Installment No.
Displays the successive number of the installment Example If a document contains three installments, each installment is displayed in a separate row, and this field displays the value 1, 2, or 3, accordingly. End of the example.

BP Ref. No.
Displays the business partner reference number

Number of Days Outstanding
The number of days between the due date and the aging date

Original Account
Displays the original document total, the original total of the installment, or the total value of a manual journal entry line

Balance Due
Displays the total open amount of debt Figures in brackets indicate the payments received from customers that have not been applied for the period.

Future Remit
Displays all open receivables owed by the customer according to the date selected in the Age By field and for which the date specified in the Aging Date field has not yet been reached Example The customer has an open A/R invoice for USD100, due on May 1st. In the Age By field, Due Date is selected. The Aging Date field is set to April 28th. Since the invoice is due after the aging date, the invoice amount is displayed in the Future Remit column. End of the example.

Interest
Displays the amount of interest that should be paid

Project Code
Displays the code of the project to which the document's journal entry is assigned

Payment Method Code
Displays the code of the default payment method assigned to the business partner on the Accounting tab of the Business Partner Master Data window

[Time Intervals]
SAP Business One displays the relevant open receivables in columns representing the specifications you made in the Interval field in the selection criteria window. The amount of future remit is first subtracted from the total sum of receivables. The last column in each category includes open receivables for the respective category prior to the first columns. Days – Each column represents the number of days entered in the selection criteria window, starting from the aging date and moving back. Months – Each column represents one month, starting from the aging date month and moving back. Periods – Each column represents one period, as defined in Administration System Initialization Posting Periods , starting from the aging date period and moving back.

Dunning Level
Displays the dunning level assigned to the debt

Dunning Letter
Select the checkbox in this column to create a dunning letter for that document.

Doubtful Debt
Displays any existing doubtful debt amount The calculation for this field depends on the definitions in the Doubtful Debts - Setup window. The sum of the invoices for each range of days is multiplied by the percentage defined for this range of days. In this report you are able to issue a journal entry to credit the customer for the doubtful debt. To create a journal entry for a doubtful debt, proceed as follows: Highlight the customer / invoice row including the doubtful debt. Right-click the row and choose Journal Entry. Alternatively, from the menu bar, choose GoTo Journal Entry . A Journal Entry window opens. The first row in the journal entry includes the customer code, the customer name, and the amount of the doubtful debt to be cleared in the Credit column. Enter the account code for the second row. Change the amounts in the rows or proceed to the end of the second row to complete the amount in the Debit column in order to balance the journal entry. Note The entry will be recorded in both the customer amount and the control account that was set for the customer in the business partner master data. End of the note.

[Top Total Row]
Displays the sum of amounts listed in one column

[Bottom Total Row]
Displays the percentage of open receivables for each time interval

Go to Page
Enter a page number and press `Tab` to display the data in this page. Note The input number must be a number between 1 and the maximum page number. End of the note. Note This field is available when you select the Display in Pages checkbox in the Customer Receivables Aging – Selection Criteria window. End of the note.

Display <Number> Rows
From the dropdown list, select a number of rows that you want to display in the table as one page. Note The number that you select decides the row number shown in the following four buttons: First <Number> Rows – Choose this button to display the data in the first page of the table. This button is disabled if the current display is the first page. Previous <Number> Rows – Choose this button to display the data in the previous page of the table. This button is disabled if the current display is the first page. Next <Number> Rows – Choose this button to display the data in the next page of the table. This button is disabled if the current display is the last page. Last <Number> Rows – Choose this button to display the data in the last page of the table. This button is disabled if the current display is the last page. End of the note. Note This dropdown list is available when you select the Display in Pages checkbox in the Customer Receivables Aging – Selection Criteria window. End of the note.

View
Select the appropriate view to display the data: Summary – Select the Summary option to display each item data consolidated in one row in the table including the basic information. Note that this option is selected by default. Detailed – Select the Detailed option to display detailed transactional data for each item. Note This dropdown listis available when you select the Display in Pages checkbox in the Customer Receivables Aging – Selection Criteria window. End of the note.