Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
At a high level, I would like to have a report that shows me if we received goods from a vendor on time.
I have searched and configured reports in QB Enterprise21 (we use enhanced/advanced inventory) but have not been able to do this.. In QB, the PO has a PO# and DueDate. The Item receipt has a date and it shows the PO#. If I were able to export these two pieces of information into a spreadsheet, I would be able to compare them. I am unable to create a report that has item receipts that shows the PO#. Any help is appreciated.
I have a report in mind, AllanUser.
We can run and customize the Purchases by Vendor Detail report. This will show the item receipts and the P.O.#. I'll show you how.
This is what it looks like:
I've also added an article that you can read to help personalize the expense and accounts payable-related reports: Customize vendor reports. This way, it will be easier for you to find the information that you need.
Once you pull up the correct data, you can memorize it in QuickBooks. By doing so, you can easily access the current customized settings.
I'm still here if you have other questions with regards to running the correct reports in QuickBooks. It's always my pleasure to help in any way I can.
Dear CharleneMae_F,
First, thank you for taking the time to respond (especially with screenshots). The issue is that the "P.O.#" Column is blank for every line.
If you have any additional thoughts or suggestions, please let me know. Thank you,
AllanUser
I appreciate you for getting back to this thread, Allan. I'm here to share with you some additional information about the P.O.# column on your QuickBooks Desktop (QBDT) report.
The purchase order (PO) number won't show up in the P.O# column on your reports. For the time being, you can create a Custom report or open the Transaction List by Vendor report to get the information you need. From there, filter the transaction type to purchase orders and add display the Num column.
For the detailed instructions, you can follow these steps:
If you wish to extract and customize the information, you can export the details to Excel. For your reference, you can check out this article: Export reports as Excel workbooks in QuickBooks Desktop.
Alternatively, you can manually open the Item Receipt, and see the PO number from there.
For more tips about handling your QBDT reports, I recommend opening this link: Understand reports.
I'm also adding this article to learn more about the different ways in tracking your vendor transactions in QBDT: Accounts Payable workflows in QuickBooks Desktop.
Please let me know how else I can assist you with reports by adding a comment below. I'm just a few clicks away to help. Keep safe!
Dear Angelyn_T ,
Thank you for your response. Your report gives me a way to see the Purchase Order entries and the associated PO# for them. This I have been able to generate. What I am still unable to do is generate a report that shows the Item Receipts with the associated PO#. As you can see on your screen shot (from your Step 5) the Purchase Orders show the PO "Num", but the Inventory Receipts (last line on the image) does not show the associated PO Number. It shows the "Ref No" information which appears to be a text field. What I am looking for is the PO Number (as shown on the last image of your prior reply - highlighted on the Item Receipt screen) to show on a report. Thank you for your help!
AllanUser
Thanks for keeping us posted, AllanUser.
I can see how the PO number is convenient for you in running your vendor reports. While the option to link the different PO numbers in the report is unavailable, you can manually open the item receipt. Also, you'll want to send feedback to our engineers. We'd like to have this opportunity to improve your QuickBooks experience.
You can send a product suggestion using these steps:
For feature updates, you can visit our QuickBooks Blog. You can check out this article for more details on customizing vendor reports.
Let me know if there's anything else that you need help with. I'll be here to help you. Have a good one!
Thank you to all those who tried to help me solve this. It appears that QB is currently unable to generate a report showing Inventory Receipts and the corresponding PO #. Product Suggestion sent along. Thanks,
AllanUser
Thank you to all those who tried to solve this. It appears that QB is unable to generate a report showing Inventory Receipts and the corresponding PO #. Product Suggestion sent along. Thanks,
AllanUser
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here