match FIFO (first in first out) basis on stock

Hi,

I having some difficulty on getting a match-off of the purchase & sales.

attached some sample.

1st tab:purchase
2nd tab:sale

Possible to generate a data that match FIFO (first in first out) basis according to the invoices with the item on the purchase whenever there's a new sales?

Much appreciate if anyone can help me on this.

This will rank your dates ( Oldest will be listed as number 1 - there could be several number 1's, so perhaps use a filter ot conditional formatting to see FIFO

Added the FIFO column to the sales sheet