Small and medium business | Business Central, N...

Master data synchronization of price list lines

(1) Share

Report

Posted on by Jim Oskarsson

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

All responses (5)

Answers (0)

Suggested answer

SL-02010912-0 62 on at

Like (0)

Report

Master data synchronization of price list lines

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
Ramiz 368 on at

Like (0)

Report

Master data synchronization of price list lines

Hi @Jim Oskarsson

Try deleting the coupling and try again.
gdrenteria 12,750 Most Valuable Professional on at

Like (0)

Report

Master data synchronization of price list lines

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
Jim Oskarsson 41 on at

Like (0)

Report

Master data synchronization of price list lines

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
Suggested answer

SL-02010912-0 62 on at

Like (1)

Report

Master data synchronization of price list lines

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