GRIR report and G/L account balances (transaction FS10) amounts are not matching

[former_member219118]

Hi All,

We have a GRIR report (basically program using EKKO,EKPO,EKBE and some other tables) in R/3 system.

Now we are facing issue with this report, user is saying the amounts in GRIR report and G/L account balances (Transaction FS10) are not matching.

So can any one help me how to proceed to resolve the issue.

Thanks in advance and points will be given for the reply.

Thanks & Regards,

Suresh

[former_member219118]

Hi All,

Thanks for your replys.

I have reconciled the data of transaction FS10 and our custom report with the PO numbers. 

PO numbers that are present in FS10 almost all present in our custom report. But the PO numbers that are present in our custom report not all present in FS10.

Can any one could explain me, what might be the reason.

Thanks,

Suresh

[Former Member]

Hi

You should download the result of your custom program in excel and the result of FBL3N report. For FBL3N report you should select all the transaction of particular posting periods and compare those two report by using vlook up formula. Then you can come to know which entry is missing in your report.

Most probably there can be some entry missing from reclassify entry using t.code F.19 at the month end. But better you should compare both the result to identify the discrepancies.

Thanks

Pooja

[former_member219118]

Hi Pooja,

Thanks. I have a concern.

How can I reconcile my report data with FBL3N report. I am having PO number in my custom report.

Can you please explain me how to get the data from FBL3N based on PO number

Thanks & Regards,

Suresh

[Former Member]

Hi Suresh,

In FBL3N, you can find PO number in field REFKEY1. In change layout, you can bring this field.

Regards,

Niraj

[former_member251898]

Hi

Firstly you may perform the reconciliation between FBL3N (GL open item display), F.19 and MR11 and your Bespoke program from those tables to identify which transaction are causing the discrepancy that you are alluding to.

cheers

taro

[esjewett]

Is this a question about data warehousing, or is it about ERP financials? It sounds like ERP financials. Can you confirm and then I will move the question to the proper forum?

Also, please do not promise points in your question. The ask you not to do this. It is assumed, so there is no need to mention it.

Best regards,

Ethan

(moderator)

[former_member219118]

Okay Ethan, You can move it to Financials....