This Report works on both Start and End Dates, so please ensure you have set the Dates correctly under set Report Dates.
This Report will show you Stock Movements of your Products/Rotations between the Dates set in Report Dates.
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Refresh | ||
| Close |
If there have multiple Movements on a Rotation within the Period you will see multiple records for the Product/Rotation.
Results Section:-
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Warehouse | The Warehouse for the Stock | Read only field |
| Group Code | The Code for the Group the Product belongs to | Read only field |
| Product Group | The Description of the Group the Product belongs to | Read only field |
| Product Code | The Code for the Product | Read only field |
| Description | The Product Description | Read only field |
| Single per Unit | The Number of Singles in a Case | Read only field |
| Rotation | The Rotation Number | Read only field |
| Opening Stock | The Amount of Stock at the Beginning of the Report Period | Read only field |
| Closing Balance | The Amount of Stock at the End of the Report Period | Read only field |
| Case Price | The Stock Product Cost | Read only field |
| Movement Type | The Type of Movement that has been Processed on this Stock | Read only field |
| Movement Date | The Date of the Movement | Read only field |
| Account | The Customer Code associated with the Movement | Read only field |
| Reference | The Invoice Number if an Invoice has been produced | Read only field |
| Order No | The Order Reference related to the Movement | Read only field |
| Total Singles | The Number of Singles Moved - a negative figure shows Movements Out | Read only field |
| 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 field |
| Insurance Cost | Any Insurance Cost associated with the Stock Movement | Read only field |
| Freight Cost | Any Freight Cost associated with theStock Movement | Read only field |
| Excise Duty | Any Excise Duty associated with the Stock Movement | Read only field |
| Customs Duty | Any Customs Duty associated with the Stock Movement | Read only field |
| RH&D | Any Receipt, Handling and Despatch Costs associated with the Stock Movement | Read only field |
| Rent | Any Rent Charge for the Stock | Read only field |
| Delivery | Any Delivery Costs | Read only field |
| Is Consignment Stock | Whether this was Consignment Stock | Read only field |
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.
Once you have the records on screen that you wish to see, you can if required extract the information in an XML 
, CSV 
or PDF 
format by clicking on the buttons at the bottom of the screen which will email the results.