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. |
NB This report can only be run for one Product Code at a time. When you select the Report, a message, requesting that you enter a Product Code, will appear. Click on OK. |
 As shown in the screenshot above, click on the Filter button in the top right hand corner; enter a Product Code in the box and click on Apply. |
If there have multiple Movements on a Rotation within the Period you will see multiple records for the Product/Rotation. |
Field Name | Description | Field Limits and Notes |
|---|---|---|
Refresh | ||
Close |
Results Section:- |
|---|
 |
Field Name | Description | Field Limits and Notes |
|---|---|---|
Warehouse | The Warehouse for the Stock. | This field Cannot be Changed from here. |
Group Code | The Code for the Group the Product belongs to. | This field Cannot be Changed from here. |
Product Group | The Description of the Group the Product belongs to. | This field Cannot be Changed from here. |
Product Code | The Code for the Product. | This field Cannot be Changed from here. |
Description | The Product Description. | This field Cannot be Changed from here. |
Singles per Unit | The Number of Singles in a Case. | This field Cannot be Changed from here. |
Rotation | The Rotation Number. | This field Cannot be Changed from here. |
Opening Stock | The Amount of Stock at the Beginning of the Report Period. | This field Cannot be Changed from here. |
Closing Balance | The Amount of Stock at the End of the Report Period. | This field Cannot be Changed from here. |
Case Price | The Stock Product Cost. | This field Cannot be Changed from here. |
Movement Type | The Type of Movement that has been Processed on this Stock. | This field Cannot be Changed from here. |
Movement Date | The Date of the Movement. | This field Cannot be Changed from here. |
Account | The Customer Code associated with the Movement. | This field Cannot be Changed from here. |
Reference | The Invoice Number if an Invoice has beenproduced. | This field Cannot be Changed from here. |
Order No | The Order Reference related to the Movement. | This field Cannot be Changed from here. |
Total Singles | The Number of Singles Moved - a negative figure shows Movements Out. | This field Cannot be Changed 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. | This field Cannot be Changed from here. |
Insurance Cost | Any Insurance Cost associated with the Stock Movement. | This field Cannot be Changed from here. |
Freight Cost | Any Freight Cost associated with the Stock Movement. | This field Cannot be Changed from here. |
Excise Duty | Any Excise Duty associated with the Stock Movement. | This field Cannot be Changed from here. |
Customs Duty | Any Customs Duty associated with the Stock Movement. | This field Cannot be Changed from here. |
RH&D | Any Receipt, Handling and Despatch Costs associated with the Stock Movement. | This field Cannot be Changed from here. |
Rent | Any Rent Charge for the Stock. | This field Cannot be Changed from here. |
Delivery | Any Delivery Costs. | This field Cannot be Changed from here. |
Is Consignment Stock | Whether this was Consignment Stock. | This field Cannot be Changed 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. |
|
