problem Adjust Cost-Item Entry

felix_aq
Member Posts: 4
Dear Admin, our Navision using version SG 3.01.B starting from july 2002 and now we have problem when running program Adjust Cost-Item Entry, the message is "item ledger entry entry no. xxxxxx does not exist" there was 30 items has problem and we havn't find this problem before. So what cause had making it happen and what your suggestion for that.
0
Comments
-
Looks to me like someone has gone gehind the scenes and deleted some item ledger entries where other entries requiring cost updates are linked.
I presume if you open the ILE the referenced number is not there.
So why were these deleted, who did it and can they fix the issue for you?The art of teaching is clarity and the art of learning is to listen0 -
ok thanks Adam, that's clear now after we finding cause this problem that is a few number of posted sales credit memo (posting date April 2008)whose it still had outstanding since 2003-2004 and the condition document of sales return order is had posted Return Receive but never posting credit memo before. maybe you mean deleted some ledger entries that it happen while we have done running the periodic activities date compression of item ledger entries starting date 2002 until 2004 on the last year of 2007.
So can you tell me about the features could make deleted item ledger entries besides developer or superuser. Maybe it would be our protection for the future. thanks a lot.0 -
ok thanks Adam, that's clear now after we finding cause this problem that is a few number of posted sales credit memo (posting date April 2008)whose it still had outstanding since 2003-2004 and the condition document of sales return order is had posted Return Receive but never posting credit memo before. maybe you mean deleted some ledger entries that it happen while we have done running the periodic activities date compression of item ledger entries starting date 2002 until 2004 on the last year of 2007.
So can you tell me about the features could make deleted item ledger entries besides developer or superuser. Maybe it would be our protection for the future. thanks a lot.0 -
I guess if you date compressed the item ledger entries and these contained open entries awaiting adjustment then yes this would cause you the issue. I am not aware of specific routines that would cause this, although if you open SQL and delete them then this is obviously one way!The art of teaching is clarity and the art of learning is to listen0
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
- 320 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