Introduction
This page displays the account payable report. You can view the report by defining one or more of the following criteria.
Menu path
- Suppliers/Report/Financial/A/P
- Suppliers/Report/Financial/Aging Analysis
- Customers/Report/Financial/Balance list (A/P)
- Financial/Reports/Accounts payable/Purchase invoices
- Financial/Reports/Accounts payable/Balance list
- Financial/Reports/Accounts payable/Aging analysis
Roles & rights
To view the account payable report, function rights 206 – View reports for customers and resellers balance list, A/R, aging and revenue report and 303 – View creditor balance list (suppliers) are required. Users with the General manager, Controller, F&A staff, Customer manager, or Reseller manager role have these function rights.
For more details on what you can do with function rights or levels, go to System/Setup/Security/Function rights, select the required module, and then click on the relevant ID. To find out the functions you can perform with a particular role, go to System/Setup/Security/Roles, type in the description, click Refresh and then click the required link under the Role column.
Button
Show
Click this to display the report based on the defined criteria.
Refresh
Click this to refresh report based on the last defined criteria.
Note: You will see this button after clicking the Show button.
Reset
Click this to clear the defined criteria.
Close
Click this to exit.
Description
Criteria section
Report
Select the report to be displayed. The reports available are:
- Purchase invoice – Select this option to display the report on created purchase invoices.
- Balance list – Select this option to display the report on outstanding amount of purchase invoices.
- Aging analysis – Select this option to display the report on the aging analysis of purchase invoices.
Division
Type or select the division of the reports to be displayed. For more information on divisions, see Overview of Divisions.
Reference date
Type or select the reference date of the reports to be displayed.
Note: This box is available only if the Balance list option or Aging analysis option is selected at Report.
Our ref.: From / To
Type the reference number range to display the report with the entered numbers. This is the reference number of the purchase invoice. You can leave this box blank to display the report with any reference number.
Age / Dates section
Range
Select the range for the report. The options are:
- Due date – Select this option to display the report based on the payment due date.
- Reporting date – Select this option to display the report based on the transaction date of the journal.
Age
Type the age range for the report. This is the number of days payment is overdue. You can leave this box blank to display the report with any overdue payment.
Note: This box is available only if the Balance list option or Aging analysis option is selected at Report.
Due date
Type or select the payment due date range to display the report with the selected due date range. You can leave this box blank to display the report with any payment due date.
Account section
Account
Type or select the account payable to be displayed. You can leave this box blank to display all the accounts. For more information on how to create and modify accounts, see Creating and Modifying Accounts.
Note: This box is available only if the Purchase invoices option is selected at Report.
Status
Select Active, Blocked, Inactive, Pilot, Reference, or Passive to display the report of accounts payable with the selected status You can also leave the box empty to display the report of accounts payable with any status. For more information on account statuses, see Searching for Accounts.
Aging categories section
Category
Type the aging categories to be displayed for the accounts payable.
Note: This box is available only if the Aging analysis option is selected at Report.
Customize
Click 
at the title bar to customize the fields or sections. You can add or remove existing criteria based on your preferences by selecting or clearing the relevant check boxes. Click Save to save the settings, Default to reset your selections to the default setting, or Close to exit without saving. Take note of the following fields/sections:
Criteria section
Define the relevant information such as warehouse, general ledger account, and your reference number.
Account section
Define the relevant account information such as manager, continent, type, classification, country, and region.
Amounts section
Define the relevant amount information such as currency, amount, and factor.
Factor
Select the factor to be displayed. This factor refers to how you want the amounts to be displayed. For example, if the amount of the purchase invoice is “1,000” and the “1,000” factor is selected, the amount will be displayed as “1”.
Related document