BOM with Predefined Routing

  • 27 August 2021
  • 1 reply

Userlevel 2

Have someone ever done an import scenario with routing already hard-coded/inserted into the import mapping? The spreadsheet as data source only contains finished items and components. What I try to achieve here is having a workaround to assign a routing (that has set of standard operations) into a bill. My issue particularly is with multiple operation numbers that need to be inserted. I can only insert one operation with my scenario.


The spreadsheet has data FG1 (finished item) needs Comp1 and Comp2 (material) - split into 2 lines in the spreadsheet. 

When imported: the BOM will have operation 10, 20, 30 (already inserted in the import mapping)and the above component are placed under operation 10. 

1 reply

Userlevel 2

So, you’re trying to get all materials to go under operation 10, but want operation 20 and 30 to be added with no materials, but hardcoded routing information?


If so, I would just create a second import scenario that adds whatever extra operations are needed.  You can hardcode them, you’d just need to ensure you don’t recreate the BOMs (export the BOM ids created from the first import scenario).


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved