Skip to main content

How to Correct Dimensions in Business Central

 It is quite common that users might find out that some entries might mistakenly charge to wrong dimension, which will cause inaccurate financial reporting and analysis. The classic method of rectifying this type of error is to create a manual general journal entry to reverse it. One of the popular features which available in Business Central is “Correction Dimension” where it allows you to correct the dimension values in General Ledger Entries age in a simple way.

  

Important Note 1: Dimension Correction apply only G/L entries. They do not change the dimensions that assigned in other ledgers for the same transaction. There will be mismatch between the dimensions assigned in the general ledger and the sub-ledgers.

Important Note 2: If you need to do Dimension Correction in a large scale, say more than 100 transactions, it is advised to schedule or perform during the non-peak hours as it may cause Table Locking during posting of other transactions by other users.

 

Page: General Ledger Entries

 1.       Select the entries that need to perform Dimension Correction. You may select more than one entry to perform Dimension Correction.



2.       Next, select “Correction Dimensions” from the Entry action.


3.       In the Draft Dimension Correction page, you can enter the information in Description about the change so that other people might use this information to understand what was done.

4.       Next, choose the dimension value code that you need to change in New Dimension Value Code.

5.       You can choose the Validate Dimension Changes to validate the Correction.

6.       Once validation complete, you may proceed to select Run to perform dimension changes on the selected entries.


7.       You may select “Run immediately” if the entries are just few. If more than 100 transactions, it would be advised to schedule the dimension correction during the non-peak hour.


8.       To verify whether the change of dimension values is successful, you can check the status in Dimension Correction page.



9.       Check the status of the correction entries.



10.       You can click on the Entry No.  or View action to review the changed detail.






In case there is Dimension that you don’t allow other people to change, you can set up the block for changes in Dimension Correction Settings page.

Page: Dimension Correction Settings



Select the Dimension Code that you don’t allow other people to change.





Do you have question on BC that you think I can help?
Drop me an email at "Hello365businesscentral" at Gmail, I will try to answer if I can. 






Labels:
Location: Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

Comments

Post a Comment

Popular posts from this blog

Start Here

Something in Business Central not behaving? Work down this page. Most things are answered here already — and if they aren't, the last section tells you exactly what to send me so we can skip three rounds of questions. The sixty-second checks These four clear most of what reaches me. Try them before anything else. Hard refresh the page. Hold Ctrl and press F5. A normal refresh reloads the cached copy; this one doesn't. Check which company you are in. The name is at the top of the screen. Posting into the wrong entity is easier than it sounds. Open it in a private window. If it works there, the problem is cache or a browser extension, not Business Central. Try a different browser. If Edge fails and Chrome works, that alone narrows it down enormously. Part 1 — Something on screen isn't working A page won't load, a button does nothing, something has gone missing, or an error stops you posting. Start here if Business Central itself is misbehaving. A...
Post a Comment
Read more

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...
Post a Comment
Read more

Exchange Rate Adjustment in Dynamics 365 Business Central: Unrealized Forex Gain/Loss

Overview Business Central's Exchange Rate Adjustment revalues your open foreign-currency documents and bank balances at month-end and posts the unrealized foreign exchange gain or loss for you. You enter the month-end rate once, run one batch job, and BC handles every customer, vendor and bank account in that currency. Why it matters: under MFRS 121, foreign-currency monetary items such as receivables, payables and bank balances must be translated at the closing rate at each reporting date. The difference from the amount originally booked is an unrealized gain or loss that belongs in that period's P&L. Which version are you on? In newer versions of BC the batch job is called Exch. Rate Adjustment and includes Preview Posting, Adjust per entry and the Exch. Rate Adjmt. Ledger Entries page. Older versions use the Adjust Exchange Rates report, which works the same way but without those options. Search for "exchange rate" in Tell Me to see which one your co...
Post a Comment
Read more