Sage 100

 View Only
  • 1.  Need to Require User to Select a Warehouse

    Posted 11-25-2019 08:00

    User company has several warehouses.  The warehouse code on PO's defaults to 000 but the purchasing department doesn't always change it to the correct warehouse.  Management would like to leave the warehouse code blank and make it mandatory for the user to enter it.  PO options requires a default warehouse.  What process can be implemented to ensure the correct warehouse code is entered during PO entry?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    ------------------------------


  • 2.  RE: Need to Require User to Select a Warehouse

    Posted 11-25-2019 08:40

    One possible work around may be to set up a user-defined drop down box of warehouse codes that are required to be selected.  The user would not be able to accept the order unless the field was selected.  Once selected, we would have a VB script to change the standard warehouse code field to whatever the user selected from the required drop down box.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    ------------------------------



  • 3.  RE: Need to Require User to Select a Warehouse

    Posted 11-25-2019 09:20
    @Doug Higgs Our customer had the same need and we accomplished with a custom program to blank out the warehouse code, thus requiring the user to populate the field before the entry could be saved. ​

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 4.  RE: Need to Require User to Select a Warehouse

    Posted 11-25-2019 10:00
    Thanks @Michelle Taylor  Did you use a script or a ProvideX overload? ​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    ------------------------------



  • 5.  RE: Need to Require User to Select a Warehouse

    Posted 11-25-2019 10:34
    Most welcome @Doug Higgs  The required steps couldn't be accomplished with a script, had to go with ProvideX overload.​

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 6.  RE: Need to Require User to Select a Warehouse

    Posted 11-26-2019 00:43
    Script on the post-read event of PO_PurchaseOrderHeader with either of the following will work. You could further expand this to check if the user is a member of a role to determine whether the action is applied.
    If oBusObj.EditState = 2 Then oBusObj.SetPartialRecord "", oScript.Evaluate("CPL(""IOLIST WarehouseCode$"")")
    Or
    If oBusObj.EditState = 2 Then oBusObj.SetValueNoValidate "WarehouseCode$", ""


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------