FIFO Cost and Closing Inventory Valuation

[PhyuLayKhine333]

FIFO Cost of Sales and Closing Inventory Calculation

yesterday

Hi All Experts,

I am beginner to BI and tried many methods in order to get the below result and also google about this problem but i did not get the correct answer and have no ideas how to use the relevant formula to get this below result. 

Any suggestion of fomula to get the below result?

Thanks and Regards,

Sales Table

Date	Product Name	Quantity
10/10/2022	A	10
10/12/2022	A	3
10/12/2022	A	2
10/13/2022	A	1
10/10/2022	B	22
10/11/2022	B	10
10/12/22	B	3

Purchase Table

Date	Product Name	Quantity	Cost
9/12/2022	A	10	110
9/30/2022	A	4	130
10/1/2022	A	6	150
9/1/2022	B	20	210
9/2/2022	B	20	250
9/20/2022	B	10	230

The result i want to get;

Date	Product Name	Quantity	Cost of Sales	Closing Inventory	Closing Inventory Value
10/10/2022	A	10	1100	10	1420
10/12/2022	A	3	390	7	1030
10/12/2022	A	2	280	5	750
10/13/2022	A	1	150	4	600
10/10/2022	B	22	920	28	6800
10/11/2022	B	10	2500	18	4300
10/12/22	B	3	750	15	3550

[Daryl-Lynch-Bzy]

Hi @PhyuLayKhine333 - it appears you have asked the same question four different forums.  Do you still need a response?

[PhyuLayKhine333]

Yes sir, I sill need a response .