When trying to combine vendors you get the following error:
Conversion failed when converting the varchar value 'xxxxx' to data type int.
The stored procedure TACallVendorCombine returned the following results DBMS: 245, Microsoft Dynamics GP; 0
And the following tables are in the error report:
| HQMS_History_Vendor_1 | VendorID_new | int | NULL |
| HQMS_History_Vendor_1 | VendorID_old | int | NULL |
| HQMS_ResultsHeader | VendorID | int | NULL |
| HQMS_Vendor_1 | VendorID | int | NULL |
| HQMS_VendorInspection | VendorID | int | NULL |
This is a known issue. The workaround is to rename the VendorID column in the above 5 tables, run the combiner process, and then rename the column back to VendorID. As a precaution, after renaming the columns back you can run the QES_Upgrader to refresh any possible incorrect changes made. Make sure to rename the columns back to VendorID otherwise users will get errors when access forms in QES.
--run this script before the vendor process
EXEC sp_RENAME 'HQMS_ResultsHeader.VendorID' , 'VendID', 'COLUMN'
EXEC sp_RENAME 'HQMS_Vendor_1.VendorID' , 'VendID', 'COLUMN'
EXEC sp_RENAME 'HQMS_VendorInspection.VendorID' , 'VendID', 'COLUMN'
EXEC sp_RENAME 'HQMS_VendorItem.VendorID' , 'VendID', 'COLUMN'
EXEC sp_RENAME 'HQMS_History_Vendor_1.VendorID_new', 'VendID_new','COLUMN'
EXEC sp_RENAME 'HQMS_History_Vendor_1.VendorID_old', 'VendID_old','COLUMN'
--run this script after the vendor process to put everything back to normal
EXEC sp_RENAME 'HQMS_ResultsHeader.VendID' , 'VendorID', 'COLUMN'
EXEC sp_RENAME 'HQMS_Vendor_1.VendID' , 'VendorID', 'COLUMN'
EXEC sp_RENAME 'HQMS_VendorInspection.VendID' , 'VendorID', 'COLUMN'
EXEC sp_RENAME 'HQMS_VendorItem.VendID' , 'VendorID', 'COLUMN'
EXEC sp_RENAME 'HQMS_History_Vendor_1.VendID_new', 'VendorID_new','COLUMN'
EXEC sp_RENAME 'HQMS_History_Vendor_1.VendID_old', 'VendorID_old','COLUMN'