Error code 190000 Cannot save the data error193: Primary key for table 'CustomerReward' is not unique

Hi there, jillnoel.

Sometimes unexpected behaviors or receiving unusual errors happen when using QuickBooks Point of Sale. To isolate this, let's perform some troubleshooting steps. Beforehand, you'll need to make sure that you’ve created a backup of your data file .

Once done, you can now start the troubleshooting steps by uninstalling QuickBooks Point of Sale from your computer.

Here's how:

1. On your keyboard, press Windows + R to open the Run window.
2. Enter “Control Panel”, and choose OK. Then, select Programs and Features. Note: If the Control Panel is in Category View, select Uninstall a Program.
3. From the list of programs, select QuickBooks Desktop Point of Sale 18.0, then select Uninstall/Change.
4. Follow the prompts to complete the process.

After that, rename all Point of Sale folders. That being said, if uninstalling from the server computer or the computer where the POS data file is locally saved, copy the Point of Sale data folder and paste it to the Desktop. Then, install QuickBooks Point of Sale  and make sure that your computer meets the system requirements . This way, you’re less likely to encounter any incompatibility issues.

If the issue continues to occur, you can contact our Support Team. they can pull up your account securely and further investigate the cause of the error. For the support's contact information, you can check this article: QuickBooks Desktop Point of Sale.

Please know that I'm always here to lend a hand if you have any other QuickBooks or data damage concerns. Wishing you continued success!

Hi ChristieAnn,   I have tried your suggestions and my store exchange center is still backed up with 6 transfer files giving me the same error code as in my subject line above.  I believer this is beyond something that I can fix myself.   How do I go about getting more help from the QB team?   Thank jillnoel.    

This isn't the kind of experience we want you to have in using QuickBooks Point of Sale (POS), @jillnoel. That's why I'm here to guide you on the actions you need to take care of this issue.

When uninstalling and then reinstalling QuickBooks POS unable to resolve the error, I'd recommend contacting our Customer Care team. They can securely pull up your account, further investigate the cause of the error, and guide you with a fix. You'll first have to check out our support hours to ensure we can assist you on time. Let me guide you how.

1. Visit the Point of Sale Support article.
2. Go to the QuickBooks Point of Sale section.
3. Click the Chat with us link and follow the on-screen instructions to complete the process.

In the meantime, I'm also adding this article to learn more about the POS system and further guide you on managing the growth of your business using it: QuickBooks Point of Sale Resource Center. It includes topics about FAQs, support, and system requirements, to name a few.

Let me know how it goes in the comments below. If you have other concerns about managing your QuickBooks POS account and transactions, I'm just around to help. Take care always.

Did you ever get a solution? I am having same issue, with 14 remote stores and I need to get it fixed

Hello @Mdclatt,

Let's perform a few troubleshooting steps you can get rid of the error message you receive while working with QuickBooks Point of Sale (POS).

To start with, let's update and make sure to install the latest released version of QuickBooks POS by following the steps below:

1. Go to Help.
2. Select Software Update.
3. Click Check for Updates.
4. If an update is available, you'll see an option to download and install it.
5. Select Update now.
6. Click OK.

However, if you've confirmed the latest released version is installed already, let's repair QuickBooks Instead. Let me show you how.

1. Go to Start.
2. Select Control Panel.
3. Under Program and Features, select Uninstall a Program.
4. From the list of applications, select QuickBooks.
5. Select Uninstall/Change.
6. Click Repair.

If you have any other questions, please let me know in the comments below. I'll be here to lend a hand.