Master data synchronization of price list lines

(1) Share

Report

Posted on by Jim Oskarsson

152

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)

Sort by

Suggested answer

SL-02010912-0 67 on at

Like (1)

Report
Copy link

Link copied!

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 152 on at

Like (0)

Report
Copy link

Link copied!

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... 26,080 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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