IM_Itemwarehouse Message box

Trying to figure out how to get a message box to pop up in SO entry when a user enters a line for warehouse '000' for example, however there is 0 available for that item in warehouse '000'.  On that same item we have 2 available in warehouse '001', I would like a message box to show saying that inventory is available in this other warehouse.  I know SAGE has a native function (pretty sure) for this, but we had to turn it off for other reasons.  I started the script but getting kind of lost once I need to look in other warehouses.  Trying to attach but not letting me.

Parents
  • 0

    If oSession.CompanyCode = "TST" Then
    
        rVal = 0
        sItem = ""
        sItemType = ""
        sWHS = ""
        oItem = 0
        QOH = 0 'QTY ON HAND
        QOS = 0 'QTY ON SALES ORDER
        QORD = 0 'QTY ORDERED
        QAVAIL = 0
        QPULLED = 0
        sType = ""
        oItemWhse = 0
    
        set oItemWhse = oSession.AsObject(oSession.GetObject("IM_ItemWarehouse_svc"))
    
        rVal = oBusObj.GetValue("ItemType$", sItemType)
    
        if trim(sItemType) = "1" then

  • 0 in reply to jland47

     rVal = oBusObj.GetValue("ItemCode$", sItem)
            rVal = oBusObj.GetValue("WarehouseCode$", sWHS)
            rVal = oItemWhse.SetKeyValue("ItemCode$", sItem)
            rVal = oItemWhse.SetKeyValue("WarehouseCode$", sWHS)
           
    

Reply Children