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

Item Ledger Dimensions

(1) Share

Report

Posted on by MK-18090810-0

Dear All,

Is it possible change Item Ledger dimension values in BC?( Similar to G/L Entry Dimension corrections)

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 74,148 Super User 2024 Season 2 on at

Like (1)

Report

Item Ledger Dimensions

Hi, As several other experts have mentioned, this cannot be done in the standard. In addition, even the G/L Entry Dimension corrections feature is risky.

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-troubleshooting-correcting-dimensions?wt.mc_id=DX-MVP-5004336#changing-dimension-assignments-after-posting

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Valentin Castravet 24,961 Super User 2024 Season 2 on at

Like (1)

Report

Item Ledger Dimensions

As mentioned its not possible, the best way would be to reverse and recreate the transaction or use the item reclass. journal to fix the dimensions. Or get a developer to create a processing report to fix the incorrect dimensions.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
gdrenteria 12,546 Most Valuable Professional on at

Like (1)

Report

Item Ledger Dimensions

Hi

You could rely on a third-party application, check and see if one of them fits your requirements.

Business Apps – Microsoft AppSource

Best

GR
Suggested answer

Ahmed Mohamed Rafik 3,049 User Group Leader on at

Like (0)

Report

Item Ledger Dimensions

Currently, in Business Central, it is not possible to directly change the dimension values on Item Ledger Entries, once they are posted, unlike the G/L Entry Dimension Corrections feature available for General Ledger (G/L) entries. This limitation exists because dimensions in ILEs are tightly integrated with item cost, value entries, and inventory postings, which are affected across multiple tables and transactions.

Post an Item Journal Entry to adjust inventory by reducing the quantity of the item with the incorrect dimensions and adding a new entry with the correct dimensions.

Or Use the Item Reclassification Journal to transfer the item to another location, batch, or with updated dimensions. This creates a new entry with the desired dimensions, essentially moving inventory from one set of dimensions to another.
Suggested answer

KasparsSemjonovs 3,962 Super User 2024 Season 2 on at

Like (1)

Report

Item Ledger Dimensions

No, the dimension change tool only works for G/L entries.

To change them on other tables, You would need to develop a report, that could do that.
Suggested answer

Yi Yong 1,495 Super User 2024 Season 2 on at

Like (1)

Report

Item Ledger Dimensions

Hello,

There is no standard function to change any sub-ledger dimension value at the moment.

Your best bet is to create a codeunit to update them though it is not recommended unless you are aware of other related entries such as Value Entries.