AP Trended Spend by Vendor

Posted about 1 month ago by Matt Collins

M
Matt Collins
Un Answered

0 Votes

How can I generate a report that shows me spend each month by vendor (ideally by location ID AND vendor)

0 Votes


3 Comments

Sorted by
Gabriel Michaud

Gabriel Michaud posted 22 days ago Admin

Thanks Harry/Damien.


Matt, if you have a particular layout in mind, can you please share it here? We can create a working sample that you'd be able to use.

0 Votes

Damien Zwillinger

Damien Zwillinger posted 23 days ago Admin

Hi Matt

You could use our GL function indeed as mentioned by Harry, or create a SI.QUERY on object: APBILL with the relevant columns including an aggregated amount column (e.g. SUM(TotalEntered) ), then using an Excel Pivot table to plot the data by month.



0 Votes

H

Harry Lewis posted about 1 month ago Admin

I would think that, if you generate a list of expense account groups in which you are interested and then apply the Location and Vendor dimensions to the SI.TURNOVER function for each month, that should give you that information.


e.g.,

0 Votes

Login or Sign up to post a comment