Quote Numbers - sorting incorrectly

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
Contributing Cover User Tailchaser
5 Posts
Contributing Cover User
Contributing Cover User

5Posts

1Kudos

0Solutions

Solved: Go to Solution

Quote Numbers - sorting incorrectly

Hi, 

 

When selecting SALES ->QUOTES from the top tool bar menu the quotes are displayed in a incorrect and non-numerical order. 

 

When the QUOTES are sorted by selecting NUMBER in the column headings they are displayed in the following order ( please also see screen shots attached of the asending and decending sort order results)

QT1

QT10

QT11

etc etc until they reach 

QT19

and the next one is

QT2

QT21

etc etc 

 

Does everyone else see the same?

Is there a work around? 

Many thanks

 

 

MYOB QT Sort 1.JPG
MYOB QT Sort 2.JPG
4 REPLIES 4
MYOB Product Team Haydes
6,195 Posts
MYOB Product Team
Australia
MYOB Product Team

6,195Posts

1,027Kudos

0Solutions

Re: Quote Numbers - sorting incorrectly

Hi @Tailchaser

 

From my own testing, it works as expected for me. Here's some screenshots:

 

Descending Order:

temp.png

 

Ascending Order:

temp.png

 

 

I did have to create a few new quotes as I did use a different numbering scheme though seemed to work as I'd expect.

 

I was using Google Chrome as my browser, is this the same as yours?



Cheers,

Hayden (Ex-Moderator)
MYOB Product Team
Contributing Cover User Tailchaser
5 Posts
Contributing Cover User
Contributing Cover User

5Posts

1Kudos

0Solutions

Re: Quote Numbers - sorting incorrectly

Hi @Haydes

 

Thanks for your reply. 

 

The entries do appear to sort correctly in your screenshots.

 

I wonder if this could be because the data set is limited and does not contain the number sequences that may show the error. 

 

Is there anyway you could add the following Quote numbers examples and test again?

QT1

QT10

QT11

QT12

QT21

 

Many thanks for your assistance

 

MYOB Moderator Jake_N
1,419 Posts
MYOB Moderator
Australia
MYOB Moderator

1,419Posts

193Kudos

0Solutions

Accepted Solution Solved

Re: Quote Numbers - sorting incorrectly

Hi @Tailchaser,

 

I was able to replicate this sorting inconsistency. I could not find any previous documentation on it, however, I have passed this example and my replication to our team.

 

In the meantime are you willing to put a few 0s in front of any numbers? This seems like a viable workaround.

Untitled.png

Cheers,
Jake

MYOB Community Developer

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Contributing Cover User Tailchaser
5 Posts
Contributing Cover User
Contributing Cover User

5Posts

1Kudos

0Solutions

Re: Quote Numbers - sorting incorrectly

Hi Jake, 

 

Thank you.

 

Yes, I have added a few 0's and it is now working as expected. 

 

Many thanks for your assistance. 

 

 

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post