How to integrate Duplicate Item No. in Integration Project

I am designing a database wherein data from 3 companies will be included. Data will be imported using standard dataports. RETAIL operations using barcodes and Item Nos. We will be only importing the cumulative sales / purchase value / inventory for the month into the central db.

Issues: The companies concerned has got duplicate item nos. When I create the central database, I will need to trace the orginal products information as follows

Central DB: Item No 1000

Company 1 Item No C1x1100 C1x11100 There are 2 Item Nos. which refer to the same PLU in Central DB

Company 2 Item No C2x2100 C2x22100 There are 2 Item Nos. which refer to the same PLU in Central DB

Company 3 Item No C3x3100 There are 1 Item No which refer to the same PLU in Central DB

What is the best way to solve this issue? Create Tables or is there any setup within default Navision which I can exploit to solve the above problem.

Hi

In Company 1 is 1100 also referenced with 1000?

In the master DB do you need to see 1000 referenced as C1 - 1100, C1 - 11100?

I am presuming you are “creating” a master DB, therefore do you know which company is the “master”? Just be careful not to overwrite an existing record where 3100 becomes 1000 updating the information from 1100.

Without creating them as individual items to create as substitutes I would push them into the search description with a sensible formating as they are only for reference I presume?

Can you use the item cross-reference table in the Central DB to reference all possible alternate numbers from the other companies?

John, pretty good idea. Post data import, the item cross-ref table can be queried in order for the master item no and then the data can be actual posted

I have given it a try and it works fine