Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I need to add a new column on the Open Invoices report and the Unpaid Bills Detail reports. I have gone to customize report but the Column Names I need aren't there. I need to add a column names or edit one that is existing and add it to my report. On the Open Invoices report I need to add a column for my companies job number and edit the one column that says "Num" to "Invoice #).
I appreciate you reaching out with your concern, AFB355. I'm happy to guide you step-by-step to ensure everything goes smoothly.
In QuickBooks Desktop, the customization options are designed to maintain consistent and accurate reporting using predefined column names. This ensures that the software properly categorizes and organizes the generated financial data.
Although editing or renaming column names isn't currently supported, we acknowledge the significance of this functionality and appreciate your feedback. We encourage you to share your insights and suggestions with our product engineers.
In the meantime, you can create or modify a custom field to achieve your desired column names. Once set up, these fields can be added to your form templates, making them available in the column list.
Here's how:
Once you have customized your report, you can memorize it to save the settings for future use. This way, you won’t need to go through the customization process again.
Additionally, consider using Intuit Data Protect to automate your backup process. This tool allows you to schedule backups, ensuring your data remains up-to-date without taking up unnecessary space.
We want to ensure your QuickBooks Desktop experience is seamless and positive. Don't hesitate to ask for further assistance managing your reports or any other QuickBooks-related queries. Our team is always here to help.
Thank you so much for your help.
I did what you stated and when I hit "OK" it doesn't save it or make it an option for me to choose from. Do I need to be in Admin and single user for that to work? First I am trying to add "AFB Job #" as an option in the column section on the Open Invoices report.
Thanks for trying the steps provided by my colleague, @AFB355. Allow me to give additional information or steps in creating a custom field in QuickBooks Desktop.
It isn't necessary to be an admin of the account to be able to add a custom field. If you have not successfully added it, follow the complete steps below:
You can add pre-populated fields from the What kind of data? section if you use QuickBooks Desktop Enterprise. The column is column. You can create a free-form text field by selecting Any text.
Once done, let's create custom item fields.
Here's how:
If you are still not able to save when clicking OK, let's repair QuickBooks so you can successfully add a custom field and get back to business in no time.
Let me show you how:
In addition, I'm adding this article for more information about the QuickBooks tool: Fix company file and network issues with QuickBooks File Doctor.
You can comment below for any follow-up questions about running reports in QuickBooks Desktop. I'm always here to help. Have a great day.
OMG that worked perfectly!! Thank you, I was able to add the Custom Field to my report.
The open invoices report populates from Invoices, how can I add a job # box on my invoice? There is a job number box on our estimates but when I turn the Estimate into an Invoice that doesn't come over. Is there something I am missing to get that to transfer over to the invoice like the PO Number and Terms boxes?
On behalf of my colleague, you're most welcome, AFB355. Your constant participation on this thread is much appreciated.
The automatic transfer of the PO number and terms fields to invoices is a direct result of these fields being part of your invoice template. In this case, you'll need to first include or add the job number custom field in your invoice template. This will allow the specific field to automatically appear on your invoices when you convert the estimate. Let me walk you through the process:
After that, the specific field will now populate on your invoices. Just be sure to select the invoice template when you convert the estimate. I'll add add the images depicting the conversion process.
In Estimates:
When converted into an Invoice:
I'll add this article for more info: Create and use custom fields in QuickBooks Desktop.
Let me know in the comments section below if you have additional questions about customizing your sales transaction.
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