Hello,
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.
stock
item
:
Discription quantity :
amount that is in stock
order_items
Item:
discription Quantity :
amount to be send for client.
if Quantity order > quantity stock => order difference and put quantity in stock to
zero
if Quantity order < quantity stock => no need to order anything, decrease stock
with required quantity.
how can i manage this ?
thanks
You have two type of orders. Order from your clients (which you reduce from your stock) and orders that you need to make if your stock is short.
thanks for your reaction.
creating a workflow is not difficult but then i amuse that i need to connect this to an action.
it is with the action that i have the problemโฆ
as this order is created in the table orders and takes his amount with a ref out of the stock tableโฆ
how do i give the correct row/ table to the action so it knows what it has to adapt โฆ
i assume we need to use set the value of a columnโฆ
but i donโt see how to create the formulaโฆ
any tips , thanks
User | Count |
---|---|
40 | |
26 | |
22 | |
20 | |
15 |