how to manage FIFO or LIFO from a FI view
for instance i purchased material A for 3 time with different price of 10, 20 and 30 dollar and 100 pieces in each case. i want the first purchased material A (that is 100 pc with the price of 10 dollar) to be issued... then the ones received the second time with 20 as its price... how to realize this?
The System is going to average out the price with every new purchase in case of Price Control V. In case of Price Control S, system is going to generate Price Difference. This is the standard behaviour in valuation.
If you want to valuate lot independently, you may consider using split valuation with valuation category = X (Automatic Batch). Then, you'll have to specify batch at the time of GI.
Another not-so-good option is to create different materials.
_________________
Ajay Singh
first of all,thanks ajaysajay for your hints.
I've tried your method, but there occurs some problem which i need your help again.
i created a new raw material with valuation category X but when i post GR after creating PO, the amount is posted into price difference account instead of inventory account, the valuation type price control (for the automatically created batch) is automatically set to be Standard although I set the price control V at the time of material creation.
The total amount is thus 0 and the MAP is 0 too.
what's the matter? do i have to do some other config to make it work? Does the Batch selection have to be set in Purchasing view of Material master?
I've just simulated this in my development system and it worked fine. I selected material type ROH, Valuation Category H and Price Control V. The system posted material cost to Stock Account. The Batch entry in Table MBEW has price control V.
I'll suggest you to check on two things:
- Does the material type you've selected, allow price control V?
- Account Determination for Stock posting is correct for the valuation class.
Can you post your feedback on this?
_________________
Ajay Singh
thanks, ajaysajay,
yes, i did exactly what u did except that the valuation category i chose was X, would u be so kind as to try that and tell me what happen if possible please?
I've just simulated this in my development system and it worked fine. I selected material type ROH, Valuation Category H and Price Control V. The system posted material cost to Stock Account. The Batch entry in Table MBEW has price control V.