cancel
Showing results for 
Search instead for 
Did you mean: 
EdNewman
Level 3

Change Colum Display Name in QBE Report

Struggling to find out how to do what seems like a simple task.  I have a customized report of purchase orders and one of the columns is "Other 1".  How do I rename the column name on the report?

6 Comments 6
LieraMarie_A
QuickBooks Team

Change Colum Display Name in QBE Report

The Community has your back, @EdNewman

 

Changing the column name for Other 1 can be done with ease. I'll guide you how.

  1. Go to the Vendors menu and select Create Purchase Orders.
  2. Click Customize Data Layout.
  3. Under the Title column, edit the name for Other 1.
    Capture.PNG
  4. Click OK.

 

Doing this will automatically change the column name for Other 1.

 

Let me share these articles with you for more tips in customizing your reports and forms in QuickBooks Desktop: 

 

Should you need further assistance in customizing your report, please let me know in the comment section. I'm always around to help.

EdNewman
Level 3

Change Colum Display Name in QBE Report

That changes it in the Purchase Order screen as well as on the printed purchase order, which I had already done.  My problem is the column title on a report. 

 

Report.jpg

JoesemM
Moderator

Change Colum Display Name in QBE Report

Thanks for getting back to us, @EdNewman.

 

Changing the Other name in the reports column is unavailable. As a workaround, you can export the report to Excel and rename it from there. Let me guide you how.

 

  1. Go to the Reports menu.
  2. Select Purchases then click Open Purchase Orders Detail.
  3. Click the Excel button, then select either Create New Worksheet or Update Existing Worksheet.
  4. Follow the on-screen instructions to complete the process.

For more details, you can check this link that can guide you in exporting your reports to Excel. This way, you can access your reports anytime outside QuickBooks.

 

Also, I encourage checking out this article that will help you track where the business stands in terms of expenses and accounts payable: Customize vendor reports.

 

Let me know if there’s anything else I can help you with managing your reports or any other concerns in QuickBooks. I’m always around to help. Have a good one.

EdNewman
Level 3

Change Colum Display Name in QBE Report

Once again QB fails at even the most basic tasks.  Of all the columns which you might want to change the title of, "other" would seem to me to be the most likely.  I tried to use Service Date initially for this field.  Made more sense since we are storing dates, but the report does not allow you to add the service date field to the report.  Counting the months until we switch away from QB.

Anne16720
Level 3

Change Colum Display Name in QBE Report

3+ years later and there is still no way to change the label title in a custom report.  Really, this should be the most simple fix and really make use of reporting efficient.  I love the answer, export to excel and change it there.  That is a 3-5 minute exercise each time you run the report, make the changes and reformat for printing, emailing.  What a shame that QB  does not listen to their customer needs.  Last I checked we pay your salary!!

Anne16720
Level 3

Change Colum Display Name in QBE Report

@JoesemM in case you don't get notified of my recent post:

3+ years later and there is still no way to change the label title in a custom report.  Really, this should be the most simple fix and really make use of reporting efficient.  I love the answer, export to excel and change it there.  That is a 3-5 minute exercise each time you run the report, make the changes and reformat for printing, emailing.  What a shame that QB  does not listen to their customer needs.  Last I checked we pay your salary!!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us