MS Dynamics CRM Table | Fieldname | Data Type | Remarks |
Account | msa_rapidi_new_account_number__c | Autonumber | Autonumber field to contain a Number to be used as Customer No. in NAV.) Autonumber functionality can be found at crmextensions.com called "Counter" |
Account | msa_rapidi_transferred__c | Date/time | Date/time: field to contain a timestamp that can be used as filter to not transfer the same Account twice and as information of when this Account was transfered from CRM to NAV |
Transfer ITEM01_ITEM
##DBLOOKUP('DESTDS','pricelevel','Name','US Pricelist','pricelevelid')
Example of change to Euro: ##DBLOOKUP('DESTDS','pricelevel','Name','Euro Pricelist','pricelevelid')
Transfer PRICEBOOK_CRM_ADD
##DBLOOKUP('DESTDS','transactioncurrency','currencyname','US Dollar','transactioncurrencyid')
Example of change to Euro: ##DBLOOKUP('DESTDS','transactioncurrency','currencyname','Euro','transactioncurrencyid')
Transfer CONTACT01_CRM_ADD 'Default Price List' is used as default.
##DBLOOKUP('DESTDS','pricelevel','Name','Default Price List','transactioncurrencyid')
Example of change to another pricelist: ##DBLOOKUP('DESTDS','pricelevel','Name','Euro Pricelist','transactioncurrencyid')
NOTE: The pricelist name refers directly to the Price list name in MS Dynamics CRM.