Point of Sale: Error - 193


When wanting to send a mailbag from Headquarters to a remote store, or wanting to receive a mailbag during the remote store, you see the QuickBooks Error 193:

Error - 193 Primary key for dept keywords is not unique.

Error - 193 Primary key for table 'Customer Rewards' is not unique.

Why this will be happening

You will find duplicate department names or codes
Customer names have already been deleted or merged
There is damage in the Customer List during the remote store.
How exactly to fix it

Make sure Point of Sale is updated towards the latest release and attempt again. In the event that error persists:

FIRST METHOD:

Head to REPORTS
Run an individual List report
Double click the first customer
Once the customer opens, click View List at the very top
This can open the client List within the old v 9 version
Press the CTRL + A keys to highlight them all. Once most of the customers are highlighted in light blue, choose I Want To, Delete Customer(s)
At the HQ server system choose File, Utilities, Resend Files
Click Resend
Get the mail bag in the remote store.
Intuit Method:

From the remote store receiving the error, send a mailbag to Headquarters and then receive it.
Again from the remote store, choose Customers > Customer List.
One at a time, click i do want to and select Delete before the list is empty. Don't be alarmed; The main customer records are contained at Headquarters and you will be resent.
When you yourself have way too many customers to click one at the same time:

Version 10 and 2013: click on the first customer within the list, press the Shift key, and then click the last customer within the list.
Version 9: Press the CTRL + A keys to highlight them all.
From Headquarters, choose File > Utilities > Resend files.
Click Resend.
Get the resend mailbag at the remote store.