Skip to main content

Notifications

Announcements

No record found.

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 74,115 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,962 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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans