supplier list showing annual spends

  • 1
  • Question
  • Updated 10 months ago
  • Answered
Trying to run this report, but it prints blank.
Go to Reports > Purchases > Purchases by Supplier summary.
Would anyone know why?
I need to be able to give management a report showing our most common suppliers with the annual spends.
Photo of Nadine

Nadine

  • 908 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
Hi there - this report only refers to purchases of items - so if you enter bills and allocate amounts direct to an account in the General Ledger (chart of accounts) then this wont show in this report - this report is only relevant if you purchase actual items on the items tab of the Bill... hopefully this makes sense and answers your question?

In order to achieve the report you want you will need to create a Custom Summary Report - you can use Display Columns by Total (or month, qtr, etc) and then Display rows by Supplier - and go to the Fonts & Numbers tab and choose to use a trailing minus... this should give you what you want? Cheers Linda
Photo of Nadine

Nadine

  • 908 Points 500 badge 2x thumb
Hi Linda
Thank you so much for your help with this. I was able to create exactly what I needed, although I feel it is a shame the report can not be generated without the minus symbol altogether. 
Thanks, Nadine
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
No worries Nadine - I agree it would be good to remove it altogether - putting it at the end is the best we can do... in a ledger reporting sense credit entries are positive and debit entries are negative...  Cheers Linda
Photo of Nadine

Nadine

  • 908 Points 500 badge 2x thumb
Hi Linda

I am trying to run this report again, and for some reason this time it is only giving me the account balance at the end of the period, i.e. running the report from July 17 to Jan 18 and the totals showing on the report are the balance for each supplier at the end of January. Do you know why this would be or what I could be doing wrong?