I am trying to make an inventory management app. i have a section where i can make orders and put item on my order. when i put a new item on it i can select it out of my parts list after it loads in the quantity that is in stock. if i need more than is in stock it will add it automatically to the to be ordered section.
how can i create an action or… that will increase the value in my stock by the used amount in this order ?
so basically you have the following tables.
Discription quantity :
amount that is in stock
discription Quantity :
amount to be send for client.
if Quantity order > quantity stock => order difference and put quantity in stock to
if Quantity order < quantity stock => no need to order anything, decrease stock
with required quantity.
how can i manage this ?