GR IR imbalance

[Former Member]

Hi,

I have a PO for which tan invoice was posted before the GR as done. I know that when an invoice exist then the average price of invoice will be taken when the GR price is calculated.

I am having a scenario where I have purchase order history as attached.

Short Text Movement Type Posting Date Quantity Order Unit Amount in LC currency

GR 122 2008-06-24 -60000 EA -60000 TWD

GR 101 2008-06-18 60000 EA 67499 TWD

IR-L 2008-06-13 -1 EA -7500 TWD

IR-L 2008-06-13 1 EA 7500 TWD

Now there is a GR IR imbance of 7499 TWD. Why GR price was calculatres as 67499 when the invoice was reveresed

Thanks in advance,

Regards,

Ramesh.

[former_member197616]

Hi,

As per the given information, i have inferred like this.

IR-L 2008-06-13 1 EA 7500 TWD ---On 13th an invoice has been posted for 7500twd without posting the GR.

On the same day this invoice got reversed (IR-L 2008-06-13 -1 EA -7500 TWD).

means the PO is afresh which can accept the PO price during GR.

GR 101 2008-06-18 60000 EA 67499 TWD--- on 18th a GR has been made for this PO which took the actual PO price.

GR 122 2008-06-24 -60000 EA -60000 TWD--- The same material has been returned to vendor on 24th.

As per the given information by you this situation is not the GRIR imbalance (As the entered invoice invoice is reversed before posting of GR)

In general if you post invoice before GR system will take the material master price.

It needs till more details like a)are there any PO price changes before returning to vendor and after the GR b)Does the PO is ordered in which UOM (opun/buom)c)Intial PO price etc.

Requested to provide some more data.

[pankaj_singh9]

Hi,

There might be stock deficit at that time, check once.

[Former Member]

Hi Pankaj,

the material is non stock item. No material master exist for the item

Regards,

Ramesh-

[Former Member]

Ramesh

Did you fix that issue? I got the same problem.

Thanks

Ronnie