Scripting

Hello all! I'm trying to write a script that will update the Bill of Materials Description 1 when the description in the inventory Item Maintenance is changed, but when I save the data in IM module I get an error saying I don't have correct permissions. If I click info I get error #13: File access mode is invalid. Is there another (better) way to write to BM module from CI_Item table? retval = """" strDesc = """" strItemCode = """" oBMobj = """" strBillDesc = """" strBillNo= """" dbg=oscript.debugprint(""DBG-Scripting Started"") 'Get Desc retVal = oBusObj.GetValue(""ItemCode$"", strItemCode) retVal = oBusObj.GetValue(""ItemCodeDesc$"", strDesc) dbg=oscript.debugprint(strDesc) 'Get BOM Head obj oBMobj = oSession.GetObject(""BM_Bill_bus"") If oBMobj <> 0 THen Set oBMobj = oSession.AsObject(oBMobj) Else 'Do Nothing End If retVal = oBMobj.SetKeyValue(""BillNo$"", strItemCode) retVal = oBMobj.SetKeyValue(""Revision$"", 000) retVal = oBMobj.Find() dbg=oscript.debugprint(retVal) retVal = oBMobj.GetValue(""BillNo$"", strBillNo) retVal = oBMobj.GetValue(""BillDesc1$"", strBillDesc) dbg=oscript.debugprint(retVal &"" BillNo: "" & strBillNo & "" Bill Desc: "" & strBillDesc) retVal = oBMobj.SetValue(""BillDesc1$"", strDesc) retVal = oBMobj.Write() retVal = oBMobj.GetValue(""BillDesc1$"", strBillDesc) dbg=oscript.debugprint(retVal &"" BillNo: "" & strBillNo & "" Bill Desc: "" & strBillDesc) Any help is greatly appreciated! TIA!

Nothing script-related but does the user have access to Bill of Materials Maintenance?

Also - version 2015 does this automatically - am assuming the customer can't upgrade?

Yes, it's in my test system with only one user and that users has admin rights. :(

They actually are running 2015, where is this setting??

Bill of Material Options, right side - Sync Bill Description and Item Description

Unfortunately, this doesn't work if there's an extended description, so I'm back to square one. :(

BUMMER!

Hey Boise - this line here: retVal = oBMobj.Find() Change that to: retVal = oBMobj.SetKey() If it works one thing to be aware of is if someone is sitting in that bill in B/M Maint you'll get some kind of ""record in use"" error (because they have done the same SetKey)

You're my hero! <3 Thanks so much Alnoor!

Sam, In 2015 this is an option in Bill of Materials Options:

Good thought Anne but apparently doesn't work for extended descriptions [sigh]