Versions Compared

Key

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

...

Expand
titleCommodity Codes ....more info

Field Explanations

Field

Notes / Explanation

Category Code

see next section

Bulk Commodity

Used in manufacturing processes, when the warehouse is permitted to use the bulk commodity code for payment of customs duty for the bottled stocks.

Can only be used by the original owner.

No of Products

Not currently in use

ECU Indicator

This is a legacy field relating to Agriculture and Industrial rates, this is no longer used

Enter into Customs Warehouse

CT - CFSP Customs Transit Type

DT - CFSP Customs Declaration Type

IR - Trader who is authorised for CFSP as an indirect representative and submitting the declaration on behalf of the importer

Leave Customs Warehouse (Home Use)
Request Procedure Code (CPC) - which will be used later to enhance Vision integration with CDS in Bond.

From: https://www.gov.uk/government/publications/uk-trade-tariff-customs-procedure-codes/customs-procedure-codes-box-37

CPC

Description

71

Customs warehousing procedure including deposit in other premises under customs control.

07

Free circulation with simultaneous entry of the goods under a warehouse procedure (including placing in other premises under fiscal control).

This is the most typically used.

40

Home use with simultaneous entry for free circulation.

To find out more about our CDS integration & roadmap see: ; CDS Implementation.

EC Country Indicator - Indicates whether or not this Commodity Code can be used for EC goods.

Dangerous Goods - If your system has been set up to generate shipping notes, a Dangerous Goods document will be produced whenever a Product is associated with a Commodity Code has the Dangerous Goods field ticked. You may need new Commodity Codes for your Dangerous Goods.

All the fields in red are mandatory to save the order
Speak to the Vision Support Team if you would like to turn on Shipping Notes.

Import Documents button - This provides the ability to configure the many different import documents and certificates required for the commodity when receiving goods in the Pre Advice screen, Bond Details tab. When clicking this button, the screen which opens has been designed to (as closely as possible) mirror the document requirements listed in the ‘Import’ tab of the UK trade tariff.

Here users can select a country (or group of countries such as ‘EU Countries’ / ‘Non-EU Countries’) and configure the import document requirements for the commodity code for that country/group, the pre-advice ‘Bond Details’ uses the information configured here to get the correct information from the user.

Above we can see that in order to claim the preference for imports from the EU then document code U112 is required but we are defaulting the ID & status code to EU-DOC and JP per HMRC’s requirements https://www.gov.uk/guidance/claiming-preferential-rates-of-duty-between-the-uk-and-eu. However if claiming a preference from any non-EU country then N954 is required and the users will need to enter the document ID and status code because they haven’t been defaulted here. We can also see that a VI1 is required for imports from all countries, and that C644 (Organic certificate) number & status is required, but for this one users have the ability to use ‘NA’ which will instead store Y929 to signify that the product is not organic or excluded from the regulation. This information can all be found here: https://www.trade-tariff.service.gov.uk/commodities/2204101100#import by viewing the ‘Conditions’.

Except when creating a new commodity code manually, most of the necessary configuration will be defaulted default for you however customers are strongly advised to check the Commodity Code Maintenance configuration by using the trade tariff.

Info

Currently only the preference certificate (N954) and VI1 certificate (C014) are fed through to Bond’s CFSP & CDS modules, in future the remaining documents will also be posted through allowing customers to use those modules with other commodities such as those that are non-wine/spirits/beer.

For more information about how to set the status / LPCO excemption exemption code the document provided by HMRC below can be used. HMRC are currently reviewing the ID / Status code requirements but this information is correct as of Q2 2021.  Unfortunately, this information isn’t published publicly anywhere else but if this changes we will add it here in the future.

View file
name15062021 DF Tariff Clinic Doc code Functionality.xlsx

...

Expand
titleCommodity Category Codes

Commodity Category Codes indicate the general product type for (S would be a spritspirit, B would be a beer). This category codes are used on the Commodity Code screen and in other places (to show what types of products are allowed for use by individual Customers for example and on System Delivery Addresses).

...

Expand
titleFrozen Reason

This screen is used to create, edit, or view the Frozen Reason. Each code needs to be unique.

You can specify an internal reason as well as a more comprehensive reason for the customer.

QA Held - this operates a sub-system and is used for production goods to QA hold those goods as they arrive into stock until testing is complete. You should not use this check box normally, as any Stock Frozen using the QA Held field will not show up when searching for Frozen Stock.

Normal frozen reasons should NOT have any of the lower check boxes ticked.

...

Expand
titleTax Certificate ......more info

This screen allows you to create or edit a Tax Certificate, and an audit trail is provided to show changes to the tax certificate.

You have to add a certificate to the system before adding it to the product, please remember there is a sliding scale for sme duties so you need to be accurate with the information you enter into this certificate form.

See Tax Code section below for more details on setting up a Tax Code for Small Brewery use.

Tax-Free Form

Used for diplomatic orders where you are presented with a C426 form or for military use where you are given a C192. This keeps track of the amount of items which that the user can have for this C426

