A+ QBooks Consulting & Services, LLC - official website

QuickBooks Point of Sale Basic 18.0 New User
QuickBooks Point of Sale Basic 18.0 New User
$1 800.00
$849.00

QuickBooks Point of Sale Basic 18.0 ADD A SEAT
QuickBooks Point of Sale Basic 18.0 ADD A SEAT
$1 800.00
$849.00

QuickBooks POS Multi-Store 18.0 ADD A SEAT w/Merchant Services
QuickBooks POS Multi-Store 18.0 ADD A SEAT w/Merchant Services
$2 700.00
$649.00

QuickBooks Point of Sale Pro 18.0 ADD A SEAT
QuickBooks Point of Sale  Pro 18.0 ADD A SEAT
$2 500.00
$1 049.00

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 Settings\All Users\Application Data\Intuit\QuickBooks Point of Sale 6.0\StEx\Error. 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 Settings\All Users\Application Data\Intuit\QuickBooks Point of Sale 6.0\StEx\History.
    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 Settings\All Users\Application Data\Intuit\QuickBooks Point of Sale 6.0\StEx\In.
    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 Settings\All Users\Application Data\Intuit\QuickBooks Point of Sale 6.0\StEx\Out.
    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:\ProgramData\Intuit\QuickBooks Point of Sale 6.0\StEx\Error. 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:\ProgramData\Intuit\QuickBooks Point of Sale 6.0\StEx\History.
    5. Right-click each file in this folder and choose Delete. Confirm the deletion.
    6. Navigate in the left window to the location: C:\ProgramData\Intuit\QuickBooks Point of Sale 6.0\StEx\In.
    7. Right-click each file in this folder and choose Delete. Confirm the deletion.
    8. Navigate in the left window to the location: C:\ProgramData\Intuit\QuickBooks Point of Sale 6.0\StEx\Out.
    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:\ProgramData\Intuit\QuickBooks Point of Sale 6.0\StEx\Error. 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:\ProgramData\Intuit\QuickBooks Point of Sale 6.0\StEx\History.
    5. Right-click each file in this folder and choose Delete. Confirm the deletion.
    6. Navigate in the left window to the location: C:\ProgramData\Intuit\QuickBooks Point of Sale 6.0\StEx\In.
    7. Right-click each file in this folder and choose Delete. Confirm the deletion.
    8. Navigate in the left window to the location: C:\ProgramData\Intuit\QuickBooks Point of Sale 6.0\StEx\Out.
    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.

 

QuickBooks Point of Sale Basic 18.0 NEW USER w/Merchant Services
QuickBooks Point of Sale Basic 18.0 NEW USER w/Merchant Services
$1 800.00
$699.00


QuickBooks POS Multi-Store 3pc Software Peripherals Bundle
QuickBooks POS Multi-Store 3pc Software Peripherals Bundle
$3 265.00
$1 699.00


QuickBooks POS Pro 18.0 Peripherals Bundle w/Merchant Services
QuickBooks POS Pro 18.0 Peripherals Bundle w/Merchant Services
$3 075.00
$1 225.00


QuickBooks POS Multi-Store 18.0 w/ Peripherals Bundle
QuickBooks POS Multi-Store 18.0 w/ Peripherals Bundle
$3 275.00
$1 724.00


Show Cart

QBdeal Shopping Cart
Your Cart is currently empty.

Accept Credit Cards

QuickBooks POS Multi-Store 18.0 NEW USER w/Merchant Services
QuickBooks POS Multi-Store 18.0 NEW USER w/Merchant Services
$2 700.00
$649.00


QuickBooks Point of Sale Basic 18.0 NEW USER w/Merchant Services
QuickBooks Point of Sale Basic 18.0 NEW USER w/Merchant Services
$1 800.00
$699.00


QuickBooks POS Basic 18.0 3pc Bundle w/Merchant Services
QuickBooks POS Basic 18.0 3pc Bundle w/Merchant Services
$2 365.00
$1 195.00


QuickBooks POS Pro 18.0 Peripherals Bundle w/Merchant Services
QuickBooks POS Pro 18.0 Peripherals Bundle w/Merchant Services
$3 075.00
$1 225.00



Call Us Now 1.800.609.0788

Intuit | BBB