The report option is used to list the total sales quantity and amounts of the materials in details including the return quantities and amounts. The option is located in the Material Reports menu of the Sales and Distribution module. The report filter options are as follows:
Filter | Value |
Material (Class) Type | (MT) Material Class (With Table) / (MC) Material Class / (RM) Raw Material / (SF) Semi Finished Good / (FG) Finished Good / (CG) Commercial Good / (MX) Mixed Case / (DI) Deposited Item / (FA) Fixed Asset / (COG) Consumer Good |
Material (Class) Status | Active / Passive |
Material (Class) Code | Group / Range |
Material (Class) Description | Group / Range |
Material (Class) Aux. Code 1-5 | Group / Range |
Material (Class) Auth. Code | Group / Range |
Material (Class) Vendor Code | Group / Range |
Material (Class) Group Code | Group / Range |
Material (Class) Characteristics | Characteristic 1 - 10 |
Parent Material Class Code | The Class Code entry or selection |
Mixed Case Contents | List independently / Distribute to Inventory Items |
AR/AP Code | Group / Range |
AR/AP Title | Group / Range |
AR/AP Aux. Code 1-5 | Group / Range |
AR/AP Status | Active / Passive |
Trading Group | Group / Range |
Slip Type | Retail Sales Return Dispatch / Wholesale Return Dispatch / Consignment Return Dispatch / Retail Dispatch / Wholesale Dispatch / Consignment Dispatch |
Slip Number | Group / Range |
Slip Document Number | Group / Range |
Slip Aux. Code | Group / Range |
Slip Auth. Code | Group / Range |
Slip Dates | Start / End |
Slip Hour | Start / End |
Transaction Type | Material Transaction / Promotion Transaction / Deposit Transaction / Mixed Case Transaction / Fixed Asset Transaction / Optional Material Transaction / Material Class Transaction |
Transaction G/L Code | Group/Range |
Overhead Pool Code | Group / Range |
Transaction Aux. Code | Group / Range |
Order No. | Group / Range |
Report Unit | Unit Set Code / Unit |
Units | Convert to Main Unit / Convert to Reporting Unit |
Cancellation Status | Not Cancelled Slips / Cancelled Slips |
Disp./Rec. | Unbilled Disp./Recpt. / Billed Dispatches / Receipts |
Disp./Rec. Status | Actual / Proposal |
List by Warehouses | Yes / No |
Has No Transactions | List / Do Not List |
Currency Amount Type | Reporting Currency / Transaction Currency |
Transaction Currency Type | Currency options |
Departments | Defined departments |
Divisions | Defined divisions |
Warehouses | Defined warehouses |
Plants | Defined plants |
Salesperson Code | Group / Range |
Salesperson Description | Group / Range |
Salesperson Position Code | Group / Range |
Salesperson Status | Active / Passive |
Material Tracking Method | Do Not Track /Lot / Serial / Serial Group |
Lot Number | Group / Range |
Lot Description | Group / Range |
Serial Number | Group / Range |
Serial Description | Group / Range |
Serial Group No. | Group / Range |
Serial Group Description | Group / Range |
Expiry Date | Start / End |
List Serial / Lot / Location Info | Yes / No |
Location Code | Group / Range |
Grouping by Shipment Addresses | Yes / No |
Shipment Address Code | Group / Range |
Shipment Address Description | Group / Range |
Country Code | Group / Range |
City Code | Group / Range |
Town Code | Group / Range |
District Code | Group / Range |
Project Code | Group / Range |
Project Description | Group / Range |
AR/AP Auth. Code | Group / Range |
List By Variants | Yes / No |
Variant Code | Group / Range |
Variant Description | Group / Range |
Variant Aux. Code | Group / Range |
Claimant Status | On Claimant / Claimant Is Shipped / Not Claimant |