This Report works on the Report End Date you have set
Field Name | Description | Field Limits and Notes |
---|---|---|
Refresh | ||
Close |
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 multiple Movementson 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 is Read Only and Cannot be Modified from here |
Group Code | The Product Group Code | This field is Read Only and Cannot be Modified from here |
Product Group | The Product Group Description | This field is Read Only and Cannot be Modified from here |
Product | The Code for the Product | This field is Read Only and Cannot be Modified from here |
Description | The Product Description | This field is Read Only and Cannot be Modified from here |
Bottles/Case | The Number of Bottles in a Case | This field is Read Only and Cannot be Modified from here |
Rotation | The Rotation Number for the Stock | This field is Read Only and Cannot be Modified from here |
Opening Stock | The Amount of Stock Landed on the Product/Rotation | This field is Read Only and Cannot be Modified from here |
Closing Balance | The Amount of Stock Held at the Report End Date | This field is Read Only and Cannot be Modified from here |
Case Price | The Price Per Case for the Stock | This field is Read Only and Cannot be Modified from here |
Movement Type | The Type of Movement if any against this Stock | This field is Read Only and Cannot be Modified from here |
Movement Date | The Date of any Movement of the Stock | This field is Read Only and Cannot be Modified from here |
Account | The Customer Code against any of the Stock Movement | This field is Read Only and Cannot be Modified from here |
Reference | The Invoice Number if one has been generated | This field is Read Only and Cannot be Modified from here |
OrderNo | The Order Reference is the Stock Movement is in relation to an Order | This field is Read Only and Cannot be Modified from here |
Total Singles | The Total converted Singles Moved | This 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 Costs | This field is Read Only and Cannot be Modified from here |
Insurance Cost | Any Insurance Cost associated with the Stock Movement | This field is Read Only and Cannot be Modified from here |
Freight Cost | Any Freight Cost associated with the Stock Movement | This field is Read Only and Cannot be Modified from here |
Excise Duty | Any Excise Duty associated with the Stock Movement | This field is Read Only and Cannot be Modified from here |
Customs Duty | Any Customs Duty associated with the Stock Movement | This field is Read Only and Cannot be Modified from here |
RH&D | Any Receipt, Handling and Despatch Costs associated with the Stock Movement | This field is Read Only and Cannot be Modified from here |
Rent | Any Rent Charge for the Stock | This field is Read Only and Cannot be Modified from here |
Delivery | Any Delivery Costs | This field is Read Only and Cannot be Modified from here |
Is Consignment Stock? | Whether this was Consignment Stock | This 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.
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.