Invoice Wise Payment Detail report

[Former Member]

Dear Experts,

I want to create a report where for each Invoice booked in Accounts payable what is the Payment Made.

I am able to find documents where Partial Payment is made or full payment is made based on Invoice Reference Field ( REBZG)  and Clearing document ( AUGBL) ( Single payment and single invoice).

But in some cases where multiple payment has been made or single payment and multiple invoice has been adjusted partially or fully in such cases i am not able to pinpoint exactly which payment amount to take to which invoice. Also cases where single down payment is cleared with a invoice fully and another invoice is partially cleared.

Can some one suggest how to go about to make this report .

[former_member222241]

Hi,

Please check transaction code S_P99_41000099 - Payment List.

Menu path

SAP Easy Access --> Accounting --> Financial Accounting --> Accounts Payable --> Information System --> Reports for Accounts Payable Accounting --> Payment Transactions --> S_P99_41000099 - Payment List

Regards,

Tejas

[Marssel700]

Levell,

you can have this report using clearing transactions list display.

You activate invoice reference list view and run clearing list (F-51, F-53, F-28, etc) and activate refence document by ícons or

Regards

[Former Member]

Marssel,

Thank you very much for the information. But my requirement is to create a Z report .

What you have suggested is in transaction level.

[Marssel700]

,

Partial payments are fecthed from BSEG-REBZT according entries P or Z and REBZG equal main invoice

You can select BSEG-BELNR, KOART = 'K' for main invoice, and select REBZG = BELNR to find refenced payments.

Regards