13 Type mismatch: GetQuickBooksData error when transferring information to POS

Legacy KB ID: 4831

Question

Why do I get the error:

An error has occurred in frmQuickBooksImport : GetQuickBooksData

13

Type mismatch

When I import data from QuickBooks to Retail Point of Sale.

 

Answer

Remove or replace unacceptable characters.

The most common unacceptable character is the tab character used within one of the Reckon Accounts list fields. These will usually be surrounded by double-quotes in the list file exported from Reckon Accounts.

To locate these, use an advanced text editor such as Notepad++ by following the steps below. Reckon does not warrant in any way the Notepad++ product. 


Using the Notepad++ Utility

1.    Create a fresh backup of your Accounts Business datafile and take care not to over-write existing backups;

2.    Download and install the Notepad++ Utility:

https://download.tuxfamily.org/notepadplus/6.2.3/npp.6.2.3.Installer.exe

3.   In Point of Sale Administrator, take note in the Transfer window of the list that generates this error and how many list items had been processed;

4.    Export the list identified in Step 3 to an IIF file:

a.    File> Utilities > Export > Lists to IIF files >

b.    Tick the appropriate list > OK.

5.    Open the exported list file with Notepad++:

a.    In Windows Explorer, browse to the location of your export lists file;

b.    Right click > Open With > select Notepad++ (not simply Notepad);

6.    In Notepad++:

a.  Select ‘Show all characters’ from the View menu

b.  Scroll to and click on the line number that is equal to the number of items that had been processed in Point of Sale Administrator (eg. line 3100 if 3100 items had been processed before the error)

c.   Open the Find window (Ctrl + F)

d.  In ‘Find What’, enter “ and click Find Next

e.  Check if there are any tab characters (they look like a right-pointing arrow ‘à’ ) between this instance and the next instance of the “ characters on this line.

f.   If there are, this is a problem item that needs to be fixed in Reckon Accounts.

g.  Take note of the item name and the field involved (often it’s description text)

h.  Note that before the first “, and after the second “, there will be tab characters and these are OK.

i.    Continue pressing ‘Find Next’ and following the step above to cover the remainder of the file.


7.    Close Notepad++.


8.    In Reckon Accounts edit each list item found to have issues:

a.    Edit the item and go to the field that has the tab character

b.    copy the text to Notepad

c.    delete the text from the Reckon Accounts field

d.    type the text back into the field manually

9.    When this is done, a Transfer in Point of Sale Administrator should work.


Need more help?

Ask the Reckon Community at: https://community.reckon.com/reckon.



How did we do?

Reckon Desktop POS: Error on Line 3, Cannot change the Type of Account

Reckon Desktop POS: Installing the Senor GTP-290B3 receipt printer onto an Apple computer

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)