Purchase order items with item receipt and bill details

I completely understand your frustration. To see all of the line-item details by PO and details for the applied Item Receipts/Bills. We can pull the Open Purchase Orders Detail and do a PO Matching Report. Go to Reports, click Purchases, then select Open Purchase Orders Detail. Click Customize Report at the top left.

On the Display tab, check the boxes for the exact columns you asked for: Item, Description, Num (PO #), Qty, U/M, Rate, Amount and Type(this brings in the matching Bill/Receipt details).

After that, go to the Filters tab, search for Customer, and select your specific Customer name filter. Search for Received Stat set it to Yes (so you can see both open and closed portions to find the errors). Click OK.

The reason your open items are greater than the open balance is a classic QuickBooks quirk: someone likely entered a Bill or Item Receipt manually instead of using the Receive against PO button. QuickBooks doesn't know they match, leaving the PO open and creating a data mismatch.

If a single standard report cannot display all PO lines, item receipts, and linked bills with the exact line-level details you requested. You will need to use the Custom Transaction Detail Report and export it to Excel to match and build the complete lineage.

Please don't hesitate to leave a post below if you still need further assistance.

We are in Quickbooks Enterprise Solutions 24.0 and this option is not available. Is there another way? 

We are using Quickbooks Enterprise Solution 24 for Construction and this is not an option. Is there another way? I am okay with manually merging reports using excel. Not ideal, but will do it.

There is no built-in option in QuickBooks Desktop (QBDT) to show this data because the program treats purchase orders and bills as separate transaction types, preventing them from linking line-by-line in native reports.

For now, the workaround that you had in mind about merging your exported reports together using Excel is your best option to track down those data entry errors.

Feel free to click the Reply button if you have other questions or concerns.

I have yet to find a Receipt/Invoice report that presents a PO number to do the export and then match with.

I even attempted an Advanced Reporting build to join tables to no avail.

Do you have any guidance here?

Do you mean a Receipt/Bills report that presents a PO number? You can run a Transaction List by Vendor report and apply filters to display only Item Receipt, Bills, and Purchase Orders.

To do this, head over to Reports > Vendors & Payables > Transaction List by Vendor. From there, click the Customize Report button and go to Filters. Search for Transaction Type and from the dropdown, select Item Receipt, Bills, and Purchase Orders, then hit OK.

Additionally, in the Display tab, make sure the Num column is checked. This will display the transaction numbers, including the PO numbers. Once everything is set, click OK.

Feel free to select the Reply button if you have additional questions.

This still has not been resolved.