Quantity formula?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I need a formula for product quantity. Whenever we receive in the items it will automatically deduct it from the ordered quantity field. There also needs to be a way to deduct quantity from the received field when a customer picks the item up, preferably when the customer picks the item up we can mark the date and time for pick up. 
Photo of William Leipart

William Leipart

  • 92 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
I'd suggest you make a "Inventory Adjustments" table.  Then you can handle all the Ins & Outs as separate transactions.  

Then you create two summary fields.  One for the additions to inventory and one for the removals.

Then on you main table you just have a formula [Quantity on Hand] that shows the difference.
Photo of William Leipart

William Leipart

  • 92 Points 75 badge 2x thumb
Thanks Matthew, you wouldn't happen to have a visual would you? 
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb


Hope this give you a better idea of how the adjustment table would work.  Then your summary fields are either "Add" or "Remove" dependent.
Photo of William Leipart

William Leipart

  • 92 Points 75 badge 2x thumb
Hmm that just might work, so # of samples 7 when someone selects Remove, how do you know what quantity is being removed? Or is it that you are removing 7 samples and giving a reason?
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Correct, the "# of Samples" is the qty that will be deducted from the inventory count via the summary fields you make.