Need report to show POs which have been paid for but not fully received

MTRE · ‎April 29, 2022

I need help finding or creating a report in quickbooks Enterprise. I'm specifically looking for a report which will show me any POs with goods which have been paid for but not received. I'm looking for this for two reasons:

1) On occasion, our warehouse employees physically receive goods but forget to receive the PO in quickbooks. At that point we have items which have been paid for sitting in our warehouse but they are not in inventory so we can't sell them.

2) On occasion, a manufacturer will short an order even though all items have been paid for.

In both of these cases, I need to track POs with items which have been paid for but not received. Ideally, I'd like a time component. If I paid for a PO yesterday and it has not been received, this is normal. If I paid for a PO 4 months ago (or more) and items have not been received, I'd like a way to know about this.

In the last week, I stumbled across two POs, which were paid in full over 4 months ago, with unreceived items on those POs. I'd like to run a monthly report to alert me of this but I can't find any such report. It may be there and I'm missing it? Any help would be appreciated. Thank you!

CharleneMae_F · ‎April 29, 2022

Hello there, MTRE.

Running a report that shows the paid items but not fully received is a great functionality. As of now, this option is unavailable in QuickBooks Desktop. I'd recommend sending a feature request directly to our Product Development team. This helps us improve your experience and the features of the program.

Here's how:

Go to the Help menu and then select Send Feedback Online.
Choose Product Suggestion.
Add the type of feedback.
Type in your feature suggestion.
Once done, click Send Feedback.

To learn more about the available reports in QuickBooks Desktop, I'd suggest checking out this article: Understand Reports.

Additionally, I've included these articles that'll help you run and personalize ready-made vendor and item reports. This way, you can ensure your record is accurate:

I'm only a few clicks away if you need assistance in managing your reports in QuickBooks. It's always my pleasure to help you out.

MTRE · ‎May 01, 2022

Thanks for the reply. I did fill this out but I have a feeling it will happen 3 years from now or never. I need a solution now. What about a custom report? Can a report be written using the API or the Advanced reporting tool with quickbooks enterprise?

Archie_B · ‎May 01, 2022

Thank you for getting back to us, MTRE.

We do have a separate team who can surely share with you some ideas about third-party integration and other API concerns. You can visit the Intuit Developers Team website through this link: https://developer.intuit.com/app/developer/homepage

You can check this article to learn more about the Advance reporting feature in QuickBooks Desktop Enterprise: QuickBooks Advanced Reporting (QBAR) FAQ.

I've also added our QuickBooks Help page for more helpful articles and reference.

You can leave some follow-up questions or other concerns about reports in QuickBooks Desktop. I'll be around if you need help. Take care!

Topics

Training

Community

Resources

Need report to show POs which have been paid for but not fully received