Scripting

Want to hard code the Main segment of sales account in SO Invoicing. Why doesn't this work? SET oGLAccount = oSession.AsObject(oSession.GetObject(""GL_Account_svc"")) retVal = oGLAccount.Find(""4181"") retVal = oGLAccount.GetValue(""MainAccountCode$"", GLRtnSales) retVal = oHeaderObj.GetValue(""ARDivisionNo$"", division) NewRtnSales = GLRtnSales&""-""&division retVal = oBusObj.SetValue(""SalesAcctKey$"", NewRtnSales, ""kACCOUNT"")

You should check your return value after the Find. I could never get partial keys to work. I am assuming you initialized GLRtnSales and division to empty strings.

What are you looking for in the Main Account Code? Can't you just assign ""4181""&""-""&division?

The oGLAccount.Find() will be looking for a matching AccountKey in GL_Account. I would expect the find() function to fail in this example. if you already know the hard Main account value (""4131"") skip the oGLAccount object entirely.

@MichaelNottoli tried that, didn't work so I went to the other method. @DougJenkins I'll try that thanks.

I did this and it worked (this was a column post -validate on the item code) GLRtnSales = """" NewRtnSales = """" division = """" Set oUIObj = oSession.AsObject(oScript.UIObj) GLRtnSales = ""4181"" retVal = oHeaderObj.GetValue(""ARDivisionNo$"", division) NewRtnSales = GLRtnSales&""-""&division retVal = oUIObj.InvokeChange(""SalesAcctKey"",NewRtnSales , ""GD_Lines"")

That's a neat way to do it @NicoleRonchetti . I ended up using the following, which worked, finally. Mine is column post-validate on shipped qty: retVal = oHeaderObj.GetValue(""ARDivisionNo$"", division) NewRtnSales = ""4181""&""-""&division retVal = oBusObj.SetValue(""SalesAcctKey$"", NewRtnSales, ""kACCOUNT"")