I get a duplicate key error when making changes in the Vendor Combiner and Modifier window
Starting in late builds of Mekorma x78, minor build 10, you will no longer receive the duplicate key error when making changes in the Vendor Combiner and Modifier window, after changing either the Remit to or Primary Address fields in Vendor Maintenance.
If you are not able to upgrade and if you do not use the outdated version of Mekorma Enhanced Electronic Payments product (MEEP), you could remove it from the dynamics.set file as follows:
1. Open the Dynamics.set file
2. Decrement the top number by 1.
3. Remove the following:
8209
Mekorma Enhanced EPayment
:C:Program Files (x86)/Microsoft Dynamics/GP2018/MEEP8209.DIC
:C:Program Files (x86)/Microsoft Dynamics/GP2018/Data/MEE8209F.DIC
:C:Program Files (x86)/Microsoft Dynamics/GP2018/Data/MEE8209R.DIC
4. Save changes.
5. Remove the MEEPConnector.dll from the GP Add In folder.
Alternatively if you wish to keep the MEEP product installed, and upgrading is not an option you can run a SQL Truncate statement each time you want to run the Vendor Combiner.
Please use SQL Management Studio>set to company database in question, then execute script
The SQL statement is: TRUNCATE TABLE MEEP_VendorChangesPending