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

Locating Item Receipts without Bill and Bills without Receipts in Enhanced Inventory

We are using Desktop Enterprise with Enhanced Inventory. We receive against PO's (sometimes partial), and later apply the vendor bill to the same PO.  Occasionally we will receive a bill for unreceived items, and other times items are received that do not appear on a vendor bill.  Is there a "Tool" or "Report" that would help us quickly locate these unresolved issues with inventory?  For example, the PO screen has columns that display Qty Received and Qty on Bill.  Basically, whenever these amounts are not in balance either way, we are looking for a report or tool that selects all such transactions.  Something like "Fix Items Received without a Bill" or "Fix Items Billed without Being Received"

1 Comment
QuickBooks Team

Locating Item Receipts without Bill and Bills without Receipts in Enhanced Inventory

Hi @petern142,

 

I'll handle this query for you about handling purchase orders (POs) in QuickBooks Desktop Enterprise. 

 

Although there isn't a specific tool or a single report you can run to fix the situation you stated, I can suggest two reports. The Purchase by Vendor Detail and Open Purchase Order reports. You can export and combine these reports into Excel. You can use this to determine items received without a bill, and those items received that aren't listed on the PO. 

 

Here's how:

 

  1. Go to the Reports menu.
  2. Select Report Center.
  3. Search for the Purchase by Vendor Detail report.
  4. Press the Customize Report button.
  5. Move to the Filter tab.
  6. Type in Name, then choose your preferred vendor. 
  7. Hit OK.
  8. From the Excel drop-down menu, tap Create new worksheet.

You can the Open Purchase Order report at this time. You can either leave it on QuickBooks Desktop and compare the information you have on the Excel file create above, or import them to a different worksheet and compare them that way. 

 

I'll share this article as well: Use the purchase order management worksheet. It allows you to identify which PO is being received, and then send it to the QuickBooks Desktop Warehouse app. 

 

Drop me a comment below if you have other questions. I'll get back to you. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us