web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Master Data Integratio...
Small and medium business | Business Central, N...
Answered

Master Data Integration - Sales Prices

(2) ShareShare
ReportReport
Posted on by abz_mdcnordic 7

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)
  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 3,041 on at
    Master Data Integration - Sales Prices
     
    Below is link for standar tables ready for mapping with Dynamics 365 CRM and BCE .
     
    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
  • Verified answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 14,358 Super User 2025 Season 2 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,907

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,169 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,977 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans