Skip to main content

Notifications

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... / Correct dimension valu...
Small and medium business | Business Central, N...
Suggested answer

Correct dimension values on G/L Entry (from 1 to multiple)

(1) ShareShare
ReportReport
Posted on by amoreira173 3
Hello,
 
I'm having an issue on more than 1 customer regarding correcting dimensions after posting the document.
 
EXAMPLE:
* I posted a document with one line, amount=1.000 (let's say on G/L Account 6221) - dimension REGION = North
 
After posting it, I got the information that  those 1.000 must be divided by two different regions (North= 800 | South = 200).
I only got this info after the accounting period was closed.
 
Is there a way to correct it? Or a workaround that does that?
Categories:
Dynamics 365 Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 85,455 Super User 2025 Season 1 on at
    Correct dimension values on G/L Entry (from 1 to multiple)
    Valentin is right, this feature can only change the Dimension, not the amount. If you still need to adjust the amount, you need to reopen the closed accounting period to adjust it, which I personally do not recommend.
     
     
    Thanks.
    ZHU
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 28,288 Super User 2025 Season 1 on at
    Correct dimension values on G/L Entry (from 1 to multiple)
    If one entry for $1000 with the dimension North exists, then I don't believe Dimension Corrections can be used to change the dimensions so $800 are for North and $200 are for South. Dimension Corrections can only be used to change the dimension on the entire $1000 amount. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 85,455 Super User 2025 Season 1 on at
    Correct dimension values on G/L Entry (from 1 to multiple)
    Hi, I think you can try the Dimension corrections (for G/L Entries) feature, which will not add new GL Entries and will not cause any problems when you reopen a closed account period. (Please test it in a test environment of course)
     
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 28,288 Super User 2025 Season 1 on at
    Correct dimension values on G/L Entry (from 1 to multiple)
    I don't believe there is a way to correct it without posting in the closed accounting period. However, Business Central doesn't have a hard accounting period close so you can simply open the posting date restrictions and post in the closed period. Its fine because the fix is just an in and out, the overall amounts are not changing. You have a few options for the correction:
     
    1. reverse the transaction and repost it with the correct dimension split.
    2. use a general journal to book an adjusting entry to re-allocate the dimension split i.e. credit account 6221 for $1000 with the dimension north and debit 800 to north and 200 to south.
    3. instead of using a general journal you can use the recuring general journal with the Recurring Method BD Balance by Dimension. More info - https://community.dynamics.com/blogs/post/?postid=74cd475f-baf9-43a6-a85f-5a7eb9e431fb
     

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans