CRM Connector (2011).

thjens45
thjens45 Member Posts: 5
edited 2012-01-13 in NAV Three Tier
Hi everbody.
I've setup the connector and everything seems to be working. Data is synced both ways. However, there's something I don' get. In the mapping, you setup that "No." (customer no) equals "Account Number".
When you make a new Account in CRM, you have to enter a account number. But what if you enter a account number that already exists in NAV? Sure, you will get an error in the log, but thats not good enough. 50 sales pepole might enter new accounts everyday. They might enter the same account number. How is that handeld?
The user can't choose not to enter anything, the field is mandatory.

So, the question is how can I let NAV take care of granting the new account number? If NAV gets a blank customer no., the normal logiq of the triggers will generate a new number. That means the mandatory attribute of the account number in CRM must be shut of somehow.
I've tried to fiddle around with the new triggers in codeunit 1 (onDatabaseInsert, onDatabaseModify) but renaming primary key only results in errors since NAV is in the middle of and update.

Any ideas?

Thanks.

Best regards,
Thomas Jensen.
Norway.

Comments

Categories