Update SO field from PO button script

Question

I'm trying to write a button script that will copy a single line from a SO and "pull" it into the open PO. I've done this successfully for SO (copying from Invoice or SO/Quote History), but with PO, I'd like to be able to "tie" the SO and PO together when copying the line. I can easily put the SO# into the PO line, but I'm stuck when trying to add the PO# to the SO line (since the SO isn't open and the script is running from the PO). 
 The following snippet results in an "Error 65: Window element does not exist or already exists" 
 Set oSO = oSession.AsObject(oSession.GetObject("SO_SalesOrderDetail_bus")) retVal = oSO.SetKeyValue("SalesOrderNo$",srcOrdNum) retVal = oSO.SetKeyValue("LineKey$",sLineNum) retVal = oSO.Find() retVal = oSO.SetValue("PurchaseOrderNo$",sPONum) retVal = oSO.Write() 
 
 Is this even possible?

jepritch · Accepted Answer

chuntley87 
 Yes, this should be possible however, you cannot modify the Sales Order Detail business object independently like that. You must always go through the header object. 
 You should put more error checking in than I have done below and I haven't tested this, but something like this should work. 
 Set oSO = oSession.AsObject(oSession.GetObject("SO_SalesOrder_bus")) Set oSOLines = oSession.AsObject(oSO.Lines) 
 retVal = oSO.SetKey(srcOrdNum) If retVal<>0 Then soEditKey = oSOLines.GetEditKey(sLineNum) retVal = oSOLines.EditLine(soEditKey) retVal = oSOLines.SetValue("UDF_PurchaseOrderNo$", sPONum) ' I assume this is a UDF on the SO Line? retVal = oSOLines.Write() ' update line with the change 
 retVal = oSO.Write() ' commit changes to the order End If 
 
 Hope this helps 
 Elliott

Sage 100

Update SO field from PO button script

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING