...
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. |
| Single 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. |
Once you have the records on screen that you wish to see, you can if required extract the information in an XML |
