Blank Item Ledger Entry with Actual Cost
                
                    kiranisht                
                
                    Member Posts: 6                
            
                        
            
                    I have been wondering for a few days about the amount of time the Adjust cost Item batch job has been taking (NAV2009 Classic Client) hence I checked the forum and accordingly found that I have an ILE with no Item no.
It is the first entry in the table with entry number 0.
Entry Type - Purchase (which is default)
AND Cost Amount(Actual) : 97,58,973.14 \:D/
Ladies and Gentlemen please help me get rid of this systematically and I shall personally invite you for a champagne PARTY!! \:D/
                It is the first entry in the table with entry number 0.
Entry Type - Purchase (which is default)
AND Cost Amount(Actual) : 97,58,973.14 \:D/
Ladies and Gentlemen please help me get rid of this systematically and I shall personally invite you for a champagne PARTY!! \:D/
0                
            Comments
- 
            Looks like someone messed up long time ago.
You need a senior person to look into where that cost amount is calculating from. That ILE with 0 on the Entry No. was probably entered by accident by someone with developer license.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 - 
            Alex,
Yes, quite a probability that, someone with Developer license did it.
Unfortunately I am not aware of any senior personnel who can help me with this systematically considering the complexity of the problem with Actual cost.
If you do know some one who can, suggestions are welcome!
The question is still open for other solutions.0 - 
            Do not see any reason why not to delete this entry. There is no value entries for this, obviously no item ledger entry relations or whatsoever.
I'll delete this entry! But will do backup first
I guess cost amount is calculated because there is some open entries (which got a 0 in apply-to entry filed. Or in item ledger relation table
If this cost is not posted to GL - just delete this entry. I guess this not posted, as there is no item no, so system will not be able to get posting groups.
Yes, Just delete it. You need a partner licence to delete ILE. If you do not have partner licence - call to your partner
                        0 
Categories
- All Categories
 - 73 General
 - 73 Announcements
 - 66.6K Microsoft Dynamics NAV
 - 18.7K NAV Three Tier
 - 38.4K NAV/Navision Classic Client
 - 3.6K Navision Attain
 - 2.4K Navision Financials
 - 116 Navision DOS
 - 851 Navision e-Commerce
 - 1K NAV Tips & Tricks
 - 772 NAV Dutch speaking only
 - 617 NAV Courses, Exams & Certification
 - 2K Microsoft Dynamics-Other
 - 1.5K Dynamics AX
 - 323 Dynamics CRM
 - 111 Dynamics GP
 - 10 Dynamics SL
 - 1.5K Other
 - 990 SQL General
 - 383 SQL Performance
 - 34 SQL Tips & Tricks
 - 35 Design Patterns (General & Best Practices)
 - 1 Architectural Patterns
 - 10 Design Patterns
 - 5 Implementation Patterns
 - 53 3rd Party Products, Services & Events
 - 1.6K General
 - 1.1K General Chat
 - 1.6K Website
 - 83 Testing
 - 1.2K Download section
 - 23 How Tos section
 - 252 Feedback
 - 12 NAV TechDays 2013 Sessions
 - 13 NAV TechDays 2012 Sessions