Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Tip

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.

Table of Contents

image-20240531-091215.png

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

Tip

You MUST insert the full excise tax code for the product, you should NOT use the small producer relief tax code (350-399) nor set this up in the tax code maintenance.

Where a small producer certificate has been recorded against the brand you will see a message on the screen and you can select the TAX Certificate for the product in the tax certificate section. See https://visionsoftware.atlassian.net/wiki/spaces/VW/pages/edit-v2/3042377733#Tax-Certificate

Additional Tax Code

Only applicable for high strength beers where there are two tax codes

Note

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
You may move the stock without duty payments in which case the sales tax would not apply.

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.

A Tax certificate is recorded against the brand (producer/manufacturer) and when you select the brand should it have a certificate setup then you may see “Tax Certificates may exist for this brand”

image-20240611-085348.pngImage Added

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.

Tip

A TAX certificate will allow a reduction in the rate of duty for the small producer certificate.

Tobacco / Cigarettes

Warning

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.

Note

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