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

Elliot,

Thank you so much! That makes sense that you can't edit the Detail file directly, and I've never done this particular thing before (edit a business object I'm not currently in). Also, the "PurchaseOrderNo$" field is a stock Sage field. It gets populated automatically when doing the "Generate PO" button in Sales order, or from the "Generate PO from SO" utility under Purchase Order. 

Thanks again for your help!!

(Re-purposing a stock Sage field to do something else can have unexpected results... UDF's are better for scripted custom purposes).

Kevin,

Thanks for the heads up. In this case, I want the built in Sage behavior to happen to this field. The script I'm writing is to add a SO line to a PO. I want to populate the "PO Number" field in the SO, so that if someone was to click "Generate PO" on that SO, that line would not get put on a new PO, thus preventing double ordering. There's no way to do that with a UDF, that I'm aware of. 

*edit: That field isn't only an automatically populated field. It is user editable for the exact purpose of the above explanation.

Nope on the UDF, I suspect he wants to manually enter the sales order number in the Sales Order Number field  in the purchase order line and have it automatically write out to the Sales Order.  This field is used when you automatically create purchase orders but you can manually select a sales order