Stock - Valuation - Valuation by Rotation (3 1 0)

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

N.B. This Report uses the End Date you have set in Report Dates.
- It does not take notice of the Start Date you have set.
It will not include any Stock owned by a Reserve Customer.

Buttons at the bottom of the screen:

Click the Export to CSV button to generate a .csv file of the data shown in your report.
Click the Export to Excel button to generate an .xlsx file of the data shown in your report.
Click the Export to Adobe button to generate a .pdf file of the data shown in your report.
Click the Refresh button to regenerate the report on the screen with the latest data in your system.

Report Results Section:

The following notes describe what some of the column on the report mean:

Physical Stock is the amount of Stock you physically hold up to the Report End Date currently set.
Actual Stock Value is the sum of your Undbond Value + Duty Paid Value less the En Primeur Value.
RH&D is the total of any Receipt, Handling and Despatch Charges.

Notes regarding this Report:

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

You can filter down the results on the report by entering value on any of the columns and choosing a filter type.
- Remove the filter values to see all the original results again.