Stock management

[siham]

Good morning Appsheet Support Team

I am raised on a point of my application that manages the Stock:

I wanted the quantity in stock to be physical and theoretical, the physical is what is in stock (which is the total of inputs and outputs (negative quantity), and theoretical is the same physical total minus the unconfirmed reservations of the orders to take into account this amount when making an output.

when the reservation is confirmed, it is removed from the reservation list. And that the quantities are changed in parallel

But I don't get the quantities right, I don't know if I have to add an action or what?

Infos:

Application name: Almacen_PQ
Table name: Products, movements, Reservation_order
Column name: Physical stock,  theoretical stock

Thanks,

[jaichith · Accepted solution]

Dear sir,

Share the table screenshot, expression etc.... Your case solvable .

Want to know about how you done so far...