Error: Apostrophe characters in text causing an error

Axis
Occurs: When importing text that contain an apostrophe into QuickBooks results in an error message that the name is not found.

Apostrophe Character type
Character code
Example
Supported
Vertical apostropheU+0027O'Briens
No
Right Single Quotation MarkU+2019O'BriensYes
Left Single Quotation MarkU+2018O`BriensYes

Cause: The apostrophe character (vertical apostrophe or U+0027) used is not supported when importing into QuickBooks as the character is not recognized in the character set that the QuickBooks API uses.

Resolution:  Convert the vertical apostrophe to the more commonly used Right or Left single quotation mark that is more widely supported.  Use a search a replace function to replace the character.

More references:

Article ID: 343, , Modified: 1/27/2021 at 11:31 PM

Was this article helpful?

Share this article