bojimuncher
IS-IT--Management
Heya,
Our company has an optional field created under AR for "BusinessType". We would like this optional field in CRM so we can create groups based on this field for mass maling, but unfortunately I don't know enough about database administration to make it happen. I guess I am looking to get the 'VALUE' field of table ARCUSO in my accpac database into the Company table in my CRM database where OPTFIELD = BUSTYPE and ARCUO.IDCUST = Company.Comp_IdCust. But im not sure how to write the code for it.
Even if its just a static solution that means just having whatever data is in my Accpac database now being sent over would be good enough for now.
SQL Server 2005, CRM 6.2, Accpac v5.6pu2
Thanks,
Stan
Our company has an optional field created under AR for "BusinessType". We would like this optional field in CRM so we can create groups based on this field for mass maling, but unfortunately I don't know enough about database administration to make it happen. I guess I am looking to get the 'VALUE' field of table ARCUSO in my accpac database into the Company table in my CRM database where OPTFIELD = BUSTYPE and ARCUO.IDCUST = Company.Comp_IdCust. But im not sure how to write the code for it.
Even if its just a static solution that means just having whatever data is in my Accpac database now being sent over would be good enough for now.
SQL Server 2005, CRM 6.2, Accpac v5.6pu2
Thanks,
Stan