Skip to main content
L
Loocie
June 19, 2021
Question

Customize A/P Report to include Customer:Job

  • June 19, 2021
  • 1 reply
  • 0 views

I'm using Desktop Premier Contractor edition, and I'd like to be able to see which job a vendor's invoice was posted to.  

 

When I enter a new 'bill', I can specify which "Customer:Job" it is for, but when I want to print out a report of what I owe a vendor, or maybe all open A/P, I have to open each item in the report to find out which job it's for.  Why can't I add that to a report???  I can add columns related to employees or payroll (which are not relevant), but I can't add a column that tells me which job each invoice goes to.  

 

Am I missing something?

    1 reply

    DivinaMercy_N
    DivinaMercy_N
    June 19, 2021

    Welcome to the QuickBooks Community, @Loocie.

     

    QuickBooks Desktop (QBDT), helps you generate the report your business needs. To run a report which shows the job allocated to the bill you've created, you can pull up the Custom Transaction Detail Report. To get started, please follow these steps:

     

    1. Navigate to the Reports tab and hover over Custom Reports.
    2. Choose Transaction Detail. 
    3. When the report is open, click the Customize Report button.
    4. Go to the Display tab.
    5. From the Columns field, check Name (so you'll know the specific job and vendor assigned to a bill) and Source Name (this will let you know the vendor's name where the customer job is associated). 
    6. You can also add other columns and filters you need.
    7. Then, select OK. 

     

    Once done, you'll report will be like this:

     

    To know more about the process, check out this article: Understand reports.

     

    Also, QBDT makes it easy to save your report customization so you'll be able to use it in the future. To do so, simply click the Memorize button in the reports window. 

     

    If there is anything else I can do to help you in running a vendor report, please post a response below. I'm always available to help in case you need it. Have a good one.

    L
    LoocieAuthor
    June 21, 2021

    I appreciate the reply, but that's not what I was looking for.  Let me give you an example:

     

    Let's say I'm looking at a specific vendor in the Vendor Center, and under Reports for this Vendor, I select Open Balance.   I get a report with all open invoices for this vendor.  But I want to see which job each of these invoices belongs to.  If I select Name and Source Name under Customize Report>Display, the vendor's name shows up in each column.  I already know that it's for that vendor because I selected Open Balance for that vendor.  And I'm not looking for all the transactions - I just need to know which job each invoice goes to.  But I don't have the option to select Customer>Job, and the Name and Source Name columns don't provide the correct info.

     

    Your report appears to give me a list of every transaction during a period of time.  I understand that I can customize and memorize, etc.  But that's a lot of changes to have to make.  It just seems to me that providing the ability to select Customer>Job in the column list and/or filter list makes more sense.  Or better yet, why not make it the default, at least in the Contractor's Edition?  I can't be the only one that would find that info extremely helpful.  

     

    In any case, thanks for your reply.

     

      Kristine Mae
      Kristine Mae
      June 21, 2021

      Let me help you get around your concern, Loocie. 

       

      We're unable to pull up a specific report that shows both details that you need. You'll want to pull up two reports instead. 

       

      For the vendor side, you can continue to pull up the open balance report. Then, pull up a sales report so see the invoice. Here's how:

      1. Click Reports.
      2. Go to Sales.
      3. Select Sales by Customer Detail.

      You may want to export the said reports and combine them as one. Click Excel, then select Create New Worksheet. 

       

      Feel free to visit us if you have other concerns. We're around to help you. Take care!

      Terms & ConditionsAccessibility statement