Start a conversation

Table details - Microsoft GP Vendor Combiner Error

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'


Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Jaydel Gluckie

  2. Posted
  3. Updated

Comments