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.