I need help in creating a function that will check each item on the current open order and calculate how much was received for each item.
It is possible to receive more then requested.
Each item can be received on multiple days.
Every time I add an item to the sub from Quantity received, the function should check all transactions. If each item was received at least the minimum ordered, then set the checkbox “Order closed” to true.
I’m attaching a sample DB