...

Packaging types are stored for each stock as it arrives and is used on paperwork for many things including environmental reporting, exports, government documents, and clearances.

Expand
titlePackaging Type........more info

This screen is used to create, edit, or view the Packaging Types. This is used in the Pre-Advices when receipting the stock.

This is the Type of Packaging that the Stock will be received in

The Packaging Code should be unique

...

Used by countries where there is additional taxation on specific goods. In the UK this is used for the sale of alcohol, tobacco, and cigarettes where each item has a tax code associated with it, this is also known as excise taxation.

Expand
titleTax Code.........more info

This screen is used to maintain the excise duty codes and rates of excise duty.

Small Brewery Option

This option makes the rates auto-calculated the duty based on the sliding scale and is based on the small brewery certificate you enter and then apply against the product.

Rate for < 5000 hectolitres - DO NOT TICK THE SMALL BREWERY option. The rate you put in is the rate which is charged.

Rate for 5000-60000 hectolitres - Enter the FULL Rate into the field and tick the option “Small Brewery” this activates the sliding scale.

General Setup

Calculation Methodology - The system needs to know which method it will be using for this tax code. Only one can be selected and you should enter this first.  

Info

Be careful setting this especially the LOL and HLOL Getting this wrong could mean a submission 100 times too much !!!

Duty Stamps Applicable - Is this a tax code where you may require a duty stamp on the item? If it is then set the option by clicking the check box.

When adding a new rate in you insert this into the Details section where you state the date/time this rate would apply and you enter the figure you need into the correct box for this product excise category, once finished press pressing the +ADD button and ensure it is added to the list.

...

If you are using Vision Flex for warehouse picking we need to know the vehicle you are using in the warehouse, what its capabilities are, and its maximum capacities.

You will be requested to specify the warehouse vehicle on the flex system.

...

This is in addition to the description field for a product, you can enter the brand which can be the manufacturer/producer, etc.

This is a single input field, if it exists we will not duplicate the record.

...

Expand
titleField Explanations......expand to read more

Field explanations

Location Name - This must be a unique name for the location, one that is only used one time in the entire warehouse.

Warning

If using barcodes and scanning it is advised that the minimum name length for a location is at least 4 characters long, anything less than this MAY scan but the magnification required to keep the barcode minimum width is outside the tolerances usually allowed for barcode creation, this can lead to erratic results when scanning, If you are using check digits for the locations then this takes up 2 characters, so the name in this instance can be a length of 2

Tip

We would suggest that the location names within all warehouse locations are the same length, if needed pad out with - or _ or 000 to achieve the result.

Location Type - See the next expand expansion for additional details https://visionsoftware.atlassian.net/wiki/spaces/VW/pages/667418787/Maintenance+Menu#Location-Types This has to be set. If you are using PICK replenishment operations then you need to ensure your PICK locations are setup, and you should modify your site settings to use pick locations first before FIFO. However, it will only use the PICK location for quantities of less than one pallet

Configuration Section

The system uses this to build a matrix of how it picks from stocks in the warehouse. It takes each value and builds the pick route, so 1/1/1/1 will be picked before 1/1/1/2 and this is before 1/1/2/1, and so on.

The warehouse number needs to be kept unique to some degree but you can have multiple virtual warehouses within a single warehouse. e.g. If you want to pick the lower racks before the upper racks then you can have the lower racks as warehouse number 11 and the upper ones as warehouse number 21

The system will not allow you to set up duplicate location locations within the same site.

Use 9L cases - is used for the graphical warehouse currently to assess how full the location is.

Has Mixed Products - if you are using auto put away routines then specify whether this location is allowed to store different products in the same location at the same time.

Max Height - This is also used for put-away routines, when you specify the location height it ensures that the goods do not exceed this height for the put-away routine.

Expand
titleLocation Types......expand to read more

Location Types

There is a default list of location types available, which is loaded with most systems, however, when youa re you are using certain functionality types are added these are generally non-picking

Non Picking Locations are

Name

Used for

FLEX DEVICE

Used for Vision Flex, this should have a single location of the same name in it.

QA HOLD

Used for manufacturing where a hold is placed on stock until it passed required lab checks.

COND REPORT

Used for condition reporting in some warehouses where incomign goods are not allowed to leave before a condition report is carried out on the stock.

Customers can also request their own location types to be added to the list, generally this is done when the system is first setup, to do this later will incur a charge from the support team to make the configuration change.

Expand
titleLocation CSV Uploads ........ expand to read more

Location Upload from CSV

You can export through the export option a list of locations and you can edit the excel file and then re-upload the locations with the modified configureation configuration fields.

You are able to create a Warehouse Location manually using the above screen or you are able to upload (import) multiple Locations using a excel spreadsheet.

To find out the format we would suggest you export some locations and then follow this format for the new import file.

...

This is used for both incoming transporter transporters along with outbound transporters and stores information and contacts for each transport company which could be used.

This information is shared between all customers in the system as generally, you find they all use the same transporters.

...