Skip to main content
February 1, 2021
Question

Can I add a new field to Invoice layout, so I will can search its contents? I want the field to contain 3 letters S, T, P and be able to search for, say, all P people

  • February 1, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

February 1, 2021

Hi Robin-Philbrick,

 

There's absolutely a way of doing this. 

 

Firstly, you need to add a custom field to your invoices. 

 

Set up custom fields to appear on sales forms

You can easily set up custom fields to appear on sales forms:

  1. Select Settings ⚙️.
  2. Select Account and Settings.
  3. Select Sales under Accounts and Settings, then go to the Sales form content section.
  4. Select the pencil icon in that section.
  5. Enter a Name into each dialogue box beneath the heading Custom fields and select whether you want the field to be internal (only displayed in QuickBooks), or public (displayed in QuickBooks and displayed/printed on sales forms).
  6. Select Save and then Done. These fields will now appear on your sales forms.

Notes:

  • If nothing is entered in the custom fields on a specific sales form, the field will not print.
  • Editing the checkboxes and names in the custom forms styles section of QuickBooks will change all custom form styles custom fields on the Sales transaction. The best practice is to check all three options and use only what is needed when filling out the Sales transaction. The unused fields will not appear on the printed or delivered form.

Now you're able to add custom fields to invoices.

 

Add Custom field to invoice report

1. Go to Reports

2. Choose Invoice List Report

3. Click the Customise button

4. Under the Rows/Columns section, click Change columns

5. Find the added custom column for your invoice and make sure it's ticked

6. Run the report and you can filter from there

7. Click Save Customisation so you can access the updated report

 

Thank you,

Georgia