The fields in this tab are used when your warehouse is a tax or customs warehouse or you wish to use those components within the business. If a customer is set to be non-bonded these fields are not required.
On a previous tab you defined the Product Type - this will define which fields are mandatory or required within this tab.
Many fields here use items which are already set up within the system, see the other create menu options for how to add a new item.
Main Fields
Field | Notes |
|---|---|
Tax Code | Will provide you a list of existing tax codes based on the product type you selected Tax Code Filter - will restrict the list to products which fit within the strength ABV and size configuration for this tax code |
Additional Tax Code | Only applicable for high strength beers where there are two tax codes The additional tax code should appear here, this will always be different to the normal tax code, do not set both to be the same. |
Commodity Code | The 10 digit commodity code which is available for the product type / tax code configuration you have previously selected, for easy reading we display this as 4/4/2 Commodity Code Filter - will restrict the list to products which fit within the strength ABV and size configuration for this commodity code |
Country Consigned (CWC) | We default this to the same as the country of origin, but Country Whence Consigned (CWC) is the field which determines which country the goods are normally coming from. e.g. you may be always purchasing French (FR) wine through a German (DE) distributor in which case you can set this to the normal place of purchase. The code required is the ISO country code which you can select from the preloaded country selection |
Liquid Litres / Case | This should be calculating based on the single size and the singles per case to provide the number of litres in the case, also is the same as netweight for most liquids. |
Strength ABV | This may be mandatory, you can set this to be mandatory on the tax or commodity code and you will be required to set the strength of the product, this can be adjusted upon receipt but you then may find that the commodity code of the stock receipt needs to be adjusted. |
Litres Alcohol / Case | Quite simply this is the litres of liquid in a case multiplied by the strength %. It shows how many litres of 100% alcohol are within the product. |
Degree Plato | Used in some countries as the measure for duty calculations of beer. https://en.wikipedia.org/wiki/Beer_measurement This may be required for export documentation |
VAT Rate | This is the standard VAT or Tax rate for this product as if you were to sell it to an end consumer. THE MAJORITY OF PRODUCTS ARE STANDARD RATED VAT. If you are unsure check your government guidelines on items which are zero rated when selling to the consumer. Alcohol and Tobacco will never be zero rated they are always standard rate. Duty / Customs Warehouses |
Tax Certificate
This product may have a tax certificate which can be applied against the product, the certificate is usually to reduce the amount of duty which may be applicable to the product.
Tax Certificates need to be set up in advance, and then you can apply an existing certificate to the products.
To apply either enter the number or perform an F11 search, select the correct item and apply it.
Tobacco / Cigarettes
This section is mandatory for any products Type T (Tobacco) or C (Cigarettes)
Field | Notes |
|---|---|
Cigarettes / Case | Mandatory for Type C In order to calculate duty the stick count must be calculated |
Cigarettes Selling Price per Case | Mandatory for Type C In order to calculate duty the selling price must be known, this price has an additional tax added to it, check tax codes for more details. The price is monetary so needs to have decimals |
Tobacco KG per Case | Mandatory for Type T In order to calculate duty the kg must be known for the case |
Nicotine mg/mj | Initial implementation in VW v6.11 for future use |
Underbond Cost / Case
We would not suggest you use this field unless you are holding only your own stock in the warehouse and you are maintaining this figure through regular updates.
The figure held here will default into the goods inwards when receiving new stock into the warehouse, it removes the need to check the actual value at the point of receipt and can lead to incorrect values in the warehouse if the user is not careful.
Do not use this field if you are operating a 3PL warehouse. Leave blank and then each receipt will require product value information to be added for the stock.
These fields allow a value to be entered along with the currency code which is a 3 digit ISO code