Error with QuickBooks Online: Display name rule prohibits colon in organization name.

  • 7 February 2024
  • 1 reply

i have a Zap that creates an invoice in Quickbooks online with a find or create customer step. i am having the find step search by Display Name, because the email address associated with the customer may change over time as people leave the organization.

the problem i’m running into is that one of the organizations that i asked QB to find has a colon in their name (e.g. “Awesome Sauce: The Best Company Ever”), and QBO has a rule that you can’t have a colon in the display name.

anyone have a workaround? it looks like you can’t search by anything other than Display Name or Email and the match has to be exact (it can’t search for partial match). i could change their company name to “Awesome Sauce (The Best Company Ever)” or something, but they might need their legal name on their invoice for some government reimbursement reason or something.

i can go back to creating invoices by hand in QBO, but would rather find a more clever solution. thanks for any ideas!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @AI_hello 

You can add a Formatter > Text > Replace step to remove special characters.