Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowDoes anyone have a report design that would show all vendors (also have the ability to sort by date range) that are missing a customer name? I need to ensure our vendor bills are being linked to their appropriate customer but have not found a report design that will do so, and my customizing of existing designs is pulling the vendor name (Source Name) into the customer (Name) field which is not helping me to identify those entries that are missing the customer. Please help!
It's my pleasure to assist you today, JGonzales21.
While there isn't a specific report in QuickBooks Desktop (QBDT) that shows vendors bills with missing customer name, you'll want to run the Job Cost Detail report as an alternative. The report shows all the vendor bills that are under a Customer:Job.
I'll be glad to guide you on how.
Once you open the report, you'll see under the Source Name column the Customer:Job. Below are vendors that are linked to the Job. Please see the image below for reference.
Also, you can check these helpful articles for reference in case you want to learn how to customize report in QuickBooks Desktop:
Visit us again if you need further assistance in tracking your vendors transactions. We're always here to help. Have a great day.
Hello,
Thank you for the suggestion, however this does not provide me with what I need. I need to see the Bill entries which are missing the customer. Your report suggestion will provide me with entries including the customer. Please provide a report design/suggestion where I can obtain this information.
RE: my customizing of existing designs is pulling the vendor name (Source Name) into the customer (Name) field which is not helping me to identify those entries that are missing the customer.
Unfortunately that is (I think) the only way to determine the detail lines missing a customer: If the detail line on the report has the Vendor name in the Name column, then there isn't a customer:job on that row of the bill.
Hi BigRed,
I ran into the same scenario, which is frustrating as my reports can run quite long. It would be so nice to be able to identify just the entries that are blank, not having to scan over the entries that duplicate the vendor name into the customer field. Thank you so much for trying to help. I hope you have a great weekend!
I hope you found your answer already but I ran across your question and wanted to see if I could help. I think the report you could use is under Job Costing and is called Expenses Not Assigned to Jobs. Hope that helps!
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