FIFO calculation with serial numbers

[former_member313879]

Hi Experts!

I created a Goods Receipt PO with the following information:

Date               Quantity          Unit Price        Serial Number

9/10/13               10                    2000               1-10

Then I created another Goods Receipt PO

Date               Quantity          Unit Price        Serial Number

9/9/13               10                    1500               11-20

Then I created Goods Issue

Date               Quantity          Unit Price        Serial Number

9/11/13               5                    2000               11-20

My question is why the unit price taken is 2000 instead of 1500 since the posting date of the GRPO for is 9/9/13?

Thanks,

Janice

[former_member186712]

Hi,

What is the price list that you use in the Goods Issue?

What is the valuation methon in the master data?

[former_member313879]

Hi Augusto,

I used last evaluated price.

And the valuation method is FIFO.

[agustin_marcoscividanes]

Hi

can you check the purchase Price for the selected serial number?

I think you are choosing one which you bought in the first or in the last grpo in your example.

SAP B1 shows you the purchase Price for the layer of the ítem.

Kind regards
Agustín Marcos Cividanes

[former_member313879]

Hi

The serial number I chose is the one with posting date 9/9/2013. But the cost it used is the one with 9/10/13 posting date.

Is SAP valuating the cost by system date? It should be posting date, right?

[agustin_marcoscividanes]

Hi

FIFO = First IN  First Out

In your example you wrote the same price for two goods receipt. I am sure the price is right because the first goods receipt has 2000 as price; and the third too.

In a test enviroment try to do your example with three different prices, and you can see as SAP shows you the first cost price; and when you finish this stock SAP shows you the second, and again.

If the behaviour is not as I explain you must open a SAP support message.

Kind regards.

Agustín Marcos Cividanes