GR value is greater than PO value.

[Former Member]

Hi friends,

I got a strange situation.

I created a PO material 'x' for the quantity 900 with price of USD 162.00/ea.

Total amount is USD 145800.

But when I do GR it posted to amount USD 265,356.00. quatity is same as 900.

Tha material is valuated with moving average price.

Can anyone tell me what is the reason for this?

Regards,

Marella.

[Former Member]

check your po has any othe condition then the PB00 and/or make sure the price valuation is not STD.

If you mateiral is valuated with MAP then definitely PO has some other conditions.

[Former Member]

HI,

Thanks for your repy.

I checked my PO conditions and it has no other conditions than PBXX and SKTO.

I am stranged why this behaviour?

can any one help me?

Regards,

Marella.

[Former Member]

Dear Marella,

Before doing GR, is that any price changes to the material from other transaction or directly material change price , eg: MR21 ? if you're using material ledger, you can check from CKM3.

Regards,

[Former Member]

Hi w1n,

thanks for your reply.

I noticed the following from my system.

PO created on 02/28/2006 for 900 quantity with a net price of 162 USD.

Invoice 1 is done on 07/18/2006 for quantity 162 with amount 145800 USD.

Invoice 2 is recieved on 08/22/2007 for quantity 738 with amount '0' USD.

GR is posted on 08/23/2007 for the quantity 900.

It seems the system calculated the amount as follows...

from invoice 1 (for qty 162) it took 145800 USD.

for the rest of qty (900-162) 738 the price is taken from PO as 738 * 162 =119556 USD.

The total is showing in GR as (145800+119556)= 265356 USD.

I am not sure whether it is standard behaviour or not.

Please let me know whether it is standard behaviour?

If yes, what can I do to correct the GR amount?

Waiting for your help.

Regards,

Marella.

[Former Member]

Hi Marella, there is an error on first invoice, if the quantity is 162 total amount must be 26244$, but if you see the amount, it corresponds with this post: 900 pieces with 162$ each one = 145800 $, this is the total amount of the PO, for this reason the following invoice has amount 0 USD.

If there isn´t error messages in the system for price or quantity variances, it allows you to change the amount and quantity in an invoice.

Please check the entries in Purchase Order History again, and consult this with the person that post the first invoice.

I hope that this information help yoy

Rose

[Former Member]

Dear Marella,

Here's the standard concept :

If an invoice has been posted for a purchase order before the goods are received, the value of the delivery is known at the time of goods receipt. In this case, the value calculation is based on the invoice. The value of the goods receipt is calculated based on the quantity received and the invoice price. If the invoice was for only part of the quantity, only the actual quantity invoiced is valuated at the invoice price at goods receipt. The remaining quantity is valuated at the purchase order price.

So between your IR and PO net price is not price, and its effected your GR value.

You need to consult with your accounting for this case, the best way is you cancel all the wrong document and post it again with the correct net price in IR, and do GR again.

Regards,

w1n

[Former Member]

Hi w1n,

Thanks for your help.

I suggested my client to cancel the posted documents and recreate with correct values.

but the problem is that there is no stock available now.

Its already consumed.

In this case what can be the possible solution?

Thank you,

Marella.

[Former Member]

Dear Marella,

You just cancel the GI from system (not exactly you cancel the issue in existing warehouse), this is just system procedure in order to fix the issue.

regards,

w1n