Cash requirements report @ L.V. Expertise X3

Use this report to generate a list of outstanding supplier open items that are sorted using the open item due date. This report can be used for all legislations and open items are printed in the company currency.

For invoices assigned a settlement discount/late charge code, the discount amount is calculated based on the DEPMGTMOD- Discount management mode (TC chapter, INV group), DATDEP- Date for the calc of dicsounts (TRS chapter, TDC group), and DATSELDEP- Disc. date for open item sel. (TRS chapter, TDC group) parameter settings.

All purchasing open items included in this report are pulled from the Open item (GACCDUDATE) table. If the BP is both a customer and supplier, the BP type (BPTYP) is set to 1 (customer) and these records are excluded.

This report includes both temporary and final journal statuses. The Journal entry (GACCENTRY) table is used to include only open items assigned a category 1 (actual) and excludes simulation, exceptional, and template.

Report criteria and control
List of criteria

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	Filter by a site or a range of sites. Leave blank to include all sites for the selected company.
Due date range	Enter a date or date range to filter on open item due date.
Date selection (Local menu And, Or)	Select And to include open items by due date and discount date ranges. Select Orto include open items by due date or by discount date ranges.
Discount date range	Enter a date range to filter by the open item discount date.
Accounting date	Enter the accounting date. Based on the date entered, the discount amount or late charge is calculated.
Pay-to supplier	Enter a supplier number or range.
Always discount (Local menu No, Yes)	If Yes, the discount due date is ignored and the discount is always calculated.
Print selections	Option to print criteria selections on the first page of the report.

List of criteria

Parameter	Parameter title	Type
societe	Company	CPY
sitedeb	Site range	FCY
datdeb	Due date range	D
andor	Date selection (Local menu And, Or)	M56
disdatdeb	Discount date range	D
paydte	Accounting date	D
tiersdeb	Pay-to supplier	BPR
disflg	Always discount (Local menu No, Yes)	M1
impselections	Print selections (Local menu No, Yes)	M1

Comments

The data is filtered by site according to the rights granted to the user on the function CONSCPT (Accounts).

Description of the report

Details by supplier are provided in alphabetical order by supplier name. At the beginning of each set of supplier data, the Supplier code and description are provided on a separate line. For each supplier section, the following totals are calculated: Invoice amount, Discountable amount, Discount/Late amount, and Net amount. The final page of the report displays report totals for the same fields.

The Discount/Late amount is calculated based DEPMGTMOD- Discount management mode (TC chapter, INV group), DATDEP- Date for the calc of dicsounts (TRS chapter, TDC group), and DATSELDEP- Disc. date for open item sel. (TRS chapter, TDC group) parameter settings. Only open items where the Accounting dateis before the Discount date qualify for a discount.

For the example: Two open items in a report have Discount dates of 12/10/2017 and 12/22/2017, respectively.

If you run the report with an Accounting date of 12/15/2017, only the second open item qualifies for a discount.
If you run the report with an Accounting date of 12/23/2017, neither open item qualifies for a discount.