web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Value Entry No_ and G_L Entry No_ missing from G_L - Item Ledger Relation

(0) ShareShare
ReportReport
Posted on by
Hi,
 
I have missing Entries No in the $G_L - Item Ledger Relation table which I could not figure out why. I know for a fact that the transactions were recorded in both Value Entry and GL Entry table by filtering out the sales amount and product code and the posting date. The issue is that there was no records for them in the relation table so I cant match the Value Entries to the GL Entries. This only occurs to the new brand that we recently set up in Business Central. I am not sure where did we set up wrong to get this error. If anyone has experienced this and know the solution, please share. I would appreciate it. 

Thanks,
I have the same question (0)
  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,764 Super User 2025 Season 2 on at
    Hi,
    Just wanted to re-check - do the G/L entries have been posted? 
    if You check Value entries - the column - Amount posted to G/L - does it have a value?

    Only setup regarding this could be found in "Inventory Setup" - maybe You have set Automatic Cost adjustement to a day or month (not always) - that is why there are several Value Entries linked to 1 G/L entry?
  • YUN ZHU Profile Picture
    95,381 Super User 2025 Season 2 on at
    Hi, can you find GL Entries by clicking Find entries on the page?
    For example,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,990

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,576 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,028 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans