Issue getting a Vendor Payments Batch Summary

(0) Share

Report

Posted on by Community Member

I am trying to get a summary of all vendor batch payments at the line item level. I can get it at an individual level but not at a summarized level.

What I have been doing to get the individual split is going into 'Bank Transactions', finding my batch total, clicking into the batch, clicking 'Original document', and then clicking 'View Details'. I want the information contained at this point for all batches in one screen but having no luck so far.

Is this possible?

I have the same question (0)

All responses (3)

Answers (0)

André Arnaud de Cal... 303,722 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Dawson,

Can you elaborate what information/columns you want to display and on what aggregation level is should display the data? The functions you used now is for tracing back the source of an individual voucher/document.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

I am looking for the line item level detail:

- vendor name

- currency

- amount in transaction currency

- date

I am looking for this information for all payments that are batched. I can easily get it at an individual batch level via the route I described above but i want the summary for all batches. I have found I can get it if I use the vendor posted payment journal report but the output is not easy to work with in excel. Plus I need to have the batch reference in advance and embed them into the query.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,722 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Dawson,

This is by default not supported. You can consider a customization for this.

Was this reply helpful? Yes No