This Report works on the Report End Date you have set. |
|
This is a Report of your Stock and any Movements on it, up to the Date you have set for Report End Date. |
If there have been multiple Movements for a Product, within the Period, you will see multiple records for the same Product. |
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 Product Group Code. | This field Cannot be Changed from here. |
| Product Group | The Product Group Description. | This field Cannot be Changed from here. |
| Product | The Code for the Product. | This field Cannot be Changed from here. |
| Description | The Product Description. | This field Cannot be Changed from here. |
| Bottles/Case | The Number of Bottles in a Case. | This field Cannot be Changed from here. |
| Rotation | The Rotation Number for the Stock. | This field Cannot be Changed from here. |
| Opening Stock | The Amount of Stock Landed on the Product/Rotation. | This field Cannot be Changed from here. |
| Closing Balance | The Amount of Stock Held at the Report End Date. | This field Cannot be Changed from here. |
| Case Price | The Price Per Case for the Stock. | This field Cannot be Changed from here. |
| Movement Type | The Type of Movement if any against this Stock. | This field Cannot be Changed from here. |
| Movement Date | The Date of any Movement of the Stock. | This field Cannot be Changed from here. |
| Account | The Customer Code against any of the Stock Movement. | This field Cannot be Changed from here. |
| Reference | The Invoice Number if one has been generated. | This field Cannot be Changed from here. |
| OrderNo | The Order Reference is the Stock Movement is in relation to an Order. | This field Cannot be Changed from here. |
| Total Singles | The Total converted Singles Moved. | 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 Costs. | 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. |
| Rotation Notes | Any Rotation Notes will be displayed here | This field Cannot be Changed from here. |
| Rotation Warehouse Notes | Any Rotation Notes added by the Warehouse will be displayed here. | 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. |
|
