Sage 100

 View Only

  • 1.  Prevent SO line if item is negative

    Posted 03-20-2019 13:59
    anyone have a way to prevent a sales order line item if the inventory is negative?  Sage 2018 Advanced

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------


  • 2.  RE: Prevent SO line if item is negative

    Posted 03-20-2019 15:27
    Well just change the valuation to be Lot or Serial so it can't go negative, ha ha! Otherwise you could ask @Marc Cregan to script it for you.​ Alternately you could customize the ALE lookup so it has a filter for Total Qty On Hand > 0 assuming Total Qty On Hand is a reliable number and seeing the qty of all warehouses is okay for them. Also, I once did a mod to show item code ALE lookup but show all item warehouses so they could see the On Hand. I'm sure somebody has that too.

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------



  • 3.  RE: Prevent SO line if item is negative

    Posted 03-20-2019 15:53
    ​Role Maintenance, security option in SO "allowed to backorder all items" or module option "allow to exceed quantity on hand".

    ------------------------------
    Robert White
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Prevent SO line if item is negative

    Posted 03-20-2019 15:57
    Ahh that's perfect @Robert White​

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------

    Original Message


  • 5.  RE: Prevent SO line if item is negative

    Posted 03-21-2019 13:24
    Edited by John Wilder 03-21-2019 14:30
    Update: this works..  but.  if it's a KIT item the exploded items will be 'allowed' to be sold.  Of course, they do some variation of make to order - so they can't sell a serialized item as they don't stock them.  Thanks for the feedback.  May look into a script to review the order before allowing it to be accepted.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------

    Original Message


Related Content