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"
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.
Go to the Reports menu.
Select Report Center.
Search for the Purchase by Vendor Detail report.
Press the Customize Report button.
Move to the Filter tab.
Type in Name, then choose your preferred vendor.
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.