Logic for Payments against FM Budget Commitments

[muhammad_waseem]

Dear Experts,

I am trying to devise the logic for a custom report where requirement is to show the aggregate of all the payments made to Vendors (e.g. via F-53/F-58/F110) against the FM budget commitments saved at MIRO/FB60 level.

Putting it simply, in one column, I have to show the total of payments made against the budget commitments adopted at MIRO/FB60 (commitments are always same in full P2P cycle as client is strictly following the document adoption approach while creating subsequent document PR->PO->GR->IR).

This is basically an extended version of Budget Consumption Report where "Payments against Budget" Column will depict above requirement.

OF29 settings are not applied so online paymeny update solution is not relevant, that's why I have to opt for Z report.

My logic for "Consumable Budget" column is Table FMAVCT and field RRCTY = 1 and for "Consumed Budget" column is again Table FMAVCT and field RRCTY = 0. "Available Budget" column is of course Consumable - Consumed.

Regarding "Payments against Budget" column, I am stuck at the point "How to build the functional logic to get the payment data against invoices on the basis of FM budget address given in selection parameters of the report". If it was to get data on basis of invoice document number given in selection parameters then it was not difficult but when it comes to extract payment data on basis of budget address, here I am facing difficulty to define the connection.

Please guide.

Regards,

[iklovski]

Hi Muhammad,

Even if automatic payment update is not activated, I presume you do the manual one (FMF0 transaction). Without this action, you won't see '57' value type in the system.

Regards,

Eli

[iklovski]

Hi,

Why not using the standard lines report? FMRP_RFFMEP1AX - All Postings or Consumption totals report with distinction between '57' (payments value type) and the rest? You can build one in GRR2, building it on 4FM library.

Regards,

Eli

[muhammad_waseem]

Hi Eli,

Thanks for your input.

I checked FMRP_RFFMEP1AX for a budget address on which full P2P cycle is already run (PR/PO/GR/IR/F-53).

You can see, the P2P cycle flow is not showing Value Type 57 related document. As I mentioned in question post above, the OF29 settings "Online payment update" are not applied.

I also tried to add a new column in GRR2 and specfied Value type 57 with Ledger 9F but it did not worked. For testing, I also replaced ledger value as 9A but no luck.

Note: The update profile is "000102 Payment budget; Invoice basis ; Posting date".

I also checked table FMIFIIT for the same budget address, it's showing only the Value type 54 related lines.

Please guide.

Regards,