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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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... / Business Central- Addi...
Small and medium business | Business Central, N...
Suggested Answer

Business Central- Adding Columns to Available Lit to Add to Personalized View

(3) ShareShare
ReportReport
Posted on by BO-08082251-0 6
Hi,
I have two columns that I want to add to a GL view.   When I edit the Business Central view in Excel, I can see the columns are already there but  I cannot seem to get them to appear back in Business Central. I am trying to refresh, publish, update and everything else and still have no luck.   Any ideas?
 
 
When I go back to Business Central the fields are not in my GL report or in the available list of fields when I go to personalize.  
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 239,831 Most Valuable Professional on at
    Moved from Integration, Dataverse, and general topics forum to Small and medium business | Business Central, NAV, RMS forum.
  • Suggested answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 2,890 Super User 2026 Season 1 on at
    Hi,
     
    For Business Central Edit in Excel add-in you will be able to see many fields and add it in the excel which are not available in the Business Central page view. This is standard Business Central.
    Though you can see it in the Excel and can add there but it will not directly show in Business Central Page or sometime they do not even show in the Personalize option.
     
    For this there are two options which can help you.
    1- Customize pages and roles to bring the field which cannot be added through Personalization.
    2- Customize Pages through AL Development.
     
    You can refer to following link:
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,423 Super User 2026 Season 1 on at

    Hi,

    It sounds like you're working with the Excel Data Connector and trying to sync additional columns back into Business Central's GL view. If the columns appear in Excel but not in Business Central, here are a few things to check:

    1. Verify Field Availability: Ensure the fields you're trying to add are actually exposed in the page object you're personalizing. Some fields may be available in the data source but not exposed in the UI by default.

    2. Use Page Inspection: In Business Central, use Ctrl+Alt+F1 (Page Inspection) to check if the fields exist on the page and what their source is.

    3. Check Permissions: Make sure your user role has permission to view those fields. Sometimes, field visibility is restricted based on user profiles.

    4. Try a Custom Extension: If the fields are not available for personalization, you might need a developer to create a page extension to expose those fields.

    Let me know if you'd like help walking through any of these steps!

    Best regards,
    Daniele

  • Suggested answer
    Sumit Singh Profile Picture
    Sumit Singh 11,799 Super User 2026 Season 1 on at
    You're editing a GL view using the Excel Data Connector (Design interface) in Business Central. The fields you want (e.g., Running Balance, Source Currency Amount) are visible in the Available Fields list but not in the Selected Fields list. This means they haven’t been added to the view yet.
    Why They Don’t Appear in Business Central:
    1. Excel Design Changes Are Not Automatically Synced: Editing the view in Excel via the Data Connector doesn't push changes back to Business Central unless the design is explicitly saved and published.
    2. Personalization Limitations: If the fields are not part of the selected dataset in the page design, they won’t show up in the personalization pane.
    3. Data Connector vs. Page Design: The Excel Data Connector works on the underlying data source, but Business Central views (like GL reports) are based on page objects. If the page object doesn’t expose those fields, they won’t appear even if they exist in the data source.
    Precise Steps to Fix:
    1. Add Fields to Selected Section in Excel Design:
      • Move the desired fields (e.g., RunningBalance, SourceCurrencyAmount) from Available Fields to Selected Fields.
      • Save and publish the design.
    2. Verify Page Object Exposure:
      • Ensure the page (e.g., General Ledger Entries) includes these fields in its source table or extension.
      • If not, a developer may need to extend the page to expose those fields.
    3. Refresh in Business Central:
      • After publishing, go back to Business Central and refresh the view.
      • Check if the fields now appear in the personalization pane or report.
    Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
    Mark the Answer as Verified if this is Helpful.
     

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 Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May 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,869 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,182 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,109 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans