Projects/Invoice Payment Report/User Documentation
Contents |
Invoice Payment Report - User documentation
Overview
Purpose
This module provides two reports:
- Sales Invoice Payment Report.
- Purchase Invoice Payment Report.
Displaying the balances per business partner and containing every invoice and related payments which compose this balance.
It also allows to retrieve the information in different formats as html, .pdf or .xls.
Source
The source of the information for this report is accounting. This way we can obtain the info in one single currency and as of date.
Reports
Two menu entries are created. One for Sales Invoices, called Sales Invoice Payment Report, and another one for Purchase Invoices, Purchase Invoice Payment Report.
These two reports can be found in the following application path: Financial Management // Receivables & Payables // Analysis Tools
Filters
- Organization (Mandatory).
- General Ledger (Mandatory). The user can filter the results by organization's general ledger. All the amounts will be converted to the currency of the general ledger.
- Business Partner (Optional). The user can select a Business Partner to filter the results.
- Starting Date (Optional). This is the starting date for the report output. Initial Balance will be computed based on this starting date.
- Ending Date (Optional). This is the date as of which the report will be processed. Ending date in the report should match accounting balance as of this date.
- From Document No. (Optional). This filter can be used to filter invoices which belong to this date ranges. This can be used to figure out if a particular invoice or set of invoices is/are already paid or not.
- From Document No. (Optional). This filter can be used to filter invoices which belong to this date ranges. This can be used to figure out if a particular invoice or set of invoices is/are already paid or not.
- Output Type (Mandatory). This option is used to determine the output format of the report.
HTML/PDF output
Sales Invoice Payment Report
It should Display a report grouped by business partner showing (Similar for Purchase Invoice Payment Report):
- Initial balance
- List of invoices and payments registered in the defined date ranges
- Ending Balance
PDF and Excel output
The above output can be displayed in PDF or spreadsheet formats.