Merge Mycad BOM with Excel data from the ERP

Hi all

I would like to use Mycad nomenclatures in line with the Excel data of my ERP. (See attachment)

Today, we use a macro that bridges the dot, but the use is quite chaotic.

The macro uses the component reference of the SW BOM and displays the values if it exists in the ERP.

Otherwise, how do you proceed to make the link with the person who registers on the ERP ?

 

 

 


capture.png

For our part, we insert the excel bills of materials into our ERP using a module developed in-house, the link is made with an internal product code.

Hello

The same goes for us, the transfer of bills of materials to our ERP is done via software developed in-house.

Kind regards

1 Like

Some ERPs have existing gateways with SW. This is the case with ours (Cegid PMI).

So we use it even if the footbridge is not extraordinarily ergonomic.