Skip to main content
Solved

Update Operations ID BOM through Import Scenario


bwhite49
Pro I
Forum|alt.badge.img+1

Any ideas on how to update the operations ID on the BOM? We need to change it from the value of ‘01’ to ‘0010.’ Every operation ID is line number 1. Thanks ahead!

 

 

Best answer by jdobish

The <Line Number> on the Bom Operations is actually the command to add or delete the line (-1 is to add a new operation, -2 is to delete) You need to deactivate this row.

You also need to look at the Operation DB ID, which is really what is driving the operation # (it is a hidden column, add it in. Reference this as your search (Operation DB ID= ‘01’)

Then your Operation ID = ‘0010’

You may also be running into issues because you are not referencing your revision as well

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

4 replies

jdobish
Pro II
Forum|alt.badge.img+2
  • Pro II
  • 225 replies
  • Answer
  • April 21, 2023

The <Line Number> on the Bom Operations is actually the command to add or delete the line (-1 is to add a new operation, -2 is to delete) You need to deactivate this row.

You also need to look at the Operation DB ID, which is really what is driving the operation # (it is a hidden column, add it in. Reference this as your search (Operation DB ID= ‘01’)

Then your Operation ID = ‘0010’

You may also be running into issues because you are not referencing your revision as well


bwhite49
Pro I
Forum|alt.badge.img+1
  • Author
  • Pro I
  • 91 replies
  • April 26, 2023

Thanks for getting back to me Jeremy! I revised the import scenario, but this import resulting in the creation of a new operation ID rather than overwriting the original.

Maybe it would be easiest to just delete the original operation and add in a new one?

 

 


jdobish
Pro II
Forum|alt.badge.img+2
  • Pro II
  • 225 replies
  • April 26, 2023

That would be a good way to do it. You could also use the @@Operation DB ID to see if you could search for the item and see if that would let you modify it.

 

Honestly, deleting it is better. 


wgnel35
Freshman I
  • Freshman I
  • 3 replies
  • September 5, 2023
Acumatica Import Scenario Changes on Operations in BOMS

Hi All, 

I thought this might help for future inquiries. 
I used a GI for the data provider in my scenario and used a fixed Revision although a dynamic Revision is always more ideal.


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