2 Replies Latest reply on Apr 6, 2015 3:43 PM by philmodjunk

    How to prevent my "inventory on hand" from getting a negative quantity?

    juliorosell

      Title

      How to prevent my "inventory on hand" from getting a negative quantity?

      Post

       all:

       
      I think I'm almost done with my inventory data base.  Thanks a lot in all the help you provide here (@GuyStevens).  I have all my calculations down pat and my conditional values working. Now, I would like to get a custom dialog if the person in charge of data entry oversells an item.  For example, if I have 5 cases on hand, I only want said person to be able to sell no more than 5. in other words, I dont want any negative quantities in my stock.  I know I need a script or a trigger here, but I'm not sure how to go about.  Any help would be greatly appreciated!