Split inventories based on FIFO Batch

Hi

I bought Batch1 of 10 items, batch2 of 15 items and batch3 of 10 items again.

From this stock my sales were as follows:
Day1 > 5 items
Day2 > 24 items
Day3 > 3 items

Thus I have three sales transactions.

Can a macro split these Sales transactions as follows using First in First out method:

DAY1>
5 items sold from Batch 1

DAY2>
5 items sold from batch 1
15 items sold from batch 2
4 items sold from batch 3

DAY3>
3 items sold from batch 3

Thanks to all for help