Master data synchronization of price list lines

(1) Share

Report

Posted on by Jim Oskarsson

120

Hi,

I have set up master data synchronization for a customer and it works well for tables that does not contain data that is sometimes deleted but when it comes to price lists and price list lines I have some issues.

The price lists are subject to regular changes, for example price list lines can be removed/deleted and that must be reflected in the company that is pulling the data from the master company.

How can we achieve this?

Thanks,

Jim

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

SL-02010912-0 67 on at

Like (1)

Report

Hi,

Unless this functionality has changed since first available I don't believe you can delete records in the table that pulls the data, the data sync always takes the information from the source table and updates the company from there. See this link below.

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-set-up-data-sync

I would think that to delete records in the subsidiary table you would need to develop an extension to handle this.

Hope that helps,

Shauna

Was this reply helpful? Yes No
Jim Oskarsson 120 on at

Like (0)

Report

Hi @SL-02010912-0,

Thanks for your answer, now I know that it is not possible to delete records in the table that pulls the data. We will have to build an addon to solve that.

I now manually deleted all records in the reveiving table (price lines) and started the syncronisation again but then I get the following error message:

"The Price List Line record cannot be updated because it is coupled to a deleted record."

What should be done to solve that?

Thanks,

Jim

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (0)

Report

Hi

I don't quite understand the question, is the problem the frequency with which the data is updated? If you want greater agility, you can either review the configured job queues, or find another way to synchronize them, it could be through APIs.

Best

GR

Was this reply helpful? Yes No
Ramiz 597 on at

Like (0)

Report

Hi @Jim Oskarsson

Try deleting the coupling and try again.

Was this reply helpful? Yes No
Verified answer

SL-02010912-0 67 on at

Like (0)

Report

Hi,

You may need to delete the coupling before trying to sync for that table. See link below.

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-how-to-couple-and-synchronize-records-manually

Let me know if that helps,

Shauna

Was this reply helpful? Yes No