AnsweredAssumed Answered

Inventory - How to?

Question asked by WilliamdelaMaza on Sep 1, 2011
Latest reply on Sep 2, 2011 by philmodjunk


Inventory - How to?


I have three different tables on my database related to inventory:

  • The products table -where stock amounts are stored
  • A Line Items table -where quantity of each order is stored
  • An the invoice table -where a portal shows product info and quantity ordered
However, I just can't figure out how to subtract the quantity the user inputs in the invoice portal (line items table) from the stock field for each particular item (a field that is stored in the products table). Can somebody please shed some light on how is this achievable?