I am searching for a macro to export assembly BOM information into Mas90 or if nothing else excell or acces.
You're welcome. Is that the same one I gave you? Didn't see this one.
Check out this thread.
https://forum.solidworks.com/message/54201#54201Export BOM Macro
It works! ttps://forum.solidworks.com/message/147961#147961! Thanks Scott!
We are currently using MAS200 as our ERP and is not linked to Solidworks BOM, i 've noticed on your post that you are using MAS90..how did you get the SOLIDWORKS BOM link to MAS..
Please let me know...coz right now we are just doing manual input...
I have done work for a customer with MAS200. What we did was just export the BOM from SolidWorks to a CSV file in the correct format that MAS needs. Then MAS, like most ERP systems, have a way to upload or import that CSV file. However, I have also done quite a bit of database writing which ERP vendors hate. I think they change their db schemas every couple of years just for that reason.
when you said MAS can upload the CSV file, how do you do that exactly, do you mean using VISUAL INTEGRATOR?
If you don't mind can you give me a step by step procedure..
As far as the MAS side, I wasn't too involved. We stored the CSV file in a location for accounting to deal with. This was because they were the only ones allowed to add items. So then accounting uploaded them using some tool within MAS.
okay...thank you still for giving me the idea that it could be done via CSV
Retrieving data ...