cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Contributor **

Adding a field to a customer report

Hi,

I'm using QuickBooks Desktop Pro 2017

We have just started emailing invoices and offering online payment. I import my invoices using iif. To get the information for the iif file, I run a customer report, export it to excel, and then use that to do a mail merge.

I learned last year that I needed a "To Send" field in my TRANS line but I can't find a report that includes "Preferred Send Method." I use a memorized Customer Contact List but that field is not an option and I can't find another report that includes it that I could even export and merge with my current report. 

Any suggestions? 

Solved
Best answer 04-08-2019

Accepted Solutions
QuickBooks Team

Re: Adding a field to a customer report

Hello, bgeiger.

 

Good to see you here in the QuickBooks Community. Let me help guide you on how to pull up the report you need in QuickBooks Desktop. 

 

You can run the Transaction List by Customer report and customize it to show the Preferred Send/Delivery Method information. Here's how:

  1. At the top menu bar, click Reports.
  2. Go to Customer & Receivables.
  3. Select Transaction List by Customer
  4. Click Customize Report.
  5. Select Display option.
  6. On the Columns tab, type-in and select the Preferred Delivery Method.
  7. Click OK
  8. Change the date range.

For additional reference, you can check this article on how to customize reports in QuickBooks Desktop

 

This will get you on the right track. Feel me in if you have additional questions about the Transaction List by Customer report. I'll be around to help. 

3 Comments
QuickBooks Team

Re: Adding a field to a customer report

Hello, bgeiger.

 

Good to see you here in the QuickBooks Community. Let me help guide you on how to pull up the report you need in QuickBooks Desktop. 

 

You can run the Transaction List by Customer report and customize it to show the Preferred Send/Delivery Method information. Here's how:

  1. At the top menu bar, click Reports.
  2. Go to Customer & Receivables.
  3. Select Transaction List by Customer
  4. Click Customize Report.
  5. Select Display option.
  6. On the Columns tab, type-in and select the Preferred Delivery Method.
  7. Click OK
  8. Change the date range.

For additional reference, you can check this article on how to customize reports in QuickBooks Desktop

 

This will get you on the right track. Feel me in if you have additional questions about the Transaction List by Customer report. I'll be around to help. 

Community Contributor **

Re: Adding a field to a customer report

Thanks - that's exactly what I was looking for.

Barb

QuickBooks Team

Re: Adding a field to a customer report

You're very much welcome, bgeiger.

 

I'm glad that I was able to help you today. Please know that you're always welcome to post if you have any other concerns about your QuickBooks. The Community team will always here to help you out. 

 

Wishing you and your business continued success. 

Need to get in touch?

Contact us