Skip to main content

Notifications

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

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

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 73,339 Super User 2024 Season 2 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 3,924 Super User 2024 Season 2 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans