Show TOC

Object documentationVendor Liabilities Aging Report Locate this document in the navigation structure

 

SAP Business One displays the results of the report according to your selection criteria (see Vendor Liabilities Aging).

It displays documents together with the respective liabilities. The report provides the size of the vendor liability and the 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.
Vendor Liabilities Aging Report
Currency

Specify the currency for displaying the report results.

Aging Date

Displays the aging date entered in the selection criteria window

Age By

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

Vendor Code

Displays the vendor code as defined in the business partner master data

Vendor Name

Displays the name of the vendor, as defined in the business partner master data

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

Future Remit

Displays all open liabilities owed to vendors 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

You have an open A/P invoice for USD100, due on May 1st.

Due Date is selected in the Age By field.

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.
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 liabilities 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 the liabilities.

The last column in each category includes open liabilities for the respective category prior to the first columns.

  • Days – Each column represents the number of days entered in the selection criteria window, moving back from the aging date.

  • Months – Each column represents one month, moving back from the aging date month.

  • Periods – Each column represents one period as defined in  Administration   System Initialization   Posting Periods  , moving back from the aging date period.

[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