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

Item ledger entry value is different in general ledger entries

(1) Share

Report

Posted on by Alejo Bohorquez

Hello, I have the following case:

I have a document that is an inventory adjustment and its value has a difference between the item ledger entries and the general ledger entries:

Value in item ledger entries

Value in general ledger entries

The initial general ledger entries values were 3.634.951,89, then we did a revaluation for the item ledger entry however the value wasn't updated in our g/l entries.

I'd appreciate if anyone knew a possible cause of this case and how to solve it.

Regards,

Alejandro B

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, as far as I know this does not update the posted general ledger entries, it will generate new details which you can search for value to find out.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (0)

Report

Check the Value entries.

There can be several Value entries created and You see the total Sum of Cost Amount on all related Value entries in the Item Ledger Entry, but in G/L entries, You will see 2 entries for each Value entry (Debit/Credit).

In the Value entries, check the columns Cost Amount (Actual) and Cost Posted to G/L. These should match, so be sure the G/L has the correct balance/value in it.

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

Like (0)

Report

Hi

You must check another field in the ValueEntry table.

BR

GR

Was this reply helpful? Yes No
Alejo Bohorquez 93 on at

Like (0)

Report

Thanks for your answers. I checked the Cost Amount (Actual) and Cost Posted to G/L in the value entries and both fields match.

Do you know if there is a way to reconcile with G/L entries?

Regards,

Alejandro B

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (1)

Report

my feeling is you might be comparing the cost of item with the revenue amount. for example, item cost is 10 and you sell it for 100.

on g/l entries it shows 100, but on item ledger entry, the cost shows 10.

you need to find or add the corresponding column to the item ledger page and find out what account is posted to in the gl entry before comparing.

or you can compare value entry with gl entry.

still you need to make sure the you are comparing the amount with the correct entry.

hope it helps

Jun Wang

Was this reply helpful? Yes No
Suggested answer

Yasas 55 on at

Like (0)

Report

Hi,

Did you run the Adjust Cost - Item Entries after posting the revaluation journal? If you didn't, please run the Adjust Cost - Item Entries.

BR,

Yasas.

Was this reply helpful? Yes No