BOM Export Scenario

which version of Acumatica?

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.

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.

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. 

thank you Martin to this contribution to the community - very helpful!

@martingaxiola thanks for sharing the data provider template! This is the first Export by Scenario I have set up. I got the data provider saved and have created an export scenario. Do I need to set up the Export Scenario Mapping in order to get a file to export? I prepared and exported the scenario but my number of records was 0. 

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.

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.