AnsweredAssumed Answered

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

Question asked by juliorosell on Apr 6, 2015
Latest reply on Apr 6, 2015 by philmodjunk

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!

Outcomes