cancel
Showing results for 
Search instead for 
Did you mean: 
DebElle
Level 1

Numbering rows

After switching from QBO to QBD, I'm frustrated that I can't get simple numbers. If I want to see how many orders came in on a given day, I have to count by hand. I tried creating a report and looked to see if there was an option to number the rows, but nothing. It's such a small thing.

QBO had a filter option for All Sales, where I could see the order on any given day, and it automatically counted. Any help?

5 Comments 5
MichelleBh
Moderator

Numbering rows

This is not the experience I want you to feel, @DebElle.

 

I want to ensure that you can run a report with the total orders in QuickBooks Desktop. This way, you don't need to count the numbers manually.

 

Let's pull up the Sales by Item Detail report or Open Sales Order by Item, then customize it. These reports contain various information like Quantity, Backorder, Purchase date, Num, Type, etc. 

 

Here's how: 

 

  1. Go to the Reports menu at the top. 
  2. Choose Sales, then pick either of the report mentioned above. 
  3. Hit the Customize report button on the left side. 
  4. In the Display tab, select a report date range, report basis, etc. 
  5. Tap OK

 

See the sample screenshots below for your reference: 

 

 

You can also click the Memorize button beside the Print button. This will help you save time since it automatically updates every time there are newly added transactions. For more information, visit this article: Understand reports.

 

Additionally, please browse these pages about managing customer's transactions, payments, sales forms, and other related matters. 

 

 

Let me know in the comment section if you other questions in accessing reports. I'm glad to help. Keep safe!

DebElle
Level 1

Numbering rows

I've been down this road before, searching in the different "Sales By" options. It gives me a total of the product or service. But if I processed 10 orders in a single day, and each customer ordered 10 items, I would see 100 as the total; I want to see the number 10 because that shows me how many orders actually came in. Can I not do that?

JasroV
QuickBooks Team

Numbering rows

Thanks for getting back to us, @DebElle.

 

The Sales by Item Detail reports show you each item you sell to your customer and the break down by transactions. If you only have 10 items that came in, it’ll base on how much quantity you entered. Thus, it shows the total of items per transaction.

 

I’ve added a screenshot below for your visual reference. 1.JPG

 

As a workaround, you can export the report and adjust the total base on your preference. Click the Excel drop-down menu and from the top menu of the report and select Create New Worksheet. You can also check this article for more details: Export reports as Excel workbooks in QuickBooks Desktop.

 

You might also want to check this article for reference in tracking your inventory efficiently in QuickBooks Desktop (QBDT): Set up Advanced Inventory.

 

Let me know if you have other concerns or questions about tracking your inventories or with your account, you’re always welcome to post a reply. I’ll be around to help you. Keep safe! 

DebElle
Level 1

Numbering rows

Thanks for your reply but that wasn't really what I was asking. I was using that as an example. I don't want to see how many items I sold. I just want to see how many sales orders came in on a given day. If I had 95 orders placed yesterday, where do I see that number 95?

Nick_M
QuickBooks Team

Numbering rows

Hey there, DebElle. 

 

Thanks for dropping by the Community and clarifying. I'm happy to assist you today. What you'll want to check out is our Sales Order fulfillment worksheet. Note: This is exclusive to QuickBooks Desktop Enterprise. If you don't have Enterprise, you can check out this page about upgrading if this is necessity for your business. If you have Enterprise already, you can find information on this worksheet in this article. The steps included, to run the worksheet are as follows:

  1. From the QuickBooks Edit menu, select Preferences.
  2. On the left pane, select Items & Inventory then Company Preferences tab.
  3. Select the Advanced Inventory Settings button.
  4. Go to the Site Operations tab and check the Sales Order Fulfillment Worksheet box.

After setting your preferences, you can start managing and fulfilling your sales order by selecting the Customers menu then Sales Order Fulfillment Worksheet.

 

If there's anything else I can do to help, feel free to stop by the Community at anytime. Thanks again and I hope you have a nice day.

Need to get in touch?

Contact us