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,
  • YUN ZHU Profile Picture
    YUN ZHU 77,883 Super User 2025 Season 1 on at
    Value Entry No_ and G_L Entry No_ missing from G_L - Item Ledger Relation
    Hi, can you find GL Entries by clicking Find entries on the page?
    For example,
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,070 Super User 2025 Season 1 on at
    Value Entry No_ and G_L Entry No_ missing from G_L - Item Ledger Relation
    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?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans