How to Correct Dimension in Business Central

It is crucial that posted Dimension Values should be correct to ensure the financial reporting gives accurate info. There are few ways to correct a wrongly posted Dimension Values in Business Central, you can do a correction by using the “Reverse Transaction” in the respective ledger entries or creating a correcting entry like using Credit Memo. I would prefer to use the “Correct Dimension” feature in BC to rectify the wrongly posted Dimension Value, as this is faster compared to any suggested steps above and it keeps the risk of users creating errors to the lowest.

However, the Correct Dimension feature only corrects the dimension values in General Ledger level, the change will not flow back to the source document, say if the entry is originated from the AP Posted Purchase Invoice.

Page: General Ledger Entries

In this scenario, the following entries Dimension “Customergroup Code” needs to change from LARGE to SMALL.

1. Select the entries that need to be corrected, then select Correction Dimensions from Entry action.

2. In the Draft Dimension Correction page, select the new Dimension Values that supposed to reflect in the entry in column New Dimension Value Code. Select Run to proceed.

3. Select Run immediately, then select OK to start the Dimension Correction batch job.

4. The new Dimension value has been updated. (You will need to refresh the screen after the Dimension Correction batch job is completed.)

5. Select History of Dimension Corrections to check the history of the change.

Comments

How to Reverse Posted Documents in Business Central

If you need to amend or change a posted documents in Business Central, there are few ways to do it instead of having you to manually create a reversal journal or Credit Memo to rectify a Posted Document. Before you proceed to Correct or Cancel any document that posted in Business Central, you need to identify the origin of the posted document, as the method of cancellation depends on the document type. There are 2 types of documents that posted in Business Central. i. Journals – E.g., General Journals, Purchase Journals, Payment Journals, Sales Journals, Receipt Journals etc. ii. Documents – E.g., Purchase Invoice, Purchase Credit Memo, Sales Invoice, Sales Credit Memo etc. A. A. C orrecting ...

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...

Disposal of Fixed Asset in Business Central

You can perform Fixed Asset Disposal in Business Central in Fixed Asset G/L Journals . The reason for performing fixed asset disposal may be result of several events: i. An asset is fully depreciated and must be disposed of ii. An asset needs to be removed due to unforeseen events (EG., theft) iii. An asset was captured with wrong information and need to be reversed In the following example here, the user has registered the asset in the fixed asset book, and there is depreciation being perform too, but later identified that the asset was registered with wrong date. It will be easier to dispose this asset and capture again using new Fixed Asset ID...

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 use...

Microsoft Dynamics 365 Business Central Self-Help Place

Search This Blog