Skip to Content
author's profile photo Former Member
Former Member

Clearing GR/IR with Price Variance

Hi Friends,

1) We created a PO with Qty 1 and price $ 67.50.

2) First, GR was made and system calculated $ 67.50 as Moving Average Price.

3) Then Invoice was entered for $ 73.17.

4) For some reasons, GR was reversed. This time system calculated $ 73.17 as value, instead of 67.50.

5) Invoice is now reversed for $ 73.17

6) GR is again made 2nd time with value $ 67.50

7) Invoice is now entered again 2nd time with value $ 73.17

The Net GR value is now $ 61.83( 67.50 - 73.17 + 67.50) AND Net Invoice value is 73.17

When Invoice was posted, it cleared GR/IR for Net GR value of 61.83 and it posted another 11.34 for 'Office supplies GL account.

When we run MR11 to clear GR/IR, it does not clear the above 5.67 dollars ( It should have been 73.17 - 67.50 to get 5.67 dollars ).

My question is, Has system calculated correctly during last Invoice posting and there is no GR/IR balance ?

When we run FBL3N report for GR/IR clearing account, we see a balance of 5.67 and normally we would see 0 here.

Any help is appreciated.

Niranjan

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2008 at 03:44 AM

    Hi,

    When you canceled the first IR it should reverse the GR value of 67.50 and office supplies of 5.67.

    When you do the second GR it should take the GR value $67.50.and $5.67 as the price diff account or office supplies account.Plz check the Office supplies G/L account.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2008 at 03:31 PM

    Hi Kari Srinivasa Rao,

    I checked the first IR reversal, and there is no 'Office Supplies' Account. Just Vendor line item AND GR/IR Clearing line item.

    When First Invoice was posted, it was posted with 5.67 for Inventory Account.

    It looks like that when PO was initially created, it was created with 'Account Assignment Category' blank. Then later changed to 'K' - Cost center and user entered 'Office Supplies' GL Account. Do you think this would have screwed up the Accounting entries ?

    Niranjan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 01:22 AM

    How can u cancel GR without cancelling IR. Funny

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 23, 2008 at 08:07 AM

    1) We created a PO with Qty 1 and price $ 67.50.

    2) First, GR was made and system calculated $ 67.50 as Moving Average Price.

    3) Then Invoice was entered for $ 73.17.

    4) For some reasons, GR was reversed. This time system calculated $ 73.17 as value, instead of 67.50.

    *If you reverse the GR despite of Invoice is posted, it will pick the value of invoice but not the PO value.

    In this case GR/IR will be debited 73.17 and stock/expense account will be credit with 73.17 (because in invoice stock/expense debited was 73.17)

    So net debit on GR/IR will be 5.67 dollars

    5) Invoice is now reversed for $ 73.17

    6) GR is again made 2nd time with value $ 67.50

    7) Invoice is now entered again 2nd time with value $ 73.17

    In this case GR/IR debit will be 67.5 and stock/expense accoutn debit will be 73.17 (67.5 + 5.67directly)

    So total debit on GR/IR will be 5.67dollars that you will see on GR/IR clearing GL account balance.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.