Quickbooks Enterprise Reporting - Custom Customer Fields not showing on Transaction Report

I thank you for the screenshot you've provided, @JJPayroll.

With QuickBooks Desktop, you can generate and customize a Transaction Detail report to display the data that will suit your business needs.

Here’s how:

1. Go to the Reports menu.
2. Select Custom Reports.
3. Choose Transaction Detail.
4. In the upper right, click on the Customize Report button.
5. On the Display tab, choose the data you want to be included in the Columns field.
6. From the Filter tab, set the specific information you want to see.
7. Click on OK.
8. Select the correct period by clicking on the Dates drop-down.
9. Click on the Total By drop-down, choose payment method/license number/expiration date.
10. Choose the Refresh button for the changes to take effect.

Once done, you should see the total for each custom field.  Also, I'm adding these articles with detailed instructions on how to tailor reports: 

• Targets vs. Sources overview
• Customize reports in QuickBooks Desktop

Drop your comments below if you have other questions about managing your reports in QuickBooks. I'm always here to help.

Thanks for the assistance but I don't think that works, my issue is populating the custom data, not running the report by dates using the license number, sold by etc fields. 

Hi there, @JJPayroll.

I agree with my colleague. We can customize the Transaction Detail report to show the data that you need for your business. In addition, you can add some filters to see the specific information you want for your report. 

Here's how: 

1. Go to the Reports tab.
2. Choose Custom Reports, then select Transaction Detail.
3. In the pop-up window to customize your report, click Filters.
4. Type in Detail Level in the Search Filters field.
5. Under Detail Level, choose All except summary. 
6. Once done, click OK.

For additional information, you can refer to this article: Customize reports in QuickBooks Desktop.

I've added this article that can guide you to save your current customization: Create, access and modify memorized reports.

You can always get back to us if you need further assistance. We're here to help Have a pleasant day!

okay did that, and reran the report, but it is still not showing the values I am looking for.  I am trying to compare the transaction detail from invoices to a benchmark. 

The benchmark is a custom field I have created at the 'Customer' level on the "Edit Customer/Additional Info" tab.  On the modify report screen I have selected the columns (see screenshot) to include but there's not data despite me having data on the 'edit customer' screen.  

In experimenting, the only way I could get the values to populate is if they were included on the invoice template.  problem here is that I import invoices from another program, so that's not an option for us

We appreciate the details you provided and the steps you did, JJPayroll.

Yes, the the custom field added on the Customer information will appear if you customize the invoice template you're using. And it seems that you've already tried this option. You can reach out to the third-party service where the invoices are imported from. They might be able to configure a few settings to get the custom field working directly to the invoice.

If the same thing happens, you can contact our Customer Care Team. They can provide additional troubleshooting steps.

1. Click Help at the top menu and select QuickBooks Desktop Help.
2. Select Contact us and then enter that you get Reminder prompts. 
3. Select Continue. 
4. Choose either to Message an Agent or Talk to a Specialist. 

Let me know if you need anything else.