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

Item Revaluation still using old G/L account after posting group update

(4) Share

Report

Posted on by Jinal P.

324

Hi everyone,

I posted a few inventory transactions earlier with the wrong Gen. Product Posting Group and Inventory Posting Group. I’ve now corrected the setup, and all items currently have the correct posting groups.

However, when I try to adjust cost using the Item Revaluation Journal, the system is still posting to the old G/L account instead of the updated one.

Is there any way to make the revaluation use the new/correct G/L accounts, or how can I fix this properly?

Any guidance would be appreciated. Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Teagen Boll 2,323 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Often (most cases) when you make these changes it wont retroactively change the posting groups on already posted transactions.

Few options:

You need to either add those old posting groups with the correct G/L accounts and then run the revaluation journal. You dont need to change the master data such as the items. You just need to add the Gen. Product Posting Group and Inventory Posting Group back and update the G/L Accounts for them.

You can get a developer to change the posting accounts on those transactions. Could be costly, timely and usually requires work with a partner.

There are also some tools like the data editor that let you change those records yourself but I highly caution any usage of these unless you are a super user because you could irreparably screw up transactions. See a data editor tool here: Table Data Editor for Business Central - if you take this approach you should test in a sandbox first and validate everything is okay then you can replicate in production.

Best,

Teagen Boll

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,624 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

This likely stems from the fact that Item Revaluation is automatically calculated from Item Ledger Entries. If the original posting group is not used it will lead to data inconsistencies.
I personally don't recommend forcibly modifying the posting group through customization.
You could try creating a new item directly.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,704 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Unfortunately, the best resolution is to reverse them and doing anything else will highly likely affect the cost.

Depending on the volume, you can consider passing monthly journal entries to reclass them to the correct G/L Account.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 26,487 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

How to Correct Item Costs on a Posted Purchase Invoice in Dynamics 365 Business Central | Tech Tip

Fix Inventory Valuation in Dynamics 365 Business Central

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

RockwithNav 9,113 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

This will have an impact down the line, especially in 6–8 months when you have higher volumes and need to track costing and changes. You should not change the GL accounts in the middle and that too changing from behind. The ideal and simplest approach is to bring the inventory down to zero and then block the item. After that, create a new item with the same name, assign the correct GL accounts, and reload your inventory.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 15,595 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Revaluation won’t really “move” old entries to new posting setup just because you changed the item card now. The G/L posting for inventory cost is created from value entries, and Microsoft notes inventory cost posting is based on combinations like Inventory Posting Group, Gen. Business Posting Group, and Gen. Product Posting Group tied to those entries, so if the original transactions were created with the old groups, a later Item Revaluation Journal can still hit the old accounts. In practice, the clean fix is usually not revaluation alone, but correcting the setup and then using a proper correction approach for the wrong historical postings, typically with manual G/L reclass/reconciliation or by reversing and reposting if possible, then running Adjust Cost and Post Inventory Cost to G/L as needed. So: no, changing the item’s current posting groups does not automatically make past revaluation use the new accounts.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No