cancel
Showing results for 
Search instead for 
Did you mean: 
mmgd
Level 2

Item list order on reports

I have recently made changes to items in our item list.  We created some "title items" and added subitems to them.  When I view my item list on the desktop it is in order.  However any report I run for these they are not in order.  Most importantly is my Job Cost Detail, I have customized the report to total by item detail instead of by customer.  But the item order is all jumbled  up.  

 

Solved
Best answer August 26, 2020

Best Answers
ReyJohn_D
Moderator

Item list order on reports

You can re-sort your item lists, @mmgd.

 

It will make your lists go back to their default order and will undo the changes made to them. This way, you'll see the correct arrangements in your Job Cost Detail report.

 

Before doing so, ensure you're on single-user mode. Here's how to verify it:

 

  1. Go to the File menu.
  2. Check to see if the option says Switch to Multi-User Mode. If not, click it to switch to single-user mode.

Once ready, here's how to proceed:

 

  1. Go to the Lists menu, and then select Item Lists.
  2. Tick the Include Inactive checkbox. If it's grayed out, there are no inactive names.
  3. Tap the Name  drop-down, and then pick the Re-sort List option.
  4. Hit OK to confirm the action, and then close and reopen your company file.

    C900.PNG

Please browse this article for more info: How to re-sort lists.

 

You may edit your item lists to keep your records up-to-date. Also, after customizing your report, you'll want to memorize them for easy access.

 

Leave a comment below if you have more QuickBooks concerns. Take care and have a great day.

View solution in original post

4 Comments 4
ReyJohn_D
Moderator

Item list order on reports

You can re-sort your item lists, @mmgd.

 

It will make your lists go back to their default order and will undo the changes made to them. This way, you'll see the correct arrangements in your Job Cost Detail report.

 

Before doing so, ensure you're on single-user mode. Here's how to verify it:

 

  1. Go to the File menu.
  2. Check to see if the option says Switch to Multi-User Mode. If not, click it to switch to single-user mode.

Once ready, here's how to proceed:

 

  1. Go to the Lists menu, and then select Item Lists.
  2. Tick the Include Inactive checkbox. If it's grayed out, there are no inactive names.
  3. Tap the Name  drop-down, and then pick the Re-sort List option.
  4. Hit OK to confirm the action, and then close and reopen your company file.

    C900.PNG

Please browse this article for more info: How to re-sort lists.

 

You may edit your item lists to keep your records up-to-date. Also, after customizing your report, you'll want to memorize them for easy access.

 

Leave a comment below if you have more QuickBooks concerns. Take care and have a great day.

mmgd
Level 2

Item list order on reports

Thank you, I didn't think resorting the list was the issue because it was in "order" when I opened the Items & Services icon.  But it did fix it. 

 

DD2010
Level 2

Item list order on reports

Thank you so much for your post!  All this time I couldn't figure out where to put the list in order.

I don't know why Quickbooks can't program it to be in Numerical or Alphabetical order automatically when we make changes to the list.  Thank you again!

DD2010
Level 2

Item list order on reports

Thank you for posting your question and got it answered.  I had the same issue with the Items being out of order when I ran my reports... but it's fixed now...Thanks!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us