Skip to main content
Solved

BOM with Predefined Routing

kristianharianja
Semi-Pro I
Forum|alt.badge.img+3

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.

Ex:

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. 

Best answer by Noah

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).

View original
Kristian Harianja
Did this topic help you find an answer to your question?

2 replies

N
Semi-Pro I
Forum|alt.badge.img+1
  • Noah
  • Semi-Pro I
  • 56 replies
  • Answer
  • September 12, 2021

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).

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
jdobish
Pro II
Forum|alt.badge.img+2
  • jdobish
  • Pro II
  • 232 replies
  • October 7, 2021

Did you get this figured out? I recently did an import with what I think was a similar situation to what you were looking at.  The order of operations was (for example)

10- Manufacturing

  • Part 1
  • Part 2
  • Part 3

20- Outside Process

  • Outside Part 1

30- Assembly

  • NonStock Part 1
  • Subassembly Part 1

We were able to get the parts and the operations in there by hard coding them.  Is this sort of what you are talking about?

Be the change you want to see
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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 — 2024  Acumatica, Inc. All rights reserved