50 transaction paging limit

Hello,

Would you be able to make a change to the number of results displayed in areas such as viewing clients and invoices please? At the moment the upper limit is 50 and something more like 100 or 200 would be ideal for us.

Thanks

Heather

1 Like

Hi @zappdance

I’ve merged your post here to keep the topic in one place.

Please see the post above from @Glenn regarding the limit.

Hi,
i also understand the server impact, but we are all paying for this service now, and i am so regularly having to merge data exports which takes time, and frustrating.
exporting all purchases to analyse externally,
exporting all orders by customer to analyse problems or customer income

If the default is left to 50, but ability to export all in filter would be fantastic

Hi @jpitsolutions

Have you used the backup tool at all? This would give you a complete export of your account rather than a 50 item limit. There’s more details in a post above from @Parker1090.

Hello in order to bulk pay more than 50 invoices at a time it would be great if you increased the number of transactions a page can display. 50 is not enough when we are bulk entering lots of purchases. Creating multiple transactions makes following the money less obvious.

1 Like

Hi @Gavin_Smith

I’ve merged your post with the existing feature request so we can track the interest here easier.

I agree with gino, it seems that we only need more on occasion, so the default limit could be 50 or less, but with the exception that paid users can access 100 or more.

Again to prevent resource limitations this could then default back to 50.

We have staff expenses that often end up with over 50 invoices. When this is paid we then have to split the payment as we can only bulk tag 50. This makes the system clunky to use.

2 Likes

Hi
I too would like to be able to view all clients for each letter of the alphabet on one page, it’s quite anoying and time consuming to only see 50.
Thanks
CliveClive

1 Like

We often see more than 50 invoices a month from a single supplier. So being able to select or see more than 50 would be useful.

Could it be done on demand similar to applying a payment to more then one invoice in the bank tagging, where more invoices are shown by clicking on “Show more outstanding invoices?” button?

So only 50 would be shown by default. However on clicking a show more button the next 50 are added to the list. I doubt anyone would mind if the next 50 took a while to load after clicking the button.

Hi, I have been exploring the QuickFile Api free service and created a HTTP Client_Search request. I have noticed that there is a limit of 9 records in the body; the body of the response contains only 9 clients records. The Recordset count on the body of the response, named “Client_Search”, shows up many more records present on my QuickFile account. Is there any limit correlated to your database load availability, like you have mentioned above, also in the Quickfile Api service? Is it possible to receive a HTTP response with more records and if yes it is a free service or do you have to pay to customize it? Does Quickfile include scalability in its Api service?

What value are you passing for the ReturnCount parameter?

Thank you for replying so quickly Ian, It was set to 10, I have tried to set it to 500 and it didn’t process the request, could you please guide me through the max limit that I can set now as default and the max limit we could potentially achieve with a paying subscription?

There’s no theoretical limit to the number of records you can retrieve in total - you just have to use a combination of ReturnCount and Offset in multiple calls to retrieve a “page” at a time.

Start off with an initial call with a sensible ReturnCount of say 50. The response will include its own ReturnCount saying how many entries were actually returned in the current page (which may be fewer than you asked for) and RecordsetCount giving the total overall number, from that you can then work out whether you’ve got them all or whether you need to go back and ask for more. To get a second or subsequent page you call again with the same search options but add Offset set to the total number of records you have retrieved so far, keeping a running total of the ReturnCount from successive calls. Once your running total reaches RecordsetCount then you know you’ve got everything.

Remember that you need to use a different submission number (and recalculate the md5 value) for each call - I typically do it by starting with a number representing the current time in milliseconds (System.currentTimeMillis() in java) and add an incrementing suffix for each call; that is guaranteed to be unique as long as you don’t start two sequences of calls at the same moment.

Thank you very much Ian, it worked and can be solved with a routine that checks ReturnCount and RecordsetCount and sets Offset.
I hope that at some point QuickFile will improve the api response with a nice stream system such as psr 7 in php or node js.
All the best
Andrea

I agree with @Glenn, when looking at other formats of viewing transactions i.e. Gmail there is a limit of 50 emails to view at anyone time.

As the poster said, we could have it on a per manual baasis. So it is never the default. Only occurs when selected for one-time.

What about allowing a 250 limit by selection only? I mean, if my paging selection is 250, then is will default back to 50 next time, rather than making this the standard.

We are now trialing a 100 and 150 page limit within the bank statement view. This option will be available to all power users and is non-persisting, so you can set the size when, paging and filtering, but it will default back to 50 when you navigate away from the bank statement page and then return.

You can export upto 150 items, although bulk deletion and tagging is still limited to 50 items at a time. We’re also looking into the feasibility of lifting this limit.

3 Likes

Hi Glenn, First of all, I wish you and your team all the best for the new year. And I also would like say thank you for sharing the good news about the new increased page limit, it is very appreciated :smile:

2 Likes

You’re welcome… Happy New Year

This topic was automatically closed after 4 days. New replies are no longer allowed.