Stock - Valuation - Valuation by Rotation (3 4 2)

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

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

Field Name	Description	Field Limits and Notes
Refresh
Close

This Report will show your Stock Valuation grouped by Product/Rotation.

Results Section:-

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

Is the Stock Value In-Bond or Duty Paid?

The Report will show both. Because the Stock Value changes depending on it's Duty state the system shows Duty separately.

This means that if you have 50 Cases Underbond and 10 Duty Paid the Report will show a Value of £x and Duty of £y.

The true Product Valuation is £x+£y.

If you Only Hold Stock Under Bond but Duty is showing.

Depending on your Warehouse it may be that an Order has been Returned/Rejected. In this case Duty will be shown as the Goods can only be brought back in Duty Paid.

It is ow correct that the Product Value is the 'Stock' Cost + Duty Paid.

If you Only Hold Stock Duty Paid.

If this is the case then you will need the Cost column from the Report and the Duty Column to get the Stock Valuation.

The Duty Per Single on this Report is calculated by taking the Singles Per Unit, Litres Per Unit, Country and the Duty Code from the Product and calculated the Duty from the Excise Duty Rate Values set up against that Duty Rate that was valid at the time of the transaction.

If the Country against the Product is a NON-EC Country it then takes the same Values as above, but instead of running them just against the Excise Duty Rate it will run them against the Customs Duty Rate as well and combine the results into what is displayed on the Report.

The Duty Paid Price Per Case/Bottle is taken from the standard Selling Price on the Product, and the Underbond Price Per Case/Bottle is this Duty Paid Value minus either the Excise Duty (i.e the Duty Rate x Litres of Liquid or Alcohol as specific on the Product and Duty Code) or the Excise and Customs Duty if the Product has a NON-EC Country of origin. These columns are related to the Product Prices whereas the Duty Paid and Underbond Value columns are taken from the Value of the Stock on the Stock Record, which will have been set when the Stock was Landed or Stock Adjusted. They may not be the same.

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 record 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.