Sage 100

 View Only

  • 1.  Script SO Total Qty Shipped

    Posted 04-08-2019 18:02
    I believe there is a demo script to calculate and write the SO total quantity shipped into a header UDF during SO Invoice Line Entry.  I would like to use this  Anyone?

    ------------------------------
    Jon Parkinson
    Parkinson Accounting Systems
    ------------------------------


  • 2.  RE: Script SO Total Qty Shipped

    Posted 04-08-2019 19:16
    I found an example where the quantity shipped is written to a UDT. 

    strInvoiceNo=""
    strInvoiceNo=""
    strLineNo=""
    strTariffCode=""
    qtyShipped=0

    retVal = oBusObj.GetValue("InvoiceNo$", strInvoiceNo)
    retVal = oBusObj.GetValue("LineKey$", strLineNo)
    retVal = oBusObj.GetValue("QuantityShipped$", qtyShipped)
    retVal = oBusObj.GetValue("UDF_Tariff_Code$", strTariffCode)

    'msgbox("*"&qtyShipped)

    oShadow = oSession.GetObject("CM_UDTMaint_bus", "SO_UDT_SO_Shipments")
    Set oShadow = oScript.AsObject(oShadow) ' establish oShadow as an object handle

    retVal = oShadow.SetKey(strInvoiceNo & strLineNo)
    retVal = oShadow.SetValue("UDF_Qty_Shipped", qtyShipped)
    retVal = oShadow.SetValue("UDF_Tariff_Code$", strTariffCode)

    retVal = oShadow.Write()

    ------------------------------
    Michael Nottoli
    Accounting Information Solutions
    ------------------------------



  • 3.  RE: Script SO Total Qty Shipped

    Posted 04-09-2019 08:24
    I think you can just use a Business Object UDF:



    ------------------------------
    - Brett
    ------------------------------

    Original Message


Related Content