CRM 2011 and GP synchronization error "View or function '' is not updatable because the modification affects multiple base tables".

Hi Experts,

 

We are using dynamics crm 2011 and Microsoft GP and they are integrated with Scribe Insight. From the past 10 days the synchronization stops.

 

We basically post sales orders to GP and then from GP we post those orders as Invoices in CRM.

 

When we run the job it fails to insert and throws the error "View or function '' is not updatable because the modification affects multiple base tables".

 

After doing RND on it we created the triggers in CRM View and then it doesn't allow to insert because the Invoice number is not present.

 

What is the workaround of it please help.

 

Thanks,

Ebad

(1) Answer

Login