Projects/Invoice Payment Report/User Documentation

Contents 1 Invoice Payment Report - User documentation 1.1 Overview 1.1.1 Purpose 1.1.2 Source 1.1.3 Reports 1.2 Filters 1.3 HTML/PDF output 2 Sales Invoice Payment Report 2.1 PDF and Excel output

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.