Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Missing GL Entries [Case Closed]
OMM
Member Posts: 17
Hi Expert,
I am using NAV AP 4.0 (SP0).
I had run the Adjust Cost-Item Entries and Post Inventory Cost to GL, and when I navigate from the Item Ledger Entry, I can only see two tables name displayed from Navigate window, i.e. Item Ledger Entry and Value Entry, GL Entries is missing. However when I navigate to the Value Entry, I can find the value recorded next to G/L Entry No. (Account) & G/L Entry No. (Bal. Account) field, and that two GL Entry No were actually exist in GL Entry table, and posted with the correct value as per ILE & Value Entry, just I cannot see the "GL Entry" from Navigate window. This only happen to some ILE.
Is anyone has any idea?
Many thanks
I am using NAV AP 4.0 (SP0).
I had run the Adjust Cost-Item Entries and Post Inventory Cost to GL, and when I navigate from the Item Ledger Entry, I can only see two tables name displayed from Navigate window, i.e. Item Ledger Entry and Value Entry, GL Entries is missing. However when I navigate to the Value Entry, I can find the value recorded next to G/L Entry No. (Account) & G/L Entry No. (Bal. Account) field, and that two GL Entry No were actually exist in GL Entry table, and posted with the correct value as per ILE & Value Entry, just I cannot see the "GL Entry" from Navigate window. This only happen to some ILE.
Is anyone has any idea?
Many thanks
0
Comments
The VLE records existed but were missing from the VLE "Item Ledger Entry No." index.
We would have odd occurrances of this after optimising all tables.
Disabling the index, saving the table and re-enabling the index resolved this.
We found what has caused this. This is because the GL>Posting Date is different from ILE and Value Entry > Posting Date, thus when we navigate from ILE, the Posting Date is defaulted from ILE > Posting Date, hence the GL Entry was excluded, when we remove the Posting Date search option, we can see the GL Entry from Navigate window. :oops: