RE: Business Central CRM Integration - Map AccountID to Customer No.
"Field Mapping" indicates that you want the value to be the same in both databases. That is not the case for AccountID and CustomerNo fields. (AccountID is a guid, and CustomerNo is a Code field.)
Start by setting up the Integration Table Mapping and then setup the Field Mapping for fields that you want to have the same data (like Address or Email).
If you have data in both databases, then before you can start using the integration, you'll need to run some custom code to couple records that you want coupled. Once the records are coupled, then the integration will keep them in sync.
Any records that are not coupled will be treated as new records that need to be inserted into the other database.
For example... if CRM has record A, B, and C while Business Central has records B, C, and D. You'll want to be sure to couple records B & C. When you turn on the integration, record A should get inserted into Business Central (and coupled to record A in CRM) and record D should get inserted into CRM. (This assumes that you have BiDirectional integration. If you are only going one direction then new records would only get inserted in that direction and any un-coupled records in the destination database will be ignored.)
Hope that helps!
