Budget Actual commitment item report

[sarvottam_tomar]

Dear Expert,

We have BCS budgeting. My clients wants report. Actual Commitment report. Their simple query please tell me the items where we consumed our budget, How many PR PO and others we have created and it should match FMAVCR01 report. They are not interested in side +/- items are there. They want to know how much budget we have and where we consumed. they are checking the PO value but in 9H it is coming same amount in +/-. We suggest to FMRP_RFFMEP1AX report also. but again same thing +/-. so In this case we should follow 9I or 9H.

How to find out the actual budget which they have consumed and tally in FMAVCR01 report.

Regards

[iklovski]

Depends on your needs. You can use Report Writer and use 4FM library or develop one.

[iklovski]

Hi,

I'm not sure what you exactly mean by referring to "+/-", as this setting in reports is a customization. Nevertheless, standard report for budget consumption can be called via FMRP_FW_BUDCON transaction.

Regards,

Eli

[sarvottam_tomar]

Dear Eli,

Thanks for your reply. But this report FMRP_FW_BUDCON . is overall budget not in line item wise . i want to know PO and PR wise budget consumption. Please check attached. budget-report.jpg

[iklovski]

FMRP_FW_BUDCON is totals, but you can double click and drill-down on document level to the relevant commitments/actuals FM report

[sarvottam_tomar]

Dear Eli,

Not able to double click. Message got is Line item Displayed 1. Please find the screen short. I think in this report 30 line item and in FMAVCR01 more entries, May be if this report will open. Mine requirement can met.

Regards

Sarvottam line-item.jpg

[sarvottam_tomar]

Dear Eli,

My Client requirement is they want to check how much budget we consumed . that they can enter the fund center and commitment and they get the report on total level. Now they want to check this consumed budget where i consumed. they know ,so many PR PO they created. Now They are going line item level after double click. Here if they do sum on commitment and payment budget. that sum is same whatever in out side total. But here they want to check in which which po how much consumed. here they are not able to find correct amount of value. because they created suppose 10000 USD but here amount is coming in + /- .. there question if i created PO 10000 USD system should show 10000 USD consumed. Why it is coming +/-. if we created 10000 USD PR/PO. in report it should come 10000 USD ? Please find the attachmentbudget-issue.jpg

[iklovski]

Because the report shows the actual status with your commitments (POs, etc.). If a PO of 1000, has an invoice of 450, you would see it in the report with +/-. If you want to see how much you committed without reductions, then filter your line report on 'amount type', taking only the initial amounts.

[sarvottam_tomar]

Dear Eli,

Thanks for Your reply. But i am totally confused now. I select the original Amount type(0100) but it is mixed the items. Example -suppose we create the PR and after that PO. Both item is coming with commitment value if my budget committed at the time of PR why in PO also coming in 0100 Amount type.Budget will be commit one time, at the PR creation time or PO creation time. why two times commitment value is coming? business requirement is that how much budget they consumed at the time of PR and PO creation. all budget will commitment in PR level but only for agreement ( RPO -PO type) will create at the time of PO creation.

Regards

Sarvottam

[iklovski]

Yes, in your case both PR and PO will come with amount type 0100 - this is perfectly normal. But, when your PO consumes PR, you will see a reduction with 0200 registered under PR. Hence, if you sum up all the relevant items, you will see the consumption. Example: PR - 1000, PO - 600. You would have 0100 with 1000 for PR, 0100 with 600 for PO, and 0200 with -600 for PR. Altogether, you will see still only 1000 of consumption. POs, which are registered with out PR don't fall out from this framework: the report will work just the same.

[sarvottam_tomar]

Dear Eli,

Thanks for share the fruitful information. i took a example of one PR in which budget deducted and commit at the time PR creation and When Po created system reduced the budget from PR and create the budget line item against the PO. Now one requirement business want a report where i can give the real budget report where we can check ok this was PR and against this PR my PO created and how much invoice has been proceed. In this report they want real basic information of budget consumption. how we can create this report. Please find attachment. budget-treatment.png

[iklovski]

Build a report by value type, and you will get the required result

[sarvottam_tomar]

Dear Eli ,

How we can custom the report ? we need ABAPer or any thing in SAP FM where we can custom the report same FMAVCR01.

Regards

Sarvottam Tomar