FIFO Consumption

[learnbcvibe]

Hello Experts

how can we Sale this item in Fifo Order. once the 1st Purchase is consumed then only it should take from the 2nd Purchase

what is the way to acheive it.

In this Eg: once item A has with 500 Qty. till that 500 qty was consumed it should take from the 2nd Purchase of 300 qty.

[lbendlin]

You are not currently indicating the order of the rows.  You need to provide guidance on how to sort your input data in the right order (with an index column for example).  Then you need to explode the item amounts into individual rows and then use the "keep top rows" and "drop top rows" mechanics to apportion the sales.

Your sample data does not describe your issue sufficiently. Please provide better sample data that covers all scenarios.