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

The 'Run Report' for an inventory item does not display what is on order. This is a big oversight in Quickbooks Online. How can I easily find out what is on order?

Quickbooks Desktop gives this information simply by selecting 'QuickReport' for an item. That shows what was on ordered, and what was billed (ie, received). QBO does not report this out, even if you try to create a custom report (this data is not avaialable). Pretty frustrating. Hoping someone has a workaround.
4 Comments 4
giobookkeeping
Level 3

The 'Run Report' for an inventory item does not display what is on order. This is a big oversight in Quickbooks Online. How can I easily find out what is on order?

@bob207 I think the closest way to get this report is to run the Transaction List with Splits report and filter it to display "Accounts Payable". This would show your Purchase Order and Bills transactions. 


This may not be the most ideal workaround for this. I'd be happy to see what the other folks here have. :-)

Archie_B
QuickBooks Team

The 'Run Report' for an inventory item does not display what is on order. This is a big oversight in Quickbooks Online. How can I easily find out what is on order?

Thank you for reaching us, bob207.

 

The features in QuickBooks Desktop are different in QuickBooks Online. QuickBooks Desktop is more advanced when it comes to reporting capabilities, whereas QuickBooks Online provides more accessibility and is more mobile-friendly.

 

As a workaround, you can use the transaction list report mentioned by @giobookkeeping, and personalize it to get the right data you needed.

 

Like this:

 

  1. Go to Business overview and select Reports.
  2. Select and open a Transactions list report.
  3. Then, click on Customize button.

 

You can check out this article for more details: Customize reports in QuickBooks Online.

 

I've also added this link that you can use as a reference: Understand reports.

 

Let us know if you still have other concerns or any follow-up questions about reports. I'll be here to help. Have a great day!

bob207
Level 1

The 'Run Report' for an inventory item does not display what is on order. This is a big oversight in Quickbooks Online. How can I easily find out what is on order?

Thanks for the helpful suggestion.   I gave it a try and was able to see the purchase order transactions and the individual items on them.   Unfortunately, it would take a lot of time to try and find a particular item on a PO (we have about 300 line items on an average PO), across multiple POs over the past months.   Makes for a lot of manual effort and time to come up with what has been ordered and fulfilled for a particular item.  

 

DivinaMercy_N
Moderator

The 'Run Report' for an inventory item does not display what is on order. This is a big oversight in Quickbooks Online. How can I easily find out what is on order?

Thanks for sharing an update, @bob207.

 

I know how beneficial it is to run the report that will provide you with the exact details you need. Since the specific report to display what inventory item is on order is currently unavailable in QuickBooks Online (QBO), I'd recommend sending feedback to our Product Development team. 

 

Here's how:

 

  1. In your QBO account, click the Help menu.
  2. Next, choose Feedback.
  3. Then, enter a brief description of your product suggestion.
  4. Once done, select Next to submit.

 

Rest assured that they are bound to improve the features in the program to meet your business needs. Also, you can visit the QuickBooks Online Feature Requests website to track the feedback you've submitted. 

 

In the meantime, you can perform the suggested workaround by, giobookkeeping so you'll be able to see items in the purchase order transactions. Then, to further customize the data of the report, you can export it to excel and modify it from there. 

 

I've also got you here a compilation of QuickBooks How-to videos that can further assist you in navigating your QBO account.

 

I'm just around the corner if you need additional help in running item reports in QBO. Feel free to leave a reply below and I'll circle back to assist you. Take care always and have a good one. 

Need to get in touch?

Contact us