How to print a report that give you the total spend by vendor

I am trying to print a report that shows what we have paid (total spend) to each vendor by year. I know this information pulls if it is a 1099 vendor but how to I get these details for my vendors that I purchase all of my inventory from that do not require a 1099? I have tried and tried to put something together and export to excel but all the reports I have found zero out the totals. I am running out of ideas, please help! 

  • 0

    A report of this type can be produced using Crystal Reports or the new report writing platform called XLGL. We can assist with such a report if you are interested in professional assistance.

  • 0

    If you are interested in a simple report that shows you dollars only, then change your Accounting Period to the last period of your fiscal year, i.e. Period 12, and then run the Vendor List Report from the Accounts Payable Reports Menu. Using the Columns icon at the top of the report screen, add the columns for Payments for each of the 12 months of your Fiscal Year. You can then export this report to Excel, and total the 12 columns, or do any other sorting that you may need. https://pcosupport.com 800-780-0700 954-961-0600