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

BACK ORDER AND SALES ORDER REPORTS

I am using Premier 2019 retail for a retail business where we use sales orders for every transaction.  Our process is simple - we enter the order via sales order and convert it to an invoice when it the item comes in and we ship it out.  Most items are ordered in to fill or orders (we don't carry much stock).  

I am struggling to find a useful report that shows me what items are on sales order but not currently on purchase order or in stock, sorted my supplier.  I am guessing that this exist because many businesses would have this issue and would like a report that shows them what items need to be ordered to fill sales orders.

I look forward to any suggestions.

 

5 Comments 5
Rose-A
Moderator

BACK ORDER AND SALES ORDER REPORTS

I'd be happy to assist you today, Ted Kennedy.

Let me lend a helping hand in finding a report that contains the information you need in QuickBooks Desktop.

 

You may want to run the Inventory Stock Status by Item report. This report shows the following information about each item in your inventory: reorder point, item description, and quantity on hand, preferred vendor, quantity on order, average sales per week and receipt date.

 

Here's how:

 

  1. Click Reports at the top menu bar.
  2. On the drop-down list, click Inventory and select Inventory Stock Status by Item.

See screenshots below.

 

You may find these articles helpful:

 

I wish you continued success with your business. Please let me know if you have any other questions about back order and sales order in QuickBooks Desktop.

 

StatMedicalInc
Level 1

BACK ORDER AND SALES ORDER REPORTS

Thank you for your assistance with this.  This is a good report but would be better if you could filter out only the ones that require ordering.  

It won't work for us though because we do custom orders using the sales order to enter the order, however, we do not order the goods until the paper work is complete.  Our system is likely a little too complex to use QB reports.  We also us Sales Orders as a way of tracking items that we send out on trial to our customers so the invoicing is not affected.  These two things make the report described insufficient for our applications so we will continue to manage our required items for purchase on smartsheet outside of the program.

Thank you for the answer!

 

JanyRoseB
QuickBooks Team

BACK ORDER AND SALES ORDER REPORTS

Thanks for getting back to us, StatMedicalInc.

 

Allow me to help provide other option on how you can pull up the report you need in QuickBooks Desktop. 

 

You may consider the Advanced Reporting feature in QuickBooks Desktop Enterprise version, where you can use your QuickBooks data to create interactive reports and gain better insights into your business. 

 

To learn more about Advanced Reporting, please check these articles:

If you need further assistance from out phone support, you can contact them by following these steps below:

  1. Follow the Official Intuit Contact link.
  2. Select your QuickBooks product.
  3. Select an issue type from the menu below, you need only to select two options for the contact information to appear.
  4. Click Get Phone Number at the bottom.

Please know that I'm just a post away if you have any other questions about the Advanced Reporting. Have a good one. 

TonyG1
Level 2

BACK ORDER AND SALES ORDER REPORTS

I am also looking for a Sales Order back order report, not an inventory report. Just want to know which Sales orders have one or more back ordered line items. Thanks, Tony 

HoneyLynn_G
QuickBooks Team

BACK ORDER AND SALES ORDER REPORTS

Thanks for looping in, @TonyG1.

 

You can run and customize the Open Sales Orders by Item report. This has a specific column that gives you the backorder details:

  1. Go to the Reports menu and choose Sales.
  2. Select Open Sales Orders by Item.
    1.PNG
  3. Customize the date period, then click Refresh.
    2.PNG

My colleague already provided these articles, but I'll add it again so you don't have to search for it:

That should help you get the information you need, @TonyG1. Let me know how it goes or if you have other reporting concerns. I'm still here to help you more.

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

Need to get in touch?

Contact us