Copy Customer Account from one LE to Another

(2) Share

Report

Posted on by Elonna

Hello,

We have just brought on another legal entity and we want to be able to copy new customer accounts from LE to the new LE as they are created.

We use dual write, so we can not use cross company data sharing. We did turn off dual write and we did an initial push from one LE to the other using CCDS.

We are using the Data Management copy once per week, but because it takes over 7 hours to run we can not run it more often.

What we'd like to do is insert or update the customer account at the time it is created or updated in the primary LE.

I have been looking at an extension class on the CustTable, but it does not seem that we can update the dataareaid through code.

Does anyone have any input on how this might be able to accomplished?

Thank you.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (11)

Answers (1)

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

what do you mean you can't update dataAreaId through code? can you share with us what you tried?

i think you should use buf2buf(source, target) with changeCompany() then insert

Was this reply helpful? Yes No
Elonna 49 on at

Like (1)

Report
Copy link

Link copied!
I was trying to create an on_inserted event:

public static void CustTable_onInserted(Common sender, DataEventArgs e) { CustTable ct = sender as CustTable; ct.DataAreaId = 'NewDataAreaID'; ct.insert(); }

And it tells me that DataAreaID is read only and can not be updated.

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Ok did u try my suggestion?

Was this reply helpful? Yes No
Elonna 49 on at

Like (1)

Report
Copy link

Link copied!

I am trying to figure out how to use the changecompany and buf2Buf. I will let you know if I get it to work.

Thank you.

Was this reply helpful? Yes No
Elonna 49 on at

Like (0)

Report
Copy link

Link copied!

It seems like this should work, but am getting a duplicate record error. It's like the commit on the original account isn't happening until after the oninserted event happens so the company is the same for both. Yet neither record is actually being inserted.

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

can you show us the code and the error?

maybe it will not work with buf2buf, instead u will need to use change company then fill the fields one by one

Was this reply helpful? Yes No
Elonna 49 on at

Like (0)

Report
Copy link

Link copied!
Layan Jwei

When I debug, it shows the dataareaid set to the new company code, get two duplicate record error messages, well it says the record already exists, but it doesn't.

I thought the onInserted event happened after the initial insert of the record but that record is not in CustTable either.

Thank you for your input.

public static void CustTable_onInserted(Common sender, DataEventArgs e) { CustTable ct = sender as CustTable; CustTable CustTableTarget; changecompany('NewCompanyID') { CustTableTarget = null; ttsbegin; buf2Buf(ct,CustTableTarget); CustTableTarget.insert(); ttscommit; } changecompany('OriginalCompanyID'){} }

Was this reply helpful? Yes No
Elonna 49 on at

Like (0)

Report
Copy link

Link copied!

Sorry, forgot error message, but this account does not exist already:

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,430 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you sure tht thıs doesn't exıst? Dıd you control form the form or the table? Please check from the table level.

Was this reply helpful? Yes No
Verified answer

Elonna 49 on at

Like (0)

Report
Copy link

Link copied!

BillurSamdancioglu,

I appreciate your response, but I do not understand what you mean.

I'm sorry.

Was this reply helpful? Yes No