supplier list showing annual spends
Options
Nadine
Member Posts: 52 ✭
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.
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.
0
Comments
-
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 Linda2 -
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, Nadine1 -
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 Linda0
-
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?0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community