Point of Sale: Error – 193, Primary key for dept keywords is not unique

Point of Sale: Error – 193, Primary key for dept keywords is not unique

Questions on the software? Call us at 800-609-0788!

 

When attempting to send a mailbag from Headquarters to a remote store, or attempting to receive a mailbag at the remote store, you see the following error:

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

Error – 193 Primary key for table ‘Customer Rewards’ is not unique.

Why this is happening

  • There are duplicate department names or codes
  • Customer names have been deleted or merged
  • There is damage in the Customer List at the remote store.

How to fix it

Make sure Point of Sale is updated to the latest release and try again. If the error persists:

FIRST METHOD:

  1. Go to REPORTS
  2. Run a Customer List report
  3. Double click the first customer
  4. Once the customer opens, click View List at the top
  5. This will open the Customer List in the old v 9 version
  6. Press the CTRL + A keys to highlight them all. Once all of the customers are highlighted in light blue, choose I Want To, Delete Customer(s)
  7. At the HQ server system choose File, Utilities, Resend Files
  8. Click Resend
  9. Receive the mail bag at the remote store.

Intuit Method:

  1. From the remote store receiving the error, send a mailbag to Headquarters and then receive it.
  2. Again from the remote store, choose Customers > Customer List.
  3. One at a time, click I want to and select Delete until the list is empty. Do not be alarmed; The main customer records are contained at Headquarters and will be resent.

If you have too many customers to click one at a time:

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

 

Versions 7 and below

 

Version 7

 

This issue has been resolved in the latest release for your version. Please update your program to the most current release.

 

Version 6

 

Windows XP

To resolve this issue:

  1. Choose Inventory > Department List.
  2. Examine the list and locate any duplication of departments or codes.
  3. Edit any such department and modify the department name or code to make it unique.
  4. Delete the contents of the sub folders of the StEx folder on the Headquarters and all Remote computers:
    1. Right-click the Windows Start button and choose Explore.
    2. Navigate in the left window to the location: C:Documents and SettingsAll UsersApplication DataIntuitQuickBooks Point of Sale 6.0StExError. To navigate, click the plus sign (+) next to each folder listed.
    3. If this folder exists, right-click each file in this folder and choose Delete. Confirm the deletion.
    4. Navigate in the left window to the location: C:Documents and SettingsAll UsersApplication DataIntuitQuickBooks Point of Sale 6.0StExHistory.
    5. Right-click each file in this folder and choose Delete. Confirm the deletion.
    6. Navigate in the left window to the location: C:Documents and SettingsAll UsersApplication DataIntuitQuickBooks Point of Sale 6.0StExIn.
    7. Right-click each file in this folder and choose Delete. Confirm the deletion.
    8. Navigate in the left window to the location: C:Documents and SettingsAll UsersApplication DataIntuitQuickBooks Point of Sale 6.0StExOut.
    9. Right-click each file in this folder and choose Delete. Confirm the deletion.
    10. Close this window.
  5. Recreate and resend the mailbag. The error will not recur.

 

Windows Vista

To resolve this issue:

  1. Choose Inventory > Department List.
  2. Examine the list and locate any duplication of departments or codes.
  3. Edit any such department and modify the department name or code to make it unique.
  4. Delete the contents of the sub folders of the StEx folder on the Headquarters and all Remote computers:
    1. Right-click the Windows Logo button, and choose Explore.
    2. Navigate in the left window to the location: C:ProgramDataIntuitQuickBooks Point of Sale 6.0StExError. To navigate, click the arrow symbol next to each folder listed.
    3. If this folder exists, right-click each file in this folder and choose Delete. Confirm the deletion.
    4. Navigate in the left window to the location: C:ProgramDataIntuitQuickBooks Point of Sale 6.0StExHistory.
    5. Right-click each file in this folder and choose Delete. Confirm the deletion.
    6. Navigate in the left window to the location: C:ProgramDataIntuitQuickBooks Point of Sale 6.0StExIn.
    7. Right-click each file in this folder and choose Delete. Confirm the deletion.
    8. Navigate in the left window to the location: C:ProgramDataIntuitQuickBooks Point of Sale 6.0StExOut.
    9. Right-click each file in this folder and choose Delete. Confirm the deletion.
    10. Close this window.
  5. Recreate and resend the mailbag. The error will not recur.

 

Windows 7

To resolve this issue:

  1. Choose Inventory > Department List.
  2. Examine the list and locate any duplication of departments or codes.
  3. Edit any such department and modify the department name or code to make it unique.
  4. Delete the contents of the sub folders of the StEx folder on the Headquarters and all Remote computers:
    1. Right-click the Windows Logo button, and choose Open Windows Explorer.
    2. Navigate in the left window to the location: C:ProgramDataIntuitQuickBooks Point of Sale 6.0StExError. To navigate, click the arrow symbol next to each folder listed.
    3. If this folder exists, right-click each file in this folder and choose Delete. Confirm the deletion.
    4. Navigate in the left window to the location: C:ProgramDataIntuitQuickBooks Point of Sale 6.0StExHistory.
    5. Right-click each file in this folder and choose Delete. Confirm the deletion.
    6. Navigate in the left window to the location: C:ProgramDataIntuitQuickBooks Point of Sale 6.0StExIn.
    7. Right-click each file in this folder and choose Delete. Confirm the deletion.
    8. Navigate in the left window to the location: C:ProgramDataIntuitQuickBooks Point of Sale 6.0StExOut.
    9. Right-click each file in this folder and choose Delete. Confirm the deletion.
    10. Close this window.
  5. Recreate and resend the mailbag. The error will not recur.