Skip to main content
Question

What is practice to update BOM material lines using an import scenario?

  • September 4, 2024
  • 0 replies
  • 55 views

lauraj46
Captain II
Forum|alt.badge.img+8

The goal is to update the qty required or other fields on the material lines of an existing BOM using an import scenario.

I am aware of using the @InventoryID as a lookup, but in our scenario  there may be multiple material lines for the same inventory id on a single operation.  These are typically non-stock items that are called out with different descriptions.  

The other option I’m aware of is to lookup by line number, but we have run into issues with this too. When a BOM is edited there are sometimes gaps in the AMBomMatl.lineNbr field, whereas the <Line Number> lookup is always looking at sequential lines.  This may result in the wrong line being updated, or an error if the line number doesn’t exist.  Is there a way to retrieve the sequential line number in a GI, so that we can be sure we are editing the correct line?

Any thoughts  @dennisgodsill36 or other import scenario gurus out there?

Thanks in advance!

Laura

0 replies

Be the first to reply!

Reply


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