Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
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...
Suggested answer

Field not Visible on Integration tables

(4) ShareShare
ReportReport
Posted on by AS-31120632-0 39
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
  • Suggested answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar 2,469 on at
    Field not Visible on Integration tables
    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.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 13,316 Super User 2025 Season 1 on at
    Field not Visible on Integration tables
  • Jainam M. Kothari Profile Picture
    Jainam M. Kothari 4,579 on at
    Field not Visible on Integration tables
    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
     

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

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,709 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,679 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans