Skip to main content
Question

Quantity formula?

  • April 25, 2017
  • 0 replies
  • 26 views
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. 
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • April 25, 2017
      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.
      Thanks Matthew, you wouldn't happen to have a visual would you? 
      • MCFNeil
      • Registered
      • April 25, 2017


      Hope this give you a better idea of how the adjustment table would work.  Then your summary fields are either "Add" or "Remove" dependent.
      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?
      Terms & ConditionsAccessibility statement