Master Data Integration - Sales Prices

(2) Share

Report

Posted on by abz_mdcnordic

Hi,

I’m using Master Data Integration to synchronize the Chart of Accounts along with several other tables.

I’d also like to synchronize the Sales Price table. However, when I try to create a new record for Sales Price in the Synchronization Table, the field mappings do not populate automatically.

Could you please advise on how to resolve this?

Do we need to customize anything to have the sales price sync?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Pallavi Phade 3,041 on at

Like (1)

Report

Master Data Integration - Sales Prices

Namaste @AZ-18111138-0

Below is link for standar tables ready for mapping with Dynamics 365 CRM and BCE .

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-synchronizing-business-central-and-sales#standard-table-mapping-for-synchronization

Also check integration Table Mappings , system has by default mappings . You need to map manualy fields . Cehck the dataverse Table . Set the mappings

Warm Regards

Pallavi Phade

Was this reply helpful? Yes No
Verified answer

Jainam M. Kothari 14,364 Super User 2025 Season 2 on at

Like (2)

Report

Master Data Integration - Sales Prices

Hello,

Sales Price is not included in Business Central’s default Master Data Integration setup, so when you add it as a synchronization table, field mappings don’t auto-populate because there’s no predefined mapping for that table.

To enable synchronization, you must manually configure the field mappings (e.g., Item No., Sales Type, Sales Code, Unit Price) and, if needed, add related tables.

In most cases, customization via AL code or alternative methods like configuration packages is required to handle complex pricing logic and automate mapping.

Was this reply helpful? Yes No
abz_mdcnordic 7 on at

Like (0)

Report

Master Data Integration - Sales Prices

Thank you @Pallavi Phade, for the response.

I’m not referring to Dynamics 365 integration with Business Central.

I’m working with Master Data Integration, which is typically used when you have multiple companies within the same Business Central environment and want one company to act as the master source of data. For example, when you update the Chart of Accounts in the master company, those changes can automatically synchronize to the other companies.

By default, Master Data Integration supports a number of standard tables. However, the Sales Price table is not included as one of the supported tables, which is why I’m unable to get the field mappings to populate automatically.

Kind Regards,

Was this reply helpful? Yes No
abz_mdcnordic 7 on at

Like (0)

Report

Master Data Integration - Sales Prices

Hi @Jainam M. Kothari,

Thanks for the response.

I will explore the option to add the mapping using the Configuration package; I never did this part.

Kind Regards,

Was this reply helpful? Yes No