Solved

Bulk Import of HS data - IFS 7.5

  • 23 May 2022
  • 1 reply
  • 178 views
K
Rank
Badge +3

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)?

icon

Best answer by Jens 1 June 2022, 19:03

View original

1 reply

Jens
Rank
Userlevel 4
Badge +8

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:

  1. a CREATE_TABLE_FROM_FILE migration job to load your list/csv-file into a “temporary” IC_-table in Oracle
  2. a MIGRATE_SOURCE_DATA migration job to fetch the data from the IC_-table and migrate the data into the database views CUSTOMS_STATISTICS_NUMBER and INVENTORY_PART

 

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.

Reply


Terms & ConditionsCookie settings