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 This topic documents fields and other elements in this window that either are not self-explanatory or require additional information. End of the note. |
Specify the currency for displaying the report results. |
The aging date specified in the selection criteria window |
Specify by which date to calculate the age of the receivables: due date, posting date, or document date of the document/journal entry. |
Displays the document type and provides a link to the document window |
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. |
Displays the business partner reference number |
The number of days between the due date and the aging date |
Displays the original document total, the original total of the installment, or the total value of a manual journal entry line |
Displays the total open amount of debt Figures in brackets indicate the payments received from customers that have not been applied for the period. |
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. |
Displays the amount of interest that should be paid |
Displays the code of the project to which the document's journal entry is assigned |
Displays the code of the default payment method assigned to the business partner on the Accounting tab of the Business Partner Master Data window |
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.
|
Displays the dunning level assigned to the debt |
Select the checkbox in this column to create a dunning letter for that document. |
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:
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. |
Displays the sum of amounts listed in one column |
Displays the percentage of open receivables for each time interval |