The report option is used to list the sales transactions. 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) 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 |
Material Tracking Method | Do Not Track / Lot / Serial / Serial Group |
Transaction G/L Code | Group / Range |
Overhead Pool Code | Group / Range |
Transaction Aux. Code | Group / Range |
Transaction Type | Material Transactions / Promotion Transaction / Deposit Transaction / Mixed Case Transaction / Fixed Asset Transaction / Optional Material Transaction / Material Class Transaction |
AR/AP Code | Group / Range |
AR/AP Title | Group / Range |
AR/AP Status | Active / Passive |
Trading Group | Group / Range |
Slip Type | Retail Sales Return Dispatch / Wholesale Return Dispatch / Consignment Return Dispatch / Retail Sales Dispatch / Wholesale Dispatch / Consignment Dispatch |
Warehouse Slip Type | All / Generated from Material Slips / Generated from Nationalization Slip |
Slip Number | Group / Range |
Slip Document Number | Group / Range |
Slip Aux. Code | Group / Range |
Slip Dates | Start / End |
Cancellation Status | Not Cancelled Slips / Cancelled Slips |
Disp./Rec. | Unbilled Disp./Recpt. / Billed Dispatches / Receipts |
Disp./Rec. Status | Actual / Proposal |
Material Slip Status (Warehouse Slips) | Actual / Proposal |
Departments | Defined departments |
Divisions | Defined divisions |
Warehouses | Defined warehouses |
Pricing Currency Type | Currency options |
Report Unit | Unit Set / Unit |
Units | Convert to Main Unit / Convert to Report Unit / List the Unit Used in Transaction |
Width Unit | Unit Selection |
Length Unit | Unit Selection |
Height Unit | Unit Selection |
Weight Unit | Unit Selection |
Area Unit | Unit Selection |
Volume Unit | Unit Selection |
Material Class Details | List / Do Not List |
List Serial/Lot Info | Yes / No |
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 |
Location Code | Group/Range |
Salesperson Code | Group / Range |
Salesperson Description | Group / Range |
Salesperson Position Code | Group / Range |
Salesperson Status | Active / Passive |
Unit Set Code | Group / Range |
Unit Set Description | Group / Range |
Unit Set Aux. Code | Group / Range |
Unit Set Auth. Code | Group / Range |
Line Barcode | Group / Range |
Unit Code | Group / Range |
Unit Description | Group / Range |
Distribution Order Number | Group / Range |
Distribution Order Date | Start / End |
Distribution Order Aux. Code | Group / Range |
Input from Production Tracking No. | Group / Range |
Project Code | Group / Range |
Project Description | Group / Range |
Claimant Status | On Claimant / Claimant Is Shipped / Not Claimant |
Shipment Address Code | Group / Range |
Shipment Address Description | Group / Range |