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?
0 Votes
2 Comments
Sorted by
M
Matthew. jacksonposted
about 9 hours ago
Thanks Damien - with that data I will be able to build a Pivot Table to extract the required data.
0 Votes
Damien Zwillingerposted
about 9 hours ago
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.
0 Votes
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?
0 Votes
2 Comments
Matthew. jackson posted about 9 hours ago
Thanks Damien - with that data I will be able to build a Pivot Table to extract the required data.
0 Votes
Damien Zwillinger posted about 9 hours ago
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.
Attachments (1)
ActualPaymentsByPeriodByVendor.xlsx
39.4 KB
0 Votes
Login or Sign up to post a comment