This is the store of the data about the products and / or services which your organisation provides to your customers and is accessed via the
icon.
icon.
In a situation where invoice data is being transferred from the company's sales order processing system, there may be no need to create this database, so please do not be surprised if there are no products other than those which we put in the files for demonstration and testing purposes. In certain situations however, there may be data required which is not stored in your company's sales order processing system,
e.g. a country of origin code, where multiple origin goods are shipped within a consignment. This can be set-up in the system, but you will need to talk to us on the Support line to configure this utility, including the option to print the origin code or not on invoices.
Although we think the field titles are self-explanatory, if you are unsure what data should be entered into a specific box, then the first course of action should be to press the "Alt" and "F1" keys and help will be displayed.
We would make the point that if you are creating a product file there are fields which require data entry because they are used by other routines in the system.
The first of these is the H.S.(Commodity) Code. This is the Customs code for the product and should consist of the eight numeric digit code, unless you have a CAP product with a recipe code, in which case you should complete part three of the commodity code. It is used by the
Auto-allocation
routine of the system, which summarises the weights and values by commodity code, and the resulting data is used for declarations to HM Customs.
If you are unsure of the number, you may have access to the customs tariff either
a. in printed form, or
b. by accessing from the Help and EU Applied Tariffs options within Formwise, or by accessing http://mkaccdb.eu.int from your Internet browser.
c. accessing the ICN section of the UK Trade info
or Business Link websites from within the Formwise Toolbar Help Options
Please ensure that in systems other than the
EASI range, that there is a record in the
Databases-Tariff/Goods
file whose key matches the eight digits you have entered.
The second and third fields which may require data entry are the hazard and recipe codes, if you are using the hazard sub-system, or you produce CAP documents respectively. Click on the text
Databases - Hazardous
for a discussion of the requirements.
In order to facilitate mass changes to the static data, please examine the options within the
Toolbar - CSV
routines.