cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Why does my inventory not sort by sku number? It goes from 1000 to 10000 then 2000 to 20000, then 3000 to 30000. Why does it not go 1000, 2000, 3000?

 
Solved
Best answer 08-20-2019

Accepted Solutions
Established Community Backer *

Re: Why does my inventory not sort by sku number? It goes from 1000 to 10000 then 2000 to 20000, then 3000 to 30000. Why does it not go 1000, 2000, 3000?

QuickBooks is picking up the first digit and sorting by that number.  Try adding a zero in the first place.  1000 should be 01000, 2000 then becomes 02000.

View solution in original post

Not applicable

Re: Why does my inventory not sort by sku number? It goes from 1000 to 10000 then 2000 to 20000, then 3000 to 30000. Why does it not go 1000, 2000, 3000?

Thank you for the information, but absolutely ridiculous that it doesn't look at the whole number. I now need to go and put a "0" in front of 500 sku's. 

View solution in original post

2 Comments
Established Community Backer *

Re: Why does my inventory not sort by sku number? It goes from 1000 to 10000 then 2000 to 20000, then 3000 to 30000. Why does it not go 1000, 2000, 3000?

QuickBooks is picking up the first digit and sorting by that number.  Try adding a zero in the first place.  1000 should be 01000, 2000 then becomes 02000.

View solution in original post

Not applicable

Re: Why does my inventory not sort by sku number? It goes from 1000 to 10000 then 2000 to 20000, then 3000 to 30000. Why does it not go 1000, 2000, 3000?

Thank you for the information, but absolutely ridiculous that it doesn't look at the whole number. I now need to go and put a "0" in front of 500 sku's. 

View solution in original post

Need to get in touch?

Contact us