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

Announcements

No record found.

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... / How to update dimensio...
Small and medium business | Business Central, N...
Suggested Answer

How to update dimensions for existing records in business central

(0) ShareShare
ReportReport
Posted on by yoheswaran 231

Hi everyone,

   like posted sales invoice, there in subform i added dimension fields and action in a customized page name - (eg: posted Sales Request ), if i create a new record and post using dimension value it automatically updating on my customized table and screen (eg: posted Sales Request ). how to update dimension for existing records. is there any codeunit available i need to update the records for all company.

Thanks in advance,

Categories:
Dynamics 365 Business Central
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,427 Super User 2026 Season 1 on at

    hi

    you need to develop a customisation using the functions of this codeunit 408 DimensionManagement

    DAniele

  • yoheswaran Profile Picture
    yoheswaran 231 on at

    Thanks for the response Daniele, the dimension concept is working fine for current transaction, i need to update  for existing transaction.

    I added dimension action in existing customized page like posted sales request, while im posting current transactions the records updating from subform to dimension set entry table, but for previous transactions it not updating is there option to update the same process for all companies.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,427 Super User 2026 Season 1 on at

    hi

    in the General Ledger Entries there is this new function to correct dimensions on existing transactions

    pastedimage1672129721721v1.png

    DANiele

  • D365BC_AmanKr Profile Picture
    D365BC_AmanKr 284 on at

    Hello Yoheswaran,

    As per Microsoft base, you can update the Dimension only for general Ledger Entries.

    But if you want to update the dimension on remaining Posted Document, you need to do Customization for this.

    Ask your developer to do this.

    Many Thanks

    Aman

  • yoheswaran Profile Picture
    yoheswaran 231 on at

    Aman i tried the above process of updatePerCompany trigger in codeunit its not working.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 235 User Group Leader on at

    This concerns me as you are running the risk of your data in posted sales invoices not making the data in the general ledger with absolutely no audit trail.

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    I share the concerns Kim have here. You should be really careful when you manipulate the dimension on posted data because unless you are very sure about what you are doing you run a big risk of corrupting your data integrity. And your auditors might not be very happy if the sales documents have one set of dimensions and the G/L and CLE and Item ledger entries have other sets of dimensions.

    So in general you should avoid manipulating dimensions. If you have used the incorrect dimensions you should correct it by issuing credit memo and new correct invoice.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 103,712 Super User 2026 Season 2 on at

    Hi, I only recommend that you use the standard functions to modify the Dimension of posted documents.

    Dimension corrections (for G/L Entries)

    https://yzhums.com/10655/

    This may cause data inconsistency if you customize it. For example, if you want to modify the dimensions of Posted Sales Invoice, it is technically feasible. But you need to consider all associated data, and these associated tables are different depending on the type of row.

    pastedimage1672184961956v1.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Karan Mehta Profile Picture
    Karan Mehta 10 on at

    Hello, Thank you for raising this and i'd second to Daniele Incalza.

    Microsoft has given this option in the base functionality iteself.

    You'll have to go to General Ledger Entries Page for that (Please refer to screenshot below)

    pastedimage1672209369495v2.png

    pastedimage1672209433148v3.png

    And just click on RUN.

    It also has the option to see the History of Dimension Correction. 

  • yoheswaran Profile Picture
    yoheswaran 231 on at

    Thanks you for the reply i did that by creating a patch and wrote some codes

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 741 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 514 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 336 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans