Unpaid Vendor Invoices – Aging

The Unpaid Vendor Invoices – Aging report was developed in order to support accounting and purchase departments obtaining a complete and detailed image about the aging of open invoices received from suppliers.

How to Run Unpaid Vendor Invoices – Aging

  1. Run Unpaid Vendor Invoices - Aging from Tell me.
  2. Fill in mandatory filters:
  • Ending Date – the ending date used by the system to calculate remaining amount of the invoice.
  1. Fill in other filters:
  • No. of the vendor from Vendor tab – in order to display records only for certain vendors;
  • Currency Code from Vendor Ledger Entry tab – in order to show only documents posted in a certain currency; this filter must be filled in when the report is run for vendors having transactions in multiple currencies;
  • Other vendor filters - in order to show records only for certain vendors.
  1. Check options:
  • Currency – the report will show open invoices posted in foreign currency, with amounts calculated in transaction FCY.
  • Local Currency – the report will show open invoices posted in local and foreign currency, with amounts calculated in LCY.
  • Show Details – details about invoices are displayed.

Expected Result

Data available in the report consists of:

  • Vendor name;
  • Document number and posting date;
  • Currency code;
  • Invoice due date;
  • Remaining invoice amount (at Ending Date).

Based on invoice due date and selected report date (Ending Date), the value of the remaining amount is displayed in one of the following date intervals:

  • At date;
  • under 15 days;
  • between 16-30 days;
  • between 31-60 days;
  • between 61-90 days;
  • between 91-180 days;
  • between 181-360 days;
  • over 360 days.

The user can choose to display:

  • details about invoices or only total values for each vendor;
  • values in local or in foreign currency (only for transactions in FCY).