Trace the payment amount through Fund Management

[former_member2128]

Dears Experts , is there any way to trace the payment amount for invoices has funded through Fund reports like tracing the down payment amount .

Noted: as trying i have activated the profile [ 0003501Separate PB/CB budget lines ; standard ] it really ver excited report displayed the data in more detailed but still cant separate the amount payed not only down payment .

BR

Emad Gamal

[former_member2128]

Hi Eli,

I'm using update profile 350 ,so the budget is actually consumed at invoice basis. My issue now is when I process the payment, Value type 57 is not updated with the payment amount , although the mentioned configuration is done. Many thanks Eli for your quick respone.

[iklovski]

Well, in your previous reply you mentioned that while processing the invoice you saw '57' as well. If payment transfer really doesn't work, then consult OSS note "882379 - FMPU_R: Recommendations for the online payment update" in order to check that your settings correspond to the recommendations mentioned there.

[former_member2128]

Hi Eli,

What I'm seeking is to differentiate between the amount that has been invoiced (V.type 54) and the amount that is paid reference to this invoice(V.type 57) through FM

- I have checked the online payment update in OF29

- I have set up KNBELNR and VOBELNR as characteristics in document splitting

- I have created the account payable commitment item Fin.Trans 60 & Item Category 3

- I have created bank accounts commitment item Fin.Trans 90 & Item Category 1

I can give an example to clarify what I'm seeking

1- PO creation with 1000 USD , result 1000 USD with V.type 51

2- Created Miro reference to this PO with 1000 USD , result 1000 USD with V.type 54

3- Paid 500 USD reference to invoice , result 500 USD with V.type 57

[iklovski]

I'm not following you... your example is perfectly OK, but what is the problem?. Where you want to make this differentiation, in a report? Any standard report has value type as dimension. Do you want to build your own report, based on FMIFIIT table? Value type is a field there as well, obviously.

Or you experience issues of how '57' amounts are calculated? Please, specify...

[former_member2128]

how can differentiate between (value type '57') has been carried through invoice and other one created through payment , also still i have an issue to create it value type 57 through direct payment it not carried any FM document even i have create commitment item for all bank accounts (Financial trans 90, Commitment Item Cat 1) .

[former_member2128]

Hello ,

thanks Eli i have used 0350 update profile and in OF29 i have checked online payment flag , once i have created miro i have found

(value type '57', '54' ) carried on report , but need only to carried the value type 57 only for payed .

consider the below terminology uses

Payment :- means all outgoing payment like check-bank , cashe ,bank transfer transfer , ETC .

Invoice :- all transactions has been due through invoices .

BR

Emad Gamal

[iklovski]

With this update profile, you would always get '54' first and then '57'. This is perfectly normal... If you want to filter out '57' value type, you can do it in the drill-down report.

[former_member2128]

Hello ,

value type 57 not transfer to funds reports and at the same time i can see the value type 61 without any problem .

[iklovski]

Hi,

If you use 0350 update profile, then you are supposed to have payment transfer (value type '57') to be set up, either manually (via FMF0) or automatically. At least, as a best practice... I cannot claim it is mandatory, but it is a common sense, especially if you want to see your payments in the budgetary reports.

Have you performed the settings in OF29 transaction for this? If 'yes', what are they exactly (screenshot)?

Regards,

Eli

[iklovski]

Hi,

Payments are registered with value type '57', while down payments - with '61'. So, it should be quite esay to distinguish between them.

Regards,

Eli