Syncing Inventor BOM and Sage 100

[peter.rewinskiP3KTC]

My company uses Inventor & Vault 2023, and Sage 100 (I want to say 2013?). We use the BOMs generated from manufacturing drawings to produce picksheets for the guys on the floor. We're looking to automate some of the clerical work- and I'm wondering if there is an add-in or extension from which we can populate a BOM in Sage directly from Inventor. We have drawing updates that come from several stages of production, which would then require subsequent BOM updates in both in the Inventor drawings and Sage. The way we currently do it is to (all manually) export the BOM as a .csv, then import that to Sage, and produce picksheets. (Drawing update comes:) change sheet submitted from manufacturing, I go in manually and select which parts from Sage inventory that are returned and extra parts picked. Material issue change report and backorder fill report pdfs generated, end of transaction(s). 

We'd be looking to automate as much of the manual clerical work as possible, if possible. 

The company keeps talking about maybe moving to JD Edwards for inventory management- but probably not anytime soon. Would they have some sort of capability to interact with Autodesk products/Inventor drawings like I'm suggesting above?  

[NigelHay · Accepted solution]

We have a similar set-up, Inv2022 & Sage 200 & also have to manually transfer BoM data from Inventor to Sage which is time consuming. We have never found a good method of automating this. We looked at a programme called CADlink which claims to be able to integrate Inventor BoMs with Sage. It is a bit expensive but they claimed that the integration was a 2 way thing. We abandoned that investigation as it looks like we could be moving to a different ERP system that is used by a sister company.

[peter.rewinskiP3KTC]

Thanks for the reply. Was hoping there was some more efficient way to do this but that is the answer I expected. Thanks for taking the time.