FMAVCR01 Consumed Amt Drill down detail results show less than report total

[Former Member]

Our budget reports as well as FMAVCR01 show a consumed amount total of 18,000 for our 1st fiscal year in SAP. But when drilling down to the document journal only 15,750 total items are displayed. Why is that?

Using FMRP_RFFMTO10X I can tell that the difference is in period 1 in which the Cmmts/act is 5,625 but when drilling down to the document journal only 3,375 is displayed.

Period 1 is July. Note that we went live on SAP as of October... Period 4. Even after reinitializing our avc ledger, the discrepancy still exists. Any ideas why or how to narrow down the problem or get to the source of the extra 2,250 displayed in budget reports?

[iklovski · Accepted solution]

Hi,

When it comes to discrepancy in FM, it's very hard to tell what to do without seeing the tables. Try analyzing FMIOI and FMIFIIT for the suspicious documents; check if the amounts are OK. Try rebuilding programs for FM, e.g. FMN5N. Also, try checking the totals in FMIT before running FMAVCREINIT; you can do it via FMAF transaction.

Regards,

Eli

[Former Member]

Thanks Eli,

FMAF worked. Before I close the issue. Any idea on how or why it happened so I can try to explain it to everyone and try to prevent it in the future?

[iklovski]

Hi Will,

Hmmm... That's a tough question without seeing the results of FMAF, at least. Sometimes, something goes wrong with the reassignment (if you did any) or the carry-forward. Sometimes, it's somehow connected to internal process which differs from SAP standard (again, if you have any). Could be really several reasons, but most of them are resulted from enhanced solutions in FM.

Regards,

Eli

[Former Member]

Hello,

In the Document Journal report, please check your layout and make sure there is no filter setting in the layout.

Regards,

Ming