Small and medium business | Business Central, N...

How to update dimensions for existing records in business central

(0) Share

Report

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

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

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

DAniele

Was this reply helpful? Yes No
yoheswaran 231 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (2)

Report

hi

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

DANiele

Was this reply helpful? Yes No
Dynamics 365 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
yoheswaran 231 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Karan Mehta 8 on at

Like (0)

Report

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)

And just click on RUN.

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

Was this reply helpful? Yes No
yoheswaran 231 on at

Like (0)

Report

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

Was this reply helpful? Yes No