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 | Group / Range |
Material (Class) Authorization 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 | 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 / Material Class Transaction / Promotion Transaction / Deposit Transaction / Mixed Case Transaction / Fixed Asset Transaction |
Transaction G/L Code | Group/Range |
Transaction Aux. Code | Group / Range |
Overhead Pool Code | Group / Range |
Order Number | Group / Range |
Report Unit | Unit Set and unit entry or selection |
Units | Convert to Main Unit / Convert to Reporting Unit |
Cancellation Status | Not cancelled slips / Cancelled slips |
Dispatch/Receipt | Unbilled Receipts/Dispatches / Billed Receipts/Dispatches |
Dispatch/Receipt 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 | Not Tracking / Lot/Serial |
Lot Number | Group / Range |
Lot Description | Group / Range |
Serial Number | Group / Range |
Serial Description | Group / Range |
Serial Group Number | Group / Range |
Serial Group Description | Group / Range |
Expiry Date | Start / End |
Location Code | Group / Range |
Group 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 |
Invoice Auth. Code | Group / Range |
AR/AP Auth. Code | Group / Range |
Claimant Status | Claimant / Stock (Claimant) Shipped / Non-Claimant |