Item Masterdata Sync

You can run a Item masterdata sync between 2 companies in Business Central using Golden EDI Standard App in both companies, and CIP Connections between them.

The Sending company (Master), should use 'GEDI Setup' 'IC ITEM MD SENDING'. Including tables;

• Item Card export (per item and complete list)

• Item Units of Measure export (per item and complete list)

• Item Attributes export (per item and complete list)

• Item references export (per item and complete list)

• Item dimensions export (per item and complete list)

• Sales Price list export (per item and complete list)

The Receiving company (Replica), should use 'GEDI Setup' 'IC ITEM MD RECEIVING'. Including tables;

• Item Card import (per item and complete list)

• Item Units of Measure import (per item and complete list)

• Item Attributes import (per item and complete list)

• Item references import (per item and complete list)

• Item dimensions import (per item and complete list)

• Purchase Price list import (per item and complete list)

In Business Central there is a standard workflow to listen to changes to the item card. in this 'GEDI Setup' we use this as a trigger to send out item card export from the sending company.

When the item card later has been imported in the receiving company, it sends back an acknowledge to sending company. When the acknowledge then is imported in the sending company, this is the trigger to send out all the underlying tables (for example, Attributes, References etc.)

Additional to the workflow, a job queue entry can be created to send out all information as often as defined. Usually in the night as exporting/importing all item information at the same time can be performance heavy.

In the underlying tables (for example, Attributes, References etc) it is only the relation to the item that is synced, not the definitions themselves. For example, if you create a completely new Unit of Measure, this is not synced; If you add your new Unit of Measure to a item, this relationship can be synced.