Discussions

Expand all | Collapse all

Quantity formula?

  • 1.  Quantity formula?

    Posted 04-25-2017 13:31
    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. 


  • 2.  RE: Quantity formula?

    Posted 04-25-2017 14:23
    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.


  • 3.  RE: Quantity formula?

    Posted 04-25-2017 15:19
    Thanks Matthew, you wouldn't happen to have a visual would you? 


  • 4.  RE: Quantity formula?

    Posted 04-25-2017 15:39


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


  • 5.  RE: Quantity formula?

    Posted 04-25-2017 15:58
    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?


  • 6.  RE: Quantity formula?

    Posted 04-25-2017 18:05
    Correct, the "# of Samples" is the qty that will be deducted from the inventory count via the summary fields you make.