Sage 100

 View Only

  • 1.  Script - Access to Qty Avail in Warehouse in SO Entry

    Posted 06-25-2020 16:55
    Can a UDS access the quantity available in this warehouse in Sales Order Entry - Detail? If so, how?

    ------------------------------
    Myron Stevenson
    Consultant
    Clearis Consulting, Inc
    Duluth, MN
    218-525-6720
    ------------------------------


  • 2.  RE: Script - Access to Qty Avail in Warehouse in SO Entry

    Posted 06-25-2020 17:03
    I'd grab the item code and line warehouse then open a new object to access IM_ItemWarehouse, and do a lookup with a concatenated key (then query QoH, OnSO... to calculate Available):

    sItemCode & String(30-Len(sItemCode),Chr(0)) & sWarehouseCode



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



Related Content