Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding an Accpac optional field to CRM

Status
Not open for further replies.

bojimuncher

IS-IT--Management
Jul 10, 2009
21
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top