The report option is used to take consolidated sales table. The option is located in the Consolidated Financial Reports menu of the Sales and Distribution moduleDistribution module. The report filter options are as follows:
Filter | Value |
---|---|
Consolidation Code | Group / Range |
Group Company Transaction | Yes / No / All |
Departments | Defined departments |
Divisions | Defined divisions |
Plants | Defined plants |
Warehouses | Defined warehouses |
Currency Amount Type | Local Currency / Reporting Currency / Transaction Currency |
Transaction Currency Type | Currency options |
Date Range | Start / End |
Distribution Period | Monthly / Weekly / Daily |
Subtotal | Yes / No |
AR/AP Code | Group / Range |
AR/AP Aux. Code 1-5 | Group / Range |
Salesperson Code | Group / Range |
Salesperson Description | Group / Range |
Salesperson Position Code | Group / Range |
Salesperson Status | Active / Passive |
Invoice Status | Actual / Proposal |
Invoice Aux. Code | Group / Range |
Invoice Auth. Code | Group / Range |
Detail | Yes / No |
Project Code | Group / Range |
Project Description | Group / Range |
Material (Class) Aux. Code 1-5 | Group / Range |
Material (Class) Auth. Code | Group / Range |
Material (Class) Type | Commercial Good / Mixed Case/ Deposit Item / Fixed Asset / Raw Material / Semi Finished Good / Finished Good / Consumer Good |
Invoice Type | Retail Sales Return Invoice / Wholesale Return Invoice / Retail Sales Invoice / Wholesale Invoice / Service Sales Invoice / Sales Price Diff. Invoice |