Wire and Check Payment Report

[Former Member]

Hi Everyone,

Is there a standard report that can be run to show payments to vendors by check and wire. Currently, we use the check register for checks but can't find one report that would list both checks and wires submitted to a vendor. Assistance would be appreciated!

Thanks,

Pete

[former_member188826 · Accepted solution]

Payment to vendors can be readily identified via unique document type in the dynamic selection area of the line item report FBL1N. You can choose all items from a given date range. There would be Payment method also available in the layout, to sort by check and wire.

[Former Member · Accepted solution]

This is what I am looking for! Is there a way to sum by vendor account but also to view the vendor name? Also, is there a way to sort by total vendor payment? Right now, when I sort, the sum function is removed and the sorting is done on an individaul document level rather than a total vendor level.

[former_member188826 · Accepted solution]

There is a way to sort by vendor, When you choose ALV layout 2SAP, (Ctrl + F9) you may find a ready made layout sorted by vendor. The name is however not available.

Click on layout change, then, go to sort tab to do sorting with more than one characteristics.

[Former Member · Accepted solution]

Hi Sridhar,

Unfortunately, we do not have layout 2SAP.

1. So there's no way to get the vendor number and name visible when subtotaling?

2. Is there any way to sort by TOTAL vendor amount?

Thanks,

Pete

[former_member188826 · Accepted solution]

You can certainly view the vendor in the ALV list of line item. Also you can sort it by vendor. You do not need to worry about the standard layout. You may have to go for an enhancement to get vendor name.

Play around with change layout feature.

[Former Member · Accepted solution]

Thanks for the help Sridhar!!!! Points assigned

[Former Member]

Hi

You can create a Z Report pulling the Data from tables PAYR (For check payment) and REGUT (for wire / edi payment). Hope this will help

Assign points if useful.

regards,

radhika

[Former Member]

Hi Kolipara,

1. No standard reports for this?

2. Table PAYR works well but REGUT came back with nothing.