# Payments by Vendor (not account) by period (not AP balance)

**URL:** <https://community.velixo.com/t/payments-by-vendor-not-account-by-period-not-ap-balance/155>\
**Category:** Q&A\
**Tags:** Acumatica\
**Created:** [September 21, 2026, 12:23am UTC](https://community.velixo.com/t/payments-by-vendor-not-account-by-period-not-ap-balance/155 "2026-09-21T00:23:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matthew\_jackson](https://community.velixo.com/letter_avatar_proxy/v4/letter/m/bb73d2/32.png) [@Matthew\_jackson](https://community.velixo.com/u/Matthew_jackson)\
**Post date:** [September 21, 2026, 12:23am UTC](https://community.velixo.com/t/payments-by-vendor-not-account-by-period-not-ap-balance/155/1 "2026-09-21T00:23:39Z")

</div>

I want to be able to summarise payments by vendor for a period. I can find a report for AP balance at a date, and another report that lists all vendors ever used (without values). I have looked in teh templates and on the youtube channel but can’t find a functionality that provides a code for value for period for client (not account). Does one exist?

---

<div class="post-metadata">

**Author:** ![Damien](https://community.velixo.com/user_avatar/community.velixo.com/damien/32/196_2.png) [@Damien](https://community.velixo.com/u/Damien)\
**Post date:** [September 21, 2026, 1:42am UTC](https://community.velixo.com/t/payments-by-vendor-not-account-by-period-not-ap-balance/155/2 "2026-09-21T01:42:57Z")

</div>

Hi Matthew

There was no report pre-built for this one, but I managed to easily create one using Velixo Intelligence and a simple instruction: “Create an actual payment transaction report, by vendor, payment date and period”. I was then able to edit the query and add/remove the columns required, using Query Builder (right click the top left cell of the query \> Velixo \> Query Builder).

You could also directly create this query using the Query Builder (Insert button \> Query), search for “AP Payment”, then select columns and adding filters.

Attaching the file and adding a screenshot below. Hope this helps.

 ![](https://community.velixo.com/uploads/default/original/1X/423d4cf5b5c2568d9b86f7ad6152048aea83182c.png)

[ActualPaymentsByPeriodByVendor.xlsx](https://community.velixo.com/uploads/short-url/cj4uNkpuwKOm5OsJtKv1JFU0SiJ.xlsx) (39 KB)

---

<div class="post-metadata">

**Author:** ![Matthew\_jackson](https://community.velixo.com/letter_avatar_proxy/v4/letter/m/bb73d2/32.png) [@Matthew\_jackson](https://community.velixo.com/u/Matthew_jackson)\
**Post date:** [September 21, 2026, 2:11am UTC](https://community.velixo.com/t/payments-by-vendor-not-account-by-period-not-ap-balance/155/3 "2026-09-21T02:11:35Z")

</div>

Thanks Damien - with that data I will be able to build a Pivot Table to extract the required data.