Show TOC

Object documentationCustomer Receivables Aging Report Locate this document in the navigation structure

 

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 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 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:

  1. Highlight the customer / invoice row including the doubtful debt.

  2. 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.

  3. Enter the account code for the second row.

  4. 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 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