Supplier invoice and payment
Use this report to generate a history of supplier invoices and applied payments. You can filter the invoice list by selecting All for all invoices, Open or unpaid invoices, or With payments to list invoices with applied payments only. This report can be used for all legislations.
The payment amounts listed on the report include the discount taken or late charge amounts that have been applied. The invoice subtotal by supplier prints the total in the document currency and a separate subtotal in the company currency if needed.
Prerequisites
Report criteria and control
This section describes how the parameters in the List of criteria behave.
Details are provided in the Description of the report.
Criteria | Comments |
Company | Enter a company, only legal companies allowed. |
Site range | Enter a site or a range of sites to filter invoices by site(s). |
Invoice dates range | Option to filter for invoices within a date range. |
Invoice number range | Option to filter for a range of invoices by document number. |
Supplier range | Option to filter for a range of suppliers. |
All, open or with payments | Select one option to filter invoices accordingly. |
Print selections | Option to print criteria selections on the first page of the report. |
List of criteria
Parameter | Parameter title | Type |
|---|---|---|
societe | Company | |
sitedeb | Site range | |
invdatdeb | Invoice dates range | D |
facturedeb | Invoice number range | |
fournisseurdeb | Supplier range | |
payments | All, open or with payments | MM |
impselections | Print selections (Local menu No, Yes) |
Comments
The data is filtered by site according to the rights granted to the user on the function GESPAY (Payments).
Description of the report
If you selected Yes, for Print selections, the first page of the report displays your selection criteria.
Subsequent pages of the report list invoice and payment details for each supplier according to the selected report criteria.
The payment amounts listed include the discount taken or late charge amounts that have been applied and are listed in the Payment lines (PAYMENTD) table. This amount defaults from the DENPAY – AP early discount parameter (TRS chapter, TDC group) values.
For legislations that do not use check numbers, a Payment number is included on the line. This data is pulled from the Payment header (PAYMENTH) table.
Amount and Payment amount are subtotaled by site for each supplier in the document currency. If the company has invoices in another currency, a subtotal in that currency is also provided.
Report totals for Amount and Payment amount display on the final page of the report in the document currency only.