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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Effect of change global dimention

(4) ShareShare
ReportReport
Posted on by 42

Hi, and thank you in advance.

I am in the process of changing our global dimension from Purchaser to Area. I have tested this change on G/L Entries, Purchase Orders, and Purchase Invoices, and I did not observe any changes in the underlying data. However, I noticed that some reports reflect the new dimension in their filters. Have you encountered any data changes or experienced any reports failing after making such a change? Also, could you explain what exactly Business Central does when changing a global dimension, as shown in the attached screenshot? Thank you!

I have the same question (0)
  • Verified answer
    Sohail Ahmed Profile Picture
    11,150 Super User 2025 Season 2 on at

    When you change a Global Dimension in Business Central (as shown in your screenshot), the system updates the field names used for Global Dimension 1 or 2 across all relevant tables, including historical data (e.g., G/L Entry, Customer Ledger Entry, etc.).

     

    Key points:

    • Underlying data values don’t change, only the dimension field name mapping changes (e.g., from "Purchaser" to "Area").
    • The job updates all tables where Global Dimensions are stored (see Log Entries in your screenshot).
    • Reports and pages using Global Dimension 2 will now show the new caption ("AREA") instead of the old one ("Purchaser").
    • If reports or extensions refer to the old dimension name hardcoded, they might break or behave unexpectedly.
     

    ✅ Mark this answer as verified if it helps you.

  • Verified answer
    Mansi Soni Profile Picture
    8,911 Super User 2025 Season 2 on at
    Hello,

    1. Does changing a global dimension modify existing data?

    No, changing a global dimension (e.g., from Purchaser to Area) does not modify existing data. It only changes which dimension is treated as global for new entries. 

    2. Why do some reports reflect the new dimension after the change?

    Reports and filters tied to Global Dimension 1 or 2 automatically reflect the new assigned dimension. That’s because the system uses those global slots for filtering and displaying data, so once changed, any report referencing those fields will now show the new dimension.

    3. Have there been any data changes or failed reports due to this?

    By default, no data changes occur, but reports relying on the previous global dimension may fail or show incomplete data unless reconfigured. Custom reports or analysis views may need to be reviewed and updated to align with the new dimension.

    4. What exactly does Business Central do when changing a global dimension?

    It reassigns Global Dimension 1 or 2 to a different dimension code. This impacts new data entries only, and existing entries won’t be updated unless you run the Change Global Dimensions tool, which can optionally update historical data but must be run carefully with backups.

    Hope this will give you some hint!

    Regards,
    Mansi Soni
  • Suggested answer
    Andrés Arias Profile Picture
    4,190 Super User 2025 Season 2 on at
    Hello,

    The following links might help you understand the process.
     
     
    When you change a global or shortcut dimension, all entries posted with that dimension are updated. Because this process may be time-consuming and can affect performance, two different modes are provided to adapt the process to the size of the database.
     
    I hope you can help.

    Regards,

    Andres
  • Verified answer
    YUN ZHU Profile Picture
    95,763 Super User 2025 Season 2 on at
    Hi, just add some info. If you are interested in the standard logic behind it, you can also directly view the standard code.
    Codeunit "Change Global Dimensions"
     
    Thanks.
    ZHU

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…

Neeraj Kumar – Community Spotlight

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

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,116

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 764 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 635 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans