I am using the native Business Central/CRM Integration Tool.
We have a process where we create new customer accounts in CRM (dataverse) and sync this data down to Business Central which creates a new customer record. I want to map the Customer No. field from Business Central back up to CRM. This field mapping is not part of the default mapping.
I have created some code to add the field mapping into the customer table mapping.
The integration table mapping is setup as Bidirectional as I want to pass information both ways. My problem is that when the job queue runs this runs the job from BC->CRM first then CRM-BC, which means that nothing is sent to CRM, but then the account is then synced down to BC fine.
Any further runs of the job do not send the account number back up to CRM. Currently the only ways I can get the number synced to CRM is to either modify the BC customer record, or to perform manual customer record sync form BC. neither of these are a long term solution.
Any help would be much appreciated.
