Customer and Supplier Turnover Reports - Net of VAT

[QFMathew]

@jamespbmatt2

To recreate the error:

Purchases > View Suppliers

Advanced Search [Check box ‘Total Invoiced’], [Enter Date Range]

Ok so far. Results as expected.

[Check the box next to Supplier Name heading to select all] Results as expected

[Deselect select all check box] Results as expected

[Select select all checkbox] Nothing selected. BUG 1

Thanks! I’ve replicated this and have logged it with our development team for review.

@jamespbmatt2

The auditors want a list of our biggest suppliers. This means downloading the full list of suppliers. It is a bad user experience to have to download as many reports as you have pages of results and then glue them together in Excel.

This isn’t something that’s likely to change at the moment. As I mentioned above, the limit of 50 to a page is put in place to preserve resources.

My colleague explains it better in several threads on the forums, including this one.

@jamespbmatt2

There is no net versus gross toggle in the view I am looking at. Gross of VAT is almost irrelevant to most accountants as you can claim it back. To answer the question from the auditors I would have to sort through US, EU and UK suppliers, work out which ones are charging UK VAT and then make some sort of manual adjustment. Bad user experience.

Apologies - that’s my error. There isn’t a net/gross column toggle on the supplier list, only on the invoice list. I will however raise this with our team on Monday and come back to you on this one.

@jamespbmatt2

Another issue is that the ‘from XX to YY’ timeframe setting doesn’t work. The balances shown are for all time.

I wasn’t able to replicate this one unfortunately. I have a supplier with invoices in December 2017 and in February 2018. I tried a search from 01/01/2018 to 10/03/2018, and this worked as expected. If you could supply a few more details, I’ll happily look into this further for you.