Skip to main content
June 29, 2024
Question

Error -193

  • June 29, 2024
  • 1 reply
  • 0 views

Hi,

 

I need QB pos 9.0 but for some time an error appears and send transaction in HQ please help the error is next

 

Cannot save the data (Error -193: Primary key for table 'InventoryKeywords' is not unique :
Primary key value ('-7[removed]30133759,8,6,'10'') (23W01)
Record ID -7[removed]30133759 Record ID -7[removed]30133759)

 

Please Help Me

1 reply

June 29, 2024

I'm here to ensure you can overcome error 193, RAM1987. I'll be pleased to share some troubleshooting steps to address your concern.

 

We can use the Verify Data tool to resolve issues when utilizing QuickBooks Point of Sale. This way, we can identify possible damage within your data file that requires troubleshooting.

 

To begin with, let's have the debug mode accessible. Here's how:

 

  1. Click About QuickBooks Point of Sale from the Point of Sale Help menu.
  2. Keep the Point of Sale information window open and press Ctrl+Alt+D+B on your keyboard.
  3. Close the window by clicking OK.

 

After that, run the Verify utility by selecting Debug from the Help menu. From there, pick Verify Data. If there's no error message found and the issue persists, close the window and repeat the process above. Otherwise, run the Clean Up Company Data Utility tool through these steps:

 

  1. Choose Utilities from the File menu, then click  Clean Up Company Data.
  2. Check the Compress data box and pick OK after the warning message.
  3. Select Cleanup in the Proceed with Cleanup window and wait for the process to finish.
  4. You can run a second clean up if you receive an error and ensure checking the compressed data option.

 

In addition, uninstalling and reinstalling the QuickBooks Point of Sale from your computer is another way to fix issues in your data if the same error occurs after performing the suggested solutions above.

 

However, note that the QuickBooks Point of Sale has been discontinued since the 3rd of October, 2023. Although you can continue using discontinued products, you'll no longer receive the latest critical security patches and updates that cause compatibility issues.

 

On the other hand, you might want to visit this page whenever you want to switch to Shopify for a modern retail solution that integrates with QuickBooks Desktop Financial Software: Migrating QuickBooks Desktop POS to Shopify POS.

 

Please revisit the Community page anytime for the fix if you encounter any error when utilizing QuickBooks Point of Sale moving forward. We're here to offer help in any possible way.