Lookup based on Multiple Criteria on Multiple Table

[oktovan]

Hi everyone!

I was wondering if someone could help me figure out the formula for the following attached files.
It's about FIFO table calculation that lookup from another table with multiple criteria.
- ID_OUT will always be shown until stock out remaining = 0
- ID_IN automatic choose using reference : PN and STOCK_IN_REMAINING <> 0


Thanks for help !