Field

Description/Activity

Currency

Click  and choose the currency in which you want to display the report results.

The available options include:

●     Local currency

●     System currency

●     Business partner currency

●     Any additional currencies defined in SAP Business One

Aging Date

Displays the aging date entered in the selection criteria window.

Age By

Choose whether you calculate the age of the receivable according to the due date, posting date, or document date of the document/journal entry.

Customer Code

Displays the code of the customer.

Click  to open the corresponding Business Partner Master Data.

Customer Name

Displays the name of the customer.

Total

Displays the total amount of open receivables.

Figures in brackets mean that you have already received payments from a customer that exceed the amount of the receivables for the period.

Future Remit.

Displays all open receivables owed by the customer according to the date selected in the Age By field 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.

Due Date is selected in the Age By field.

The Aging Date is April 28th.

Since the invoice is due after the aging date, the invoice amount is displayed in the Future Remit column..

Letter

Indicates whether a dunning letter was created.

This column is displayed only when generating the report by Sales Documents and by Due Date

Time Intervals

These four columns are constructed according to the specifications you made in the Interval field in the selection criteria window.

SAP Business One displays the relevant open receivables in four columns for the time interval. The amount of future remit is first subtracted from the total sum of receivables.

·         Days – Each column represents the number of days entered in the selection criteria window starting from the aging date and backwards. The fourth column includes open receivables for the days prior to the first three columns.

·         Months – Each column represents one month starting from the aging date month and backwards. The last column includes open receivables for months prior to the first three months.

·         Periods – Each column represents one period (as defined in Administration ® System Initialization ® Posting Periods tab) starting from the aging date period and backwards. The last column includes open receivables for periods prior to the first three periods.

If the number of periods in your company is less than the 4, the non-relevant columns will be titled as Not Valid.

Doubtful Debt

Displays the doubtful debt amount if exists.

Top Total Row

The top total row displays the sum of amounts listed in one column.

Bottom Total Row

The bottom total row displays the percentage of open receivables for each time interval.