Difference for GR/IR between FBL3N and MB5S

[Former Member]

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;

[former_member198650 · Accepted solution]

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

[Former Member · Accepted solution]

salam Mukthar;

       hope u r doing well and thanks for your help;

actually I have no issue between the PO price and the invoice price. what is happening, as u mentioned exactly above, that the balance of GR/IG at FBL3N (FI level) is not equal to balance GR/IR at MB5S (MM level).

my requirement is:

     - To know why such difference exists and how to settle it.

again thanks a lot for your kind help and support Mukthar;

kind regards;

Ahmad Mahmud;

[former_member198650 · Accepted solution]

Walekum salam Ahmad,

The MB5S report displays the delivery costs along with price. If you filter the condition type as blank and check the balance between both the reports. Definitely it will match. However, you have to select same selections for both the reports. Then only it will match.

Regards,

Mukthar

[Former Member · Accepted solution]

One simple reason could be manual posting by some users on GR/IR account in FI which is not reflected in MM.

The other reason could be exchange rate difference at the time of GR and IR, even if the amount in foreign currency value is the same but foreign currency valuation for GR/IR account is not carried out correctly.

[Former Member · Accepted solution]

Thank you very much Ritesh;

     unfortunately either reasons are not existing where:

1. I checked all entries through the Doc. Type, where they are all comes from the MIGO when goods receipt (GR) which posts to the WE Doc. Type or through MIRO when invoicing the vendor that's to say (IR)  which posts to the RE Doc. Type. And al transactions are either WE and RE only which means they are all either MIGO or MIRO so there are any single FI posts to the GR/IR account, moreover it is marked for Automatic Postings only in the FS00.

2. There is no any exchange rate difference could arise in our case were we do not use currencies and there is no currency revaluation or any transactions occurred related to currency.

If u have any more explanation, I will be appreciating that to you so much.

Thanks you very much for help;

Kind regards;

Ahmad Mahmud;

[Former Member · Accepted solution]

Same selections and CType is set for blank !!!

i sent for u an e-mail with printed screens on your e-mail where I could not attaché it here because word doc. is not attachable here and it requires certain formats I could not manage to get.

So kindly check your e-mail and advice if you see that there could be any further explanations.

Thank you very much;

Kind regards;

[former_member198650 · Accepted solution]

WAS Ahmad,

I have gone through your attachment,select the material field from the layout in FBL3N report and cross the materials with MB5S report. If any materials are missed in MB5S report.

Regards,

Mukthar

[Former Member · Accepted solution]

User can use Document type WE and RE for posting manually. Check the FS00 changes to G/L account master data to check if automatic post only check was removed at some point in time.

In case above is not true, raise an OSS message as due to system issues some tables are not updated and hence SAP provides certain reports/program which compares the standard table updates and synchronize the data across the tables.

[Former Member · Accepted solution]

Hi ahmad,

May be they have cleared wrongly i.e. cleared wrong MIGO with wrong MIRO(irrelevant) not relevant in f-03. And in case of GR based or service based tick not updated in PO ,  MIGO number will not updated against MIRO in the table BSIS.  Verify field XREF3 in BSIS table . It may create confusion to clear MIGO and MIRO. and therefore it will create leads to wrong clearing and will create mismatch

Verify is there any chance of manual JV in f-02 with document type WE or RE. so verify whether all documents have been posted through MIRO and MIGO or not? For that you are required to verify filed AWKEY in table BKPF table.

Regards

Krishnareddy

[Former Member · Accepted solution]

hi Krishnareddy;

     thank you very much for your kind help.

please clarify more where I feel that the key answer is hidden between your lines, so let me analysis all what u have said in details to find out the answer which i am expecting to be there.

- (May be they have cleared wrongly i.e. cleared wrong MIGO with wrong MIRO(irrelevant) not relevant in f-03.)

** This phrase i guess it is far little bit from the issue where clearing will not affect the balance whatever it is done correctly or mistakenly as far I think. So, from my point of view (which could be wrong) clearing has no effect or relation to the difference in balances between FBL3N and MB5S.

- (And in case of GR based or service based tick not updated in PO ,  MIGO number will not updated against MIRO in the table BSIS.)

** This phrase I can not understand it.

- (Verify field XREF3 in BSIS table .)

** I verified this field which is also called the (Reference Key 3) on the level of my GR/IR account and found that it is including some records with some line items and some are empty all.

However, I checked manually most of the transactions on GR/IR account and found that they are done by either MIGO or MIRE only and the GR/IR account is marked for Automatic posting only.

-  (It may create confusion to clear MIGO and MIRO.)

** please clarify what kind of confusion it may create, where such point is not clear to me.

- (Verify is there any chance of manual JV in f-02 with document type WE or RE. so verify whether all documents have been posted through MIRO and MIGO or not?)

** Verified, no chance for FI posting on the WE or RE where all transactions are from MIGI and MIRO only moreover the GR/IR is marked for Automatic Posting Only on the FS00.

-  (For that you are required to verify filed AWKEY in table BKPF table.)

** I checked and verified but do not know how to know whether there are FI postings or not through that field Reference Key (AWKEY), however I manually checked that on the FBL3N as mentioned above and found no FI documents, but if there is a way to know that through AWKEY field with more accuracy that will be fine.

N.B.: the GR/IR balance in the MB5S is greater than the Balance for GR/IR on FBL3N which means that there some transactions has been done on the MM affected the GR/IR with no financial impact, or reversing entries for GR/IR has been done through FI but as far I see that is not the case where there is no any FI documents has been found.

Again thank you very much Krishnareddy for your effective help;

Kind regards;

Ahmad Mahmud;

[Former Member · Accepted solution]

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.

[former_member200703]

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

[former_member200703]

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

[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;