I am using the Customer Combiner function(Tools>Utilities>Sales>Customer Combiner and Modifier. When I run it, I am getting a Primary Key Constraint Error. Anybody ever encounter this before?
Thanks!
*This post is locked for comments
I touch on this in the post on my blog:
[View:http://www.timwappat.info/post/2015/09/02/Care-naming-database-objects-in-Dynamics-GP-for-custom-GP-Addins:750:50]
and
[View:http://www.timwappat.info/post/2015/09/02/Customer-combiner-and-table-not-found-errors:750:50]
The customer combiner runs a SQL script that DYNAMICALLY iterates through the database hunting for the CUSTNMBR fields, and tables containing that field. It then updates the values in those fields to the customer number you are merging into for any customers you are merging from.
However if there is already a record for that "merge to" customer in the table, then you will get this key violation error.
The combiner script works fine for the base product as native tables are dealt with specifically by the script where they are keyed in this way. It falls over on 3rd party tables, unless the 3rd party product has written in support for the combiner.
Check with the 3rd party product for a solution.
Disabling the product is unlikely to work as this operation is performed by and within the database and does not respect the status of the product.
Hi David,
Try disabling the 3rd party product Ethotech's Commission Plan and try using the Customer Combiner again.
I believe the ASI28050 table is part of Ethotech's Commission Plan product. Since it's a 3rd party, the built in tool might not work completely. You may need to update the 3rd party tables manually and then run the tool. You could try reaching out to them and they may have specific steps to go along with the tool.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (