Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Custom External Id field on Customer

I am having a great deal of difficulty having the custom fields under "Account and Settings->Sales->Sales Form Content->Custom Fields" to show up under my Customer records.  Am I missing something or is this some sort of permanent restriction?

3 Comments
Moderator

Custom External Id field on Customer

Hello there, @mcarter.

 

Thanks for posting your concern here in the Community. I'm here to share some information about adding a custom field for your customer's external ID in QuickBooks Online (QBO).

 

The steps that you've tried will only add a custom field on any of your sales transaction but not on your customer records. If you already added the custom field, try to create an invoice and you'll see it there.

 

If you'd like to see the external ID of your customer on his/her records, you can edit their details and add this information. Here's how:

 

1. On the left pane, choose Sales then go to Customers tab.
2. Click on your customer's name.
3. On the right side, select Edit.
4. You have two options to add the external ID. You can add it to the Other box (you can view this information when you pull up the Customer Contact List report) or add it to the Notes (you can see it directly on the customer details).
5. Once done, click Save.

 

Please see the sample screenshots below.

 

 

 

 

 

For your reference, you may visit this article for more information: How to edit customer information.

 

Give this a try and let me know how it goes for you. Should you have additional questions, don't hesitate to leave a comment below. I'm always here to help you out. Have a great weekend.

Level 1

Custom External Id field on Customer

Hi there,

 

I'm using Quickbooks desktop and need an external ID to sync with CiviCRM.  Was thinking to use the "account number" under "payment settings". 

 

  1.   Is there any problem with using "account number" as external ID?
  2. Is there any way to mass update or auto assign these numbers?  We've never used them before and it would be very tedious to add an account number one at a time.
  3. Once we update the account number (or whatever field is best for this purpose), what's the best way to maintain this protocol for all new customers, so that we have up-to-date sync data.

Thanks so much,

 

 

QuickBooks Team

Custom External Id field on Customer

Hi yonaberlin,

 

With regard to using third-party software, the data mapping is done on their side. I couldn't recommend what's best for this since the software isn't made by Intuit, but you can reach out to their technical support team to ask for the correct setup.

 

If you have other questions, feel free to comment below.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us