Creation of Open Invoices Report
Filters
Show
Sort
The Open Invoices report is a report created to facilitate reconciliation work, which compares the daily balance of accounts payable to the daily balance of the accounting payment transfers account. The Open Invoices report displays all unpaid invoices as of the specified report date. Archived open invoices are also visible on the report. Invoices that have been deleted from purchase invoices do not appear on the open invoices report.
On the report, desired filters can be defined, after which a report is generated on the screen from the provided data. The Open Invoices report is only used for accounts payable - Purchase Invoices.
Creation of Open Invoices Report
- Go to Reports – Open Invoices view
- Make your selections for the report
Restrictions
You can select from the Doc. Type field dropdown menu either an individual receipt type or all receipt types for which the open invoices are desired on the report.
Receipt – You can enter either a single receipt number or a range of receipt numbers to be included in the report.
Supplier – When you want to display the open invoices of all suppliers on the report, select All. If you want to limit the view to only the open invoices of a specific supplier, select the supplier's name from the dropdown menu in the field.
Status Date – Select the date for which the report will be displayed. The report is always generated according to the receipt date. If the invoice does not have a receipt date different from the invoice date, then the receipt date = invoice date.
When a reporting date is defined for the report, and the report filters include Invoices transferred to accounting, the report will display the open invoices for that reporting date that have been transferred to accounting before the reporting date.
Example
The open invoices situation date is January 26, 2020, and the filter used is Invoices transferred to accounting. The report will then show those invoices that are open as of January 26, 2020, and which were transferred to accounting before or on that same day.
Show
Select whether to display All invoices, Approved invoices, Approval pendign or Invoices transferred to accounting.
- All selection brings invoices at any stage of the cycle to the report
- Approved Invoices selection brings approved invoices to the report
- Approval pending Invoices brings invoices that are in the cycle to the report
- Invoices Transferred to Accounting selection brings open invoices at the balance date that have also been transferred to accounting to the report.
Payments – brings partial payments to invoices that are partially open.
Sort
Select the order in which the information is displayed in the report: By suppliers, By document types, or By due dates.
- By Supplier: the report is sorted by suppliers
- By Document Type: the report is sorted by document types
- By Due Date: the report is sorted by the due dates of invoices.
Formation of the Report
Show – prints the report on the screen
PDF – prints the report to a PDF file
CSV – prints the report to a CSV file