Does anyone have an export scenario that will export BOM’s so that they can be imported into another tenant
Userlevel 5
I am attaching the latest 2021R1 export that I used, as the one attached from Dennis has some JAAS tables that are not in Acumatica anymore. I am also uploading the Data Provider Template, as I had a few issues with it myself. I hope this helps.
Userlevel 1
thank you Martin to this contribution to the community - very helpful!
Userlevel 5
Hola @mpowell, I hope I can explain this, first you need to go to screen Data Providers screen (SM206015), to setup the format that you want the Excel file to have, make sure to have the Parameters with the file and the SCHEMA tab with the active tab and the correct columns. Then, go to Export Scenarios screen (SM207025), where then you will be mapping the Data provider with the screen in Acumatica where you want to do the export from (your mapping should have a Field BOM ID with true on commit and Target Field set to =EVERY, is on the file, but just to make sure), after this, go to screen Export by Scenario screen (SM207036), and prepare the export the scenario, this should create a file that will be on the FILES section of the the same screen after finished.
Userlevel 4
+2
I built a bom details GI that pulls in all of the lines. This can easily be exported into excel and then used as an import.
Bom imports are challenging, depending on what it is that you are trying to load up.
which version of Acumatica?
Userlevel 1
Thank you Dennis…
2019 R1 with Manufacturing 19.111.0038.53
Please send me an email and I will send you an export scenario. Dennis.Godsill@acumatica.com
This might work with 2018R2, 2019R2, or 2020R1.
Userlevel 2
Be careful of the <Save> line at the end of the export scenario - this will write back data to the BOM file. It is not needed if you are only exporting data. Test with one or two BOM’s and verify the results.
Does anyone have a copy of the export map?
Thanks!
it’s attached, import the xml file to the Import Scenario page.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.