Chronological Sort (Invoices)

Hi, when we try sort invoice order chronologically using the “sort button”, invoices seem to be all over the place, we are on invoice number 10028 and cant seem to get to get the system to do it correctly is this something you guys could look at?

Thanks S.

Which column are you sorting by? Issue Date and invoice number may not necessarily align, as invoice numbers are allocated in order of when you enter the invoice into the system not by reference to the issue date.

Hi Glenn,

Im trying to sort invoice number column, i exported to excel which then i can sort in chronological invoice number order, just cant do it in the system.

There’s quite a few accounts under your name, will send you a PM to get the precise one.

The order by rule is working alphabetically rather than numerically. This is a standard behavior as some accounts include letters in their invoice range.

If you order by invoice number descending it will look something like this.

9999
9998
9997
.....
10054
10053
10052
etc

The first character 9 is above 1 even though the complete number 10054 is higher than 9999. There is a logical reason but I understand it’s a little counter-intuitive. The same happens when you order files in a folder on your computer, it will order alphabetically not numerically.

I have an idea but I’d need to discuss this with our development team. I can’t promise to have a solution in place imminently but we will look at some options.

EDIT:

I though we could maybe order by entry date, this would normally correspond to the invoice number sequence, but that isn’t happening on your account. Have you manually changed the invoice numbers when saving?

Thats correct due to a swap over of systems, manual invoice numbers needed to be input to the QF system from the old system

I think we have a solution but it may be a few days before it’s tested and deployed. Will update you.

Thanks Glenn much appreciated

Check now… We managed to get this pushed out a bit earlier, seems to work much better with the invoice number ordering now.

Perfect thanks…!! quick responses and actions like this keeps QF miles ahead of its overpriced competitors, keep up the good work.

1 Like