309 Valuation by Product

This Report uses the End Date you have set in Report Dates.

It will not include any Stock owned by a Reserve Customer.

This Report will show your Stock Valuation grouped by Product.

Results Section:-

Results Section:-

Field Name	Description	Field Limits and Notes

Field Name	Description	Field Limits and Notes
Warehouse Name	The Warehouse where the Stock is Held.	This field Cannot be Changed from here.
Country Name	The Country of the Product.	This field Cannot be Changed from here.
Region Description	The Description of the Product.	This field Cannot be Changed from here.
Product Code	The Product Code.	This field Cannot be Changed from here.
Product Description	The Product Description.	This field Cannot be Changed from here.
Analysis Description	The Product Type Analysis.	This field Cannot be Changed from here.
Product Group Code	The Code of the Group the Product belongs to.	This field Cannot be Changed from here.
Singles Per Unit	The Number of Singles Per Case.	This field Cannot be Changed from here.
Physical Stock	The Amount of Stock you Physically hold up to the Report End Date.	This field Cannot be Changed from here.
Under Bond Value	The Value of your Underbond Stock.	This field Cannot be Changed from here.
Duty Paid Value	The Value of your Duty Paid Stock.	This field Cannot be Changed from here.
En Primeur Stock	The Amount of En Primeur Stock you have.	This field Cannot be Changed from here.
En Primeur Value	The Value of your En Primeur Stock.	This field Cannot be Changed from here.
Actual Stock Value	This is the sum of your Underbond Value + Duty Paid Value - En Primeur Value.	This field Cannot be Changed from here.
Duty	The Total of any Duty.	This field Cannot be Changed from here.
Shipping + Insurance	The Total of any Shipping and Insurance.	This field Cannot be Changed from here.
RH&D	The Total of any Receipt, Handling and Despatch Charges.	This field Cannot be Changed from here.
Rent	The Total of any Rent.	This field Cannot be Changed from here.
Under Bond Price Per Case	The Underbond Case Price.	This field Cannot be Changed from here.
Under Bond Price Per Bottle	The Underbond Bottle Price.	This field Cannot be Changed from here.
Duty Paid Price Per Case	The Duty Paid Case Price.	This field Cannot be Changed from here.
Duty Paid Price Per Bottle	The Duty Paid Bottle Price.	This field Cannot be Changed from here.
Stock Landed	The Date the Stock was Landed .	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 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