FIFO based Inventory Valuation in Public cloud

[Lokesh_Mahajan]

Hello Community members,

Our client needs inventory valuation on basis of FIFO method, please guide us how it can be achieved in public cloud.

FIFO based Consumption of material having Price control V and Material Type ROH

1. GR at Different Price

	Qty	Rate	Amount
GR1	1000	45	45000
GR2	1000	50	50000
Total	2000	47.5	95000

1. Standard System behavior

Issue	1500	47.5	71250
Remaining	500	47.5	23750
			95000

1. As per Requirement shared by client

first GR	1000	45	45000
Second GR	500	50	25000
			70000
Remaining	500	50	25000

As 2000 Qty of Material is purchased at two different rates, while doing goods issue (consumption) of 1500 Qty Material system should issue first 1000 Qty @45 rate and second 500 Qty @50 and remaining invetory value should be 25000 for Qty 500@50 

As per above scenario valuation should be done on FIFO basis and same should be reflected in report MB5B ( Stocks on Posting Date) or Analyze stocks in Date Range.

MB5B à

Analyze stocks in Date Range