Welcome, Guest. Please Login.
05/11/25 at 15:29:24
News:
Home Help Search Login


Pages: 1
Send Topic Print
Global Change Quantity in BOM (Read 922 times)
newline
Browser
*




Posts: 37
Global Change Quantity in BOM
02/10/14 at 20:54:16
 
Does anyone have an easy way to globally change the quantity of an item that is in many BOMs.
 
i.e. the quantity is currently 1 (used in heaps of BOMs) but we need it to be 1.25.
 
Is the only way to manually change each bill of materials?
 
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Global Change Quantity in BOM
Reply #1 - 02/11/14 at 08:51:29
 
UT-A, program NZFNR is a global search and replace (or adjust or delete) that can make changes to the data based on the value of other fields in the file.  ALWAYS make a backup copy of the file you are changing.
 
In this case, file BKBMMSTR, Action Replace, field BKBM.QTY.REQD value 1.25 and enter the filter for BKBM.COMPONENT = the part.  Press enter once after entering the part to get to the list of filters then F10 to process.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
newline
Browser
*




Posts: 37
Re: Global Change Quantity in BOM
Reply #2 - 02/15/14 at 01:33:37
 
Thanks, do I need to enter anything in the 'array' fields?
 
My first attempt didn't result in any changes...
Back to top
 
 
  IP Logged
newline
Browser
*




Posts: 37
Re: Global Change Quantity in BOM
Reply #3 - 02/15/14 at 01:57:23
 
Never mind, tried it again with a space " " after the item code and it seems to have worked.
 
Why there is a space I have no idea.
 
But Thanks, much easier than changing BOMs one at a time  Smiley
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print