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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Field not Visible on I...
Small and medium business | Business Central, N...
Answered

Field not Visible on Integration tables

(4) ShareShare
ReportReport
Posted on by Aryan 194
1 - I have done the integration Of business central with the Dynamics 365 Sales app by using business central Standard dataverse connection setup and integration setup, it is working fine but i need to add some new fields in the item-Product Integration table so i have click on new fields mapping but there i am unable to find the filed which is standard "Item Category Code (5702)" Some customer and standard fields are available by default  when we have to do new table mapping  but some are not available why is that and how can get these fields here to integrate it with CRM fields , same thing with the CRM table. See the first Screen shot for more clear image.

 2 - sometimes data of table sync by automatically and some time we need to manually synchronize it suppose I have created new item, customer and contact or any other data sometimes it sync automatically in few minute but some times we need to manually sync it by setup coupling and create new .

3- my sales order is coming from CRM to bc so they are visible in the sales order -dynamics 365  page in bc so there we need to manually click on create in Business central then it gets created in bc or we can do something to is will gets created in bc automatically . see the screenshot  2 for more clear picture.

4 -  In same pages that are being synchronize there there synchronize option are unclickable or we can do anything with them ??? see screen shot 3
 
5 -  so I have one field sin bc description that is mapped with CRM name field in item but i want to change its mapping to Fg item in bc to name in CRM so as  to do that i have deleted the item and redeploy it by add new fields and click on reset to default integration setup so why its showing showing same  fields two times .  see screen shot 4 
   
 
    
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,641 Super User 2025 Season 2 on at
    Hello,
     
    To address your issues with Business Central and Dynamics 365 Sales integration: For adding new fields like "Item Category Code (5702)" to the integration table, you may need to customize the table mappings. Synchronization can be automatic or manual, depending on your setup and job queue configurations. To automate sales order creation from CRM to Business Central, consider using workflows or Power Automate. If synchronization options are unclickable, check permissions and record states. For changing field mappings, ensure old mappings are fully deleted to avoid duplicates.
     
    For Adding New Fields to Item-Product Integration Table
     
    Automatic vs. Manual Synchronization
     
    Automatic Creation of Sales Orders in Business Central
     
    Unclickable Synchronize Options
     
  • Verified answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 21,048 Super User 2025 Season 2 on at
  • Verified answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar 7,537 Super User 2025 Season 2 on at
    Hi,
     
    I hope the link below is helpful. Additionally, feel free to explore other content from Saurav Dhyani. he has produced informative videos on CRM and Business Central integration
     
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,651

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 808 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 718 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans