Skip to Content
avatar image
Former Member

Difference for GR/IR between FBL3N and MB5S

Hi experts;

     I have received an issue from the A/P accountant that by making comparison between the balance for GR/IR account at FBL3N from FI Vs. MB5S at MM there is a difference, however the logic says that they should be the same as was the situation in previous periods.

     With search on SCN forums and other related sites I found that there was same issue but with no answer and no logic explanation.

one answer which I found but I am not convinced about it or can not understand it is:

"

Once there is a difference between IR and GR due to price difference, then for

the case of stock item, if the stock coverage is not sufficient, then such price

change will be posted to PRD Price Difference Account. Another case was dealing

directly with unplanned delivery costs where you would like to post such

additional costs to stock account and since the stock is not sufficiently

covered, the price difference account will be debited with such amount

difference. For foreign currency PO, the KDM account will be used during IR

posting.

"

I do not know what is the relation of price difference and such issue, because as far I know that the GR/IR affected only by two transactions:

1. Goods receipt which creates FI Doc.:

     Dr. Inventory.

        Cr. GR/IR.

2. Receiving Inv. from vendor and record it from MIRO which creates FI Doc.:

     Dr. G/IR

        Cr. Vendor

So what is the relation for price difference or Physical inventory or any else account related to the inventory movements?

N.B.

1. we close the IR to happen before GR because in our business case we may never record any invoice for a vendor without GR. that is why steps are GR at first then IR and entries are done in same sequence as shown above.

2. We have no any currency transaction. i.e. no foreign currency revaluation takes place.

So, Kindly if someone can help with giving any logical reason for such difference or any process or transactions should be carried out on SAP to settle such difference please advice

Thanks in advance;

Kind regards;

Ahmad Mahmud;


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 06, 2015 at 05:55 AM

    Hi Ahmad,

    MB5S displays any difference between GR and IR quantities & its values at MM level and FBL3N displays the GR/IR balances at FI level.

    If there is a difference between invoice price or PO price then at the time of MIRO the system will post the difference if the invoice stock coverage exists then it posts to inventory a/c else it posts to price difference a/c.

    Regards,

    Mukthar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ahmad,

      It is possible to post manual JV for GR items if you removed Post automatically tick in FS00.

      And The field AWKEY in BKPF table is the combination of MIGO No./MIRO No. and year.

      Verify t-code MR11 also.

  • Jan 05, 2015 at 06:59 PM

    Hi Ahmed

    I would like first to ask you about the difference ? is it no count of P.O pending or in the amount..? did you run F.13 Periodically to clear GR-IR.

    the answer you found in one site and  put in your question is far away from your question.. its talking about if there are a difference between GR and invoice , how the system would handle the difference if you posted through unplanned delivery cost , he would charge it to inventory items if its still exist or if it consumed on production he will assigned it to Pre-configured GL to receive production difference cost..

    Regards

    Mahmoud El Nady

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Salam Mahmoud;

           hope u r ding well and thanks for help;

      answer or your questions;

            1. is it no count of P.O pending or in the amount..?

      Answer:

           - If I understand u correctly, I mean the amount or the value of difference between the GR and IR at the MM differs than the amount or value of difference between the GR and IR at the FI. But I do not understand what do u mean by the count of P.O?

           2.  did you run F.13 Periodically to clear GR-IR?

           - Not on permanent basis, but as far I know that F.13 will only clear the equal Debit and Credit amount for the GR/IR account but shall not equalize the balance of GR/IR in FI to be the same like in MM.

           Thanks for confirming that the link which I found is not relevant to our issue where u have closed a gate of doubt for me.

      So, if you kindly have more clarification regarding such issue why the balance of GR/IR in FI not equal to the balance of GR/IR in MM, i.e. balance of GR/IG at FBL3N not equal to balance GR/IR at MB5S.

      Again I do appreciate your help so much;

      kind regards;

      Ahmad Mahmud;

  • Jan 07, 2015 at 10:54 AM

    Hi Ahmed

    I found also that there are a difference between FBL3N & MB5S i am also working to investigate the difference .. i will will keep you informed once finished .. the reason of why we are not depending on MB5S that we add the purchasing Document as special field in FBL3N  so we are now getting the analysis from FBL3N by P.O and we do not refer to MB5S only in rare cases ..

    i believe you should also post his question in supply chain area to see there recommendation also..

    Regards

    Mahmoud EL Nady

    Add comment
    10|10000 characters needed characters exceeded