Reconciliation datasource for Old General Ledger

[Former Member]

Hello,

According to OSS note 1397649, SAP has delivered a standard reconciliation datasource for new general ledger only. We have not implemented New GL, so this datsource will not work. Is there any standard reconciliation datasource provided for old GL? We are using datasource 0FI_GL_4 and there has been a request to reconcile BI-FI data with ERP data.

If standard datasource is not available, then what other options do we have to reconcile BI data with ERP data?

Appreciate any inputs at the earliest.

Thanks in advance,

Ann

[Former Member · Accepted solution]

there are different ways to reconcile the GL data. And this has been dealt in the forum before many times.

Create a remote cube on the datasource (I guess GL_4 has direct access) with high level aggregation for query performance. And create a multi on top of your regular GL cube and the remote cube. create a report on top of it to compare the amounts for a period or whatever dates you guys go by. Schedule it to run a broadcasting report after the daily data load batches - you can put a exception to highlight the differences if you want.

[Former Member · Accepted solution]

Thanks for your response.

Yes, we did consider direct access...In this case, we are reconciling against the same datasource and this may not be 100% accurate because there is a very good chance that the datasource itself is incorrect. So we will have a report with incorrect results matching. Pls correct me if I am wrong.

Thanks,

Ann

[Former Member · Accepted solution]

Your extractor should get the balances that are available in the tables and I dont see why the results can be wrong. Anyway, the other way would be to do a manual check of balances on totals table (or any custom report in ecc) and tie it back to BI totals.