Hi Everyone,
We are looking at populating the Custom Stat No field with the HS codes (unless anyone advises otherwise).
We’ve identified around the HS codes for around 100,000 parts so far (with many more to go). Does anyone know if there is a way to change them on bulk to add the code to the part (the field will be empty at present)?
Hi,
technically it’s possible to migrate your HS codes into the basic data database view CUSTOMS_STATISTICS_NUMBER first and then into the column CUSTOMS_STAT_NO of the database view INVENTORY_PART.
For this purpose you need a list/csv-file with site/contract, part number and HS code and then you can use the migration tool.
You need 2 migration jobs:
But keep in mind and I recommend to ask a distribution consultant or ask the question in a relevant category if it makes sense to use this column.
Extract from the Online help:
Customs Stat No:
The statistics number (often called commodity code) received from the customs authority. The customs statistics number is used for reports to customs authorities for imports and exports. The value is also used by the Intrastat feature in IFS Applications. This value originates from the Inventory Basic Data/Customs Statistics No. You can either enter the short code of the customs statistics number or indicate it by using the List of Values.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.