Looking for 2 reports

[Former Member]

I am looking for 2 reports:

1. A report to tie the AA subledger to the General Ledger. In our company, we have several scenarios in which we post retirements/acquisitions with value dates in the past months and post it in the current period (which is open). This causes the balance on the subledger to change as of that value date, which is fine. However I cannot find a standard report to tie the balance to the sub-ledger. The report date on the standard report seems to pick up transactions in the subledger even if they have a future posting date. e.g. Report date 3/31 would pick up transactions that were posted with a value date of 3/15 but a posting date of 8/31. I need a report where I can pull balances by the Posting Date. The auditors need this to ensure that the sub-ledger and G/L are in sync. I am sure this is not an exceptional requirement. Can any one tell me how they handle this?

2. I need a depreciation comparison report where I can compare depreciations of each period in a year side by side. Something that would have all the 12 periods and the total depreciation for say an asset class.

Thanks

[Former Member]

This message was moderated.

[Former Member]

Thanks for the quick reply. When I execute the first report (S_ALR_87012043), I get an error saying that the variant does not exist. I have not chosen any variant, so I dont know why its happening. The other one looks like its the G/L trial balance, like FS10N..how would I reconcile that with the sub-ledger? Can you please let me know.

For the depreciation: the transaction S_P99_4100192 does not exist. We are on 6.0.

Thanks

[Former Member]

Regarding the variant error, ask your basis/abap guy to fix. It is a quick simple fix.

Normally people uses ABST2 to reconcile FA with GL. FAGLB03/FS10N is other way to make sure your FA reconciles with GL. You can run Asset balance report with current book value check checkbox based on account determination or bal. sheet accounts sort version and match the amounts with FAGLB03 or FS10N report.

Please try this S_P99_41000192. I missed one zero in the report name.

[Former Member]

Thanks for the response once again. I already know about ABST2 but the auditors want detailed reports. ABST2 just gives you the differences. Now as for the Asset Balances and the FS10N, thats where the whole issue starts. The auditors come in every 4 months and they look at the sub-ledger and G/L for those months to try and tie it out. Here the reason why we have an issue.

Example: Say the FA balance was 1000000 as of 3/31 and it tied to the G/L as of 3/31. On 9/15 I post an entry to acquire an asset for 30000 with a value date of 3/20. The result is that if you run the asset balances report as of 3/31, it would show a balance of 1030000 and also an increase in the planned accum. However if you run the FS10N and look at the cumulative balance at the end of March, it would be still 1000000 since the 30000 was posted to the G/L in september and not march. When the auditors look at these 2 reports, they think that sub-ledger and G/L does not reconcile. I tried to explain the reason and they understood. However, they need a report to see it.

[Former Member]

By the way, ABST2 shows no reconciliation errors, so I am sure that we are fine. Its just that we need a report to show the auditors.

[Former Member]

You do not have any FA continuity reports like additions, retirements and so forth developed? Instead of running asset balance report, you can show them the transactions reports for add, transfers, retirements and try to match it with the GL balance. If your asset APC and Acc Dep GL accounts are "recon" accounts than FA automatically reconciles to GL.

Also in your example, 3/31 is already reconciled and approved. After your add entry posted in 9/15 for value date 3/20, why would you report based on 3/31 again which is already reconciled. The entry was posted on 9/15, you did not open March month for this entry. Asset value date (in combination with period control) is used to control the start and stop of depreciation. You should run report as of 9/30 and show it to your auditors for the adds.

[Former Member]

Hi,

You can use asset history sheet (t-code S_ALR_87011990) for the detailed report.

Regard,

[Former Member]

We do have the retirements. additions etc reports. In fact when the auditors question the reconciliation we have to rely on running a bunch of reports to reconcile. I do realize that SAP reconciles automatically and the client does too...but Auditors demand to see it for whatever date they wish in that year. Also, we do tie out everymonth which further confuses the auditors since they demand to see the same number that we have when we closed the month.

I have discussed this with auditors and they say that "We dont think its a strange request to ask SAP to show that we tie to the trial balance as of a past month"

I have sent queries to SAP back and forth....I think we have to develop a report which gives info using posting date and not the "report date" thats the only way out