...
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Warehouse | The Warehouse for the Stock | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Group Code | The Code for the Group the Product belongs to | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Product Group | The Description of the Group the Product belongs to | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Product Code | The Code for the Product | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Description | The Product Description | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Single per Unit | The Number of Singles in a Case | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Rotation | The Rotation Number | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Opening Stock | The Amount of Stock at the Beginning of the Report Period | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Closing Balance | The Amount of Stock at the End of the Report Period | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Case Price | The Stock Product Cost | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Movement Type | The Type of Movement that has been Processed on this Stock | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Movement Date | The Date of the Movement | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Account | The Customer Code associated with the Movement | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Reference | The Invoice Number if an Invoice has beenproduced | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Order No | The Order Reference related to the Movement | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Total Singles | The Number of Singles Moved - a negative figure shows Movements Out | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Product Cost | Depending on the Movement Type, this will either show the Stock Product Cost, or the Stock Product Cost, plus any other Cost | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Insurance Cost | Any Insurance Cost associated with the Stock Movement | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Freight Cost | Any Freight Cost associated with theStock Movement | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Excise Duty | Any Excise Duty associated with the Stock Movement | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Customs Duty | Any Customs Duty associated with the Stock Movement | Read only fieldThis field is Read Only and Cannot be Modified from here |
| RH&D | Any Receipt, Handling and Despatch Costs associated with the Stock Movement | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Rent | Any Rent Charge for the Stock | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Delivery | Any Delivery Costs | Read only fieldThis field is Read Only and Cannot be Modified from here |
| Is Consignment Stock | Whether this was Consignment Stock | Read only fieldThis field is Read Only and Cannot be Modified from here |
Once the results of the Report are retrieved you can filter on 1 or multiple fields to only show some records as per any search criteria you enter.
...