Forum Discussion

WilliamLeipart's avatar
WilliamLeipart
Qrew Trainee
8 years ago

Quantity formula?

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. 

5 Replies

Sort By
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago


    Hope this give you a better idea of how the adjustment table would work.  Then your summary fields are either "Add" or "Remove" dependent.
  • WilliamLeipart's avatar
    WilliamLeipart
    Qrew Trainee
    8 years ago
    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?
    • MCFNeil's avatar
      MCFNeil
      Qrew Captain
      8 years ago
      Correct, the "# of Samples" is the qty that will be deducted from the inventory count via the summary fields you make.