300 Stock Record Card

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:-

Results Section:-

Field Name	Description	Field Limits and Notes

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.

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.

Click the button to refresh the report and make sure you are looking at the latest date