How to sort estimates by estimate number?

Sorting the numbers in an estimate in descending order depends on a number of factors, including the system being used and the way the numbers are entered, @signage. Different software systems use distinct methods to organize and sort data, and this includes QuickBooks Online (QBO). In QBO, the default sorting method is based on how the numbers are entered and formatted, which can sometimes lead to unexpected or unintended sorting results.

For example, when dealing with estimates that include numbers like "2510-1011.6" and "2510-1019," you might notice that "2510-1011.6" appears before "2510-1019" even though it might seem logical for "2510-1019" to come first when sorting in descending order. This happens because of the decimal values present in "2510-1011.6," which the system interprets as part of the number. In QBO, sorting takes the entire format of the input into account, including decimal points and other characters, rather than strictly comparing numeric value. This is the default behavior of the sorting algorithm, which may cause some confusion if you're expecting a purely numerical order.

To achieve a more accurate descending order sorting in your estimates, one effective workaround is to remove any decimal values from the number fields before sorting. By entering whole numbers or consistent number formats without decimals, QuickBooks Online will be able to sort your estimates more precisely in descending order, reflecting the logical numerical sequence you expect.

If you have any further questions or need additional clarification about sorting numbers, estimates, or any other QuickBooks Online procedures, please feel free to click the Reply button below and leave a comment with your inquiry, Signage. We highly value your feedback and are always here to help ensure that our product works as smoothly and efficiently as possible for you