Hello
can suggest me how would be a good way to allocate stocks to orders, and know, how much and what type of stock was assigned to each line row of the order
Example
Orders table
<tbody>
</tbody>
Stock table
<tbody>
</tbody>
Result
<tbody>
</tbody>
I hope you can give a hand, this is a mockup of what I have in my work, maybe a link or a video would help me in a big way
Thanks in advance
can suggest me how would be a good way to allocate stocks to orders, and know, how much and what type of stock was assigned to each line row of the order
Example
Orders table
N_Order | N_Item | Qty_Asked |
20001 | 10000001 | 100 |
20001 | 10000002 | 200 |
20002 | 10000001 | 50 |
20003 | 10000002 | 300 |
<tbody>
</tbody>
Stock table
N_Item | Qty_Item |
10000001 | 120 |
10000002 | 400 |
<tbody>
</tbody>
Result
N_Order | N_Item | Qty_asked | Qty_Assigned |
20001 | 10000001 | 100 | 100 |
20001 | 10000002 | 200 | 200 |
20002 | 10000001 | 50 | 20 |
20003 | 10000002 | 300 | 200 |
<tbody>
</tbody>
I hope you can give a hand, this is a mockup of what I have in my work, maybe a link or a video would help me in a big way
Thanks in advance