Page Comparison

This Report uses the End

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.

...

Image Added

Field Name	Description	Field

Limits

Limit and Notes

Refresh

Close

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

Results Section:-

Image Removed

...

Field NameDescriptionField Limits and Notes

Warehouse Name

The Name of the Warehouse where the Stock is HeldThis field is Read Only and Cannot be Modified from hereThis field is Read Only and Cannot be Modified from here

The Warehouse where the Stock is Held.	This field Cannot be Changed from here.
Country Name

The Name of the Country of the ProductThis field is Read Only and Cannot be Modified from here

The Country of the Product.	This field Cannot be Changed from here.
Region Description	The

Description of the Region for the ProductThis field is Read Only and Cannot be Modified from here

Description of the Product.	This field Cannot be Changed from here.
Product Code

The Code for the Product

The Product Code.	This field Cannot be Changed from here.
Rotation Number

The

The Rotation

Number

Number of the

Stock

Product.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here

Product Description

The Description of the ProductThis field is Read Only and Cannot be Modified from here

The Product Description.	This field Cannot be Changed from here.
Analysis Description

The

The Product Type Analysis.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here.

Product Group Code

The

The Code

of the

of the Group

the

the Product

belongs

belongs to.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here.

Singles Per Unit

The

The Number

of

of Singles Per Case.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here.

Physical Stock

The Amount

The Amount of Stock you Physically hold up to the Report End Date.

Physical Stock is the amount of Stock you

Physically

physically hold up to the Report End Date currently set.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here.

Under Bond Value

The

The Value

of your

of your Underbond Stock.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here.

Duty Paid Value

The

The Value

of your

of your Duty Paid Stock.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here.

En Primeur Stock

The

The Amount

of

of En Primeur Stock

you

you have.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here.

En

Prrimeur

Primeur Value

The

The Value

of your

of your En Primeur Stock.

This

field is Read Only and Cannot be Modified

field Cannot be Changed from here.
Actual Stock Value	This is

a

the sum of

your

your Underbond Value + Duty Paid Value - En Primeur Value.

This field is Read Only and Cannot be Modified from hereDutyThe Total of your DutyThis field is Read Only and Cannot be Modified from hereShipping + InsuranceThe Total of any Shipping and InsuranceThis field is Read Only and Cannot be Modified from hereRH&D

Actual Value is the sum of your Under Bond Value + Duty Paid Value less the 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.	RH&D is 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.

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.

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 Image Added, CSV Image Addedor PDF Image Addedformat by clicking on the buttons at the bottom of the screen which will email the results.

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

Versions Compared

Old Version 1

New Version Current

Key