This page contains information on the following topics
Currency
used to create new, or view and edit existing Currencies. These currencies are used throughout the system.
Once you have successfully set a unique Currency Name and a Currency Sign you can add Exchange Rates and the date the new rate will be effective from.
When the rates change (normally supplied by the government), add a new rate and the date this new rate will be effective from. The system keeps a log of the previous changes for auditing purposes.
Search for existing Currencies from the Navigation Panel.
The Currency Name must be unique
You can add Exchange Rates to a new Currency straight away but you should NOT try to add new exchange rates to existing currency.
Commodity Codes
These are codes set by the WTO to identify products worldwide and are widely used to determine tax rates for products imported into a country.
Commodity Codes are used in the system to categorise products as per the government trade tariff (in the UK: https://www.gov.uk/trade-tariff), various attributes are configured here relating to customs duty and importing / exporting. When setting up Products in /wiki/spaces/VW/pages/710344721, in the Customs tab users will configure a commodity code which will be used as the default in the Pre Advice screen for receiving new stocks for the product.
Mandatory fields are shown in RED
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.
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 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 default for you however customers are strongly advised to check the Commodity Code Maintenance configuration by using the trade tariff.
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 exemption code the document provided by HMRC see https://visionsoftware.atlassian.net/wiki/spaces/VB/pages/2469625894/Fixing+rejections#Known-differences-between-CDS-and-the-UK-Trade-Tariff%3A-Volume-3-for-CDS.
Commodity Categories
Commodity Category Codes indicate the general product type for (S would be a spirit, 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).
Frozen Reason
If you need to freeze stock you will be asked to input the reason, the system comes with a number of “system” reasons which are used for quality, receipting, governmental controls.
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.
Tax Certificate
This is used for the small brewery tax certificates, these are issued to small breweries when they are producing limited quantities of beer and allow tax to be reduced for the products they produce.
As a brewery can supply multiple customers within the warehouse a single certificate is needed which can then be applied to the products that this brewery produce which can be in any customer's account.
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 some 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 that the user can have for this C426
This screen is used to create a new tax-free form for tracking order usage
Orders being processed which are Type D (Diplomatic) or Type V (Visiting Forces) require C426/C197 forms to allow those orders to be processed.
This reference is used on the orders in the UB info
Packaging Type
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.
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
Pallet Type
You can maintain different pallet types in the system and use this to record the usage of pallets during the goods inwards and goods outwards processed.
This screen is used to create, edit or view the Pallet Types.
This is used in the Customer Maintenance screen
Default Inwards Charge - The values that you are adding in this type, can be overridden when you are this type to a specific customer. When used on a Pre-Advice, this generates charges which can then be invoiced in Vision Invoicing 'Goods In' invoices.
Default Outwards Charge - Charges are not generated for using this currently but Goods Out Pallet use can be seen using the 'Goods Out Pallet Usage' Report in VW Business Intelligence Reports.
Default Rental - The changes for the rental of the pallets.
The Pallet Code should be unique
You can find existing Pallet Types by searching in the Navigation Panel under Maintenance. Double click one of the Pallet Types in the list to Edit the details (using the screen shown above).
Tax Code
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.
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.
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 pressing the +ADD button and ensure it is added to the list.
Unpick Reasons
This is used as additional security controls on warehouse operations, when goods are picked a pick note is produced if they are unpicked and re-picked a new note can be produced, without adequate controls it is possible to double pick.
So to combat this if you unpick you have to enter an unpick reason.
Whenever you wish to unpick items after they have been picked you will be asked for a reason why you are doing this.
This was added to aid warehouses keep a record of who was carrying this function out and why, it helps theft prevention because if you are using paper pick notes, this is still in the warehouse when you unpick and you need to remember to recall it and destroy it, otherwise there is a potential for duplicate picking.
It is a simple form that requires a code and a narrative for the code.
Warehouse Vehicle
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 screen is used to create, edit, or view Warehouse Vehicles.
This is used when using the Vision Flex application for picking and put away.
For more information regarding the Vision Flex application please click on the link Flex for WMS
The maximum you can enter in the Reaches Location Height field is 32767
Brand
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.
This screen is used to create, edit, or view the Brand.
This is used when creating a product to be used in the system.
You will not be able to have a duplicate of the Brand Name, the name should be unique
Location
These are your locations within the warehouse and are used to store the name of the locations along with the picking configuration and capacities
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.
This form is used to create, edit or view the Warehouse Locations to an existing Warehouse
You would need to have a Warehouse and Sites created for you to create a Warehouse Location
Example Location Label
This shows a check digit of 22.
Location Upload from CSV
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.
Transport
This is used for both incoming 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.
Some information on the form is used for under bond order transporters which are known as “bonded transporters” who also require movement guarantees to move the stocks without the payment of duties
This screen is used to create, edit or view a Transporter (Haulier) account.
If you do not select Inbound (Pre-advice) or Outbound (Sale orders) or both the Transporters will not show for use
Transport Contacts
Contacts for the Transport