Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
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. 

Need to get in touch?

Contact us