Ask the Community
Groups
Invoice export from PSA to Quickbooks fails with :UTFDataFormatException, Message:invalid byte 1 (’) error - Connect IT Community | Kaseya
<main> <article class="userContent"> <p> Issue:</p> <p>When exporting invoices to QuickBooks, the export fails with an error: <em>System.Runtime.InteropServices.COMException (0x80040301): An exception occurred! Type:UTFDataFormatException, Message:invalid byte 1 (’) of a 1-byte sequence.SAXParseException: error at line XXXX, column XX in XML data.</em></p> <p><em><img src="https://us.v-cdn.net/6032361/uploads/migrated/QKOBBA2G61RX/mceclip1.png" alt="mceclip1.png" class="embedImage-img importedEmbed-img"></img></em></p> <p><em><strong>Error message:</strong></em></p> <div>An exception occurred! Type:<strong>UTFDataFormatException, Message:invalid byte 1 (’) of a 1-byte</strong> sequence.SAXParseException</div> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/NFM118BHH9Y3/mceclip0.png" alt="mceclip0.png" class="embedImage-img importedEmbed-img"></img></p> <p><em><strong>Cause:</strong></em> </p> <p>This is due to an invalid character in the customers' list of QuickBooks. This issue is seen with the newer sdk version for the Quickbooks desktop connector. Other applications similar to our PSA has reported this issue stemming from Quickbooks. </p> <p> Solution:</p> <p>The sync tools throws an error as it logs an invalid ASCII character somewhere in your data. This could be in your customer name, company name, address, etc </p> <p>The log shows the error to be a curved single quote.<strong> (’)</strong>. There is a very minute difference between the closing quote and the straight quote <strong>('). </strong>The easiest way to fix this, to look for single quotes, delete, and then just put a new single quote from the keyboard, to take the correct ASCII.<br><img src="https://us.v-cdn.net/6032361/uploads/migrated/JSPPQJ3JXCDU/mceclip2.png" alt="mceclip2.png" width="500" height="500" class="embedImage-img importedEmbed-img"></img></p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/I8ACDSO2FXWV/mceclip4.png" alt="mceclip4.png" width="500" height="500" class="embedImage-img importedEmbed-img"></img></p> <p>Use the following steps to see the records with the incorrect quote. </p> <ol><li>Log in to QuickBooks as Admin</li> <li>Open <strong>Preferences</strong> from the <strong>Edit</strong> menu</li> <li>Select <strong>Integrated Applications</strong> in the list on the left</li> <li>Click the <strong>Company Preferences</strong> tab</li> <li>Select <strong>QuickbooksConnector</strong> in the list and click <strong>Properties</strong> </li> <li>Check the <strong>Allow this application to access Social Security Numbers, customer credit card information, and other personal data option</strong> and click <strong>OK</strong> to close the properties window </li> <li>Click <strong>OK</strong> to close the Preferences window</li> <li>Switch back to Quickbooks connector and Synchronize again</li> <li>You will no longer see the error instead you will see the data to be exported, but with a question mark in the names where the invalid character is present</li> <li>Open the record where the character is seen and edit the customers with this invalid character</li> <li>You have to fix these records and then import to match for an account in PSA</li> <li>If you import the data with the question mark, new items will be created in PSA as there is no existing data to match with PSA<img src="https://us.v-cdn.net/6032361/uploads/migrated/2O3PGHBTKOD2/q.gif" alt="q.gif" width="500" height="500" class="embedImage-img importedEmbed-img"></img></li> </ol> </article> </main>