Outgoing Payment Report with Check Details

[former_member631554]

Hi Everyone,

We would want to generate reports for all outgoing payments containing the check details and document description. We have tried joining data sources: ARP Ledger Account Line Items and checkbook register, however outgoing checks with direct posting to G/L is not included on the report. Is there other data sources we can refer to showing all outgoing payments?

Regards,

Mara

[harsh_p9]

Hi Mara,

I have tested the scenarios in my test system, but no luck. It is not possible to see the data in both the fields - 1) Outgoing Check ID and Check Number. As a work around, you can Export the data in excel from Payment Monitor screen. For example:

1) Outgoing Check ID - 92 & Check Number - 1211

2) Over the Payment Monitor UI, you can filter with Payment Method - Outgoing Check.

Click on Export ----> To Microsoft Excel

Also, there are fields like Payment Amount, Payer/Payee Name, Posting Date, Value Date ...etc... are available on this screen - Payment Monitor.

Let us know in case of any clarification.

Thanks & Regards,

Harsh Patel

[former_member631554]

Hi Harsh,

I have suggested this workaround, but unfortunately, client would prefer to download one report with no additional step.

Will propose this on the idea hub for the meantime.

Thanks!

Regards,

Mara Horlador

[harsh_p9]

Hello Mara,

You can use the characterstic/field - Reference Source Document ID from the data source - FINGLAU02. For example:

Outgoing Check: 10848

DS - FINGLAU02

Best Regards,

Harsh Patel

[former_member631554]

Hi Harsh,

I would like to clarify also that we need a report showing both the outgoing check ID and check number. Data sources FINGLAU02/FINGLAU03 has the source document details, which is the outgoing check ID but not the check number. Checkbook register has the check number but not the outgoing check ID. I cannot successfully combine the two because there is no common field that is unique per transaction.

Regards,

Mara Horlador

[harsh_p9]

Hi Mara,

You can join these data sources FINGLAU02/FINGLAU03 and checkbook register.

This will show all the data related to check payments including outgoing checks with direct posting to G/L Account.

Thanks & Regards,

Harsh Patel

[former_member631554]

Hi Patel,

I also want to know the reference payment ID (outgoing check ID) for each check. However, it is not included on the checkbook register.

Do you know of any data source I could refer to? Or any data source I could combine to generate the report?

Thank you.

Regards,
Mara Horlador