Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) econnect sp throwing e...

econnect sp throwing error while updating a customer

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All, I have two company databases.I need to synchronize the customer information ,ie if I create/update/Delete a customer record in one database it should create/update/Delete the customer in other database. I have a trigger on RM00101 for INSERT,UPDATE AND DELETE which will call the econnect procedure. For INSERT AND UPDATE the trigger will call taUpdateCreateCustomerRcd . For delete the trigger will call taDeleteCustomerRcd The insert and delete is working fine for me. But while updating a record in the customer maintenance window, throws the message without clearing the window even though the tables were getting updated. " This customer record has been updated since you opened this window.Changes won't be saved." The flags passing in the procedure are @I_vUseCustomerClass = 0, @I_vCreateAddress = 1, @I_vUpdateIfExists = 1, @I_vRequesterTrx = 0 please help me to solve this problem.

*This post is locked for comments

All responses (1)

Answers (0)

David 'Mitch' Clauson on at

Like (0)

Report

Re: econnect sp throwing error while updating a customer

Hi Ranjith,

I understand that you have written a trigger on and update to the RM00101 table that when an update is done it will fire the trigger which in turn calls the econnect stored procedure. I am thinking that when the trigger fires and calls eConnect procedure to update the RM00101 in the other company, then the trigger on the RM00101 on the other company is firing and updating the RM00101 in the company you are currently in.

What I would like you to try is to turn off any triggers on the RM00101 table on the other company that you are synchronizing to and see if that gets rid of the error or if it still occurs.