Quickbook Reporting

I need to customize a report that shows which Invoices paid which Purchase Orders in QB's 2017. I can't get one to show both Invoice Number and PO Number at the same time.
Carson AmiralAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
To do this, you would need to go to Reports, Custom Reports, Transaction Detail, and the customize the columns in the Display tab to include P.O# and Invoice Number (Num). Then select your time frame and run it. Make sure it does what you want and put into Excel to format it.
0
Carson AmiralAuthor Commented:
Thank you, I did that, but it has a blank PO # - so it must be my user error in entering POs?
Capture.PNG
0
JohnBusiness Consultant (Owner)Commented:
Yes. Because the database would contain the PO number if entered. So you may wish to go back to the Purchase Orders and check the numbers.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

JohnBusiness Consultant (Owner)Commented:
First make sure you are using Desktop QuickBooks Professional.

Second, follow the steps below:

Create a purchase order in QuickBooks.
Select a vendor.
Categorize the purchase.
Enter the “Ship To” information. .
Choose the purchase order date.
Assign a purchase order number.
0
Carson AmiralAuthor Commented:
Thanks - I confirmed all the above, and created a new to test - still no luck. Have you ever seen that?
0
JohnBusiness Consultant (Owner)Commented:
I will see if a client I had is still using Purchase Orders. That will be into next week. I am in my home office right now and no Purchase Orders here.
0
Carson AmiralAuthor Commented:
Thank you
0
JohnBusiness Consultant (Owner)Commented:
I just opened a Sample file and created a PO. I numbered it AAA-122 so I can find it.

It is NOT in the Transaction History and I think that it because a PO is not a transaction. I should have thought of that.

However if you go to Reports. Purchase Orders, and run that, you can see the Purchase Orders.  Now Purchase Orders relate to what I purchase, so Bills and Accounts Payable.

I think someone PO to you (for Invoices and Accounts Receivable) may have to be a memo field.

Run the Purchases Report and see what it relates to in your ledger.
0
JohnBusiness Consultant (Owner)Commented:
You have to relate Purchase Order to the Bill by Select Purchase Order in the Bill Form (icon at the top). It is in the Bill where you record the PO so you can relate them in reporting later on.

Quick-Books-Purchase-Orders.
Otherwise you would need to make an Excel File of Bills and another one of Purchase Orders and then relate the two in Excel.
0
Carson AmiralAuthor Commented:
Yes - all my Bills are assigned to a PO (it shows on the PO number on the line item under the Items tab) and it's still not showing.
0
JohnBusiness Consultant (Owner)Commented:
You might need to make sure the report includes the date range of both Bill and Purchase Order.

Also, do Purchase Order number show up on the Purchase Order Report?
0
JohnBusiness Consultant (Owner)Commented:
I am in the Sample Database and I have matched a PO with a Bill and see that I have done that.

I cannot make the reports show it either.

I have seen this done a while back at a client so it was an earlier version of QuickBooks and I am not sure if it is a bug in the current version or if I am doing something wrong.
0
JohnBusiness Consultant (Owner)Commented:
I set up a new Purchase Order, then I received the items later, then I set up a Bill later for items.

The two items show up on the Vendor Transaction Summary, but both things (PO and Bill) use NUM as the number field. That is why it is not showing up on the same line.

 QBPurchase-Order-2
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
QuickBooks

From novice to tech pro — start learning today.