Delete a year ?

mdPartnerNL
Member Posts: 802
The customer has a backup and is not interested in year 2006 .. 2010
Will this give problems? I don't see them yet but there is not a standard option in NAV to do this..
Will this give problems? I don't see them yet but there is not a standard option in NAV to do this..
0
Comments
-
No reservations, Stock is not important, etc.0
-
All you can do is to use the date compression routine for ledger entries (G/L, vendor, customer etc.). In older versions, such a routine existed for the item ledger entries too but this caused lot of issues, especially in updates, so it has been removed.
Never ever delete any entries, for the current balance you always need all ledger entries starting with the first one, that is how the flowfield technology and SIFT works.
If some have been compressed (a single new entry sums up the value of several removed entries) that is okay if the data is not needed anymore, but if there are entries missing without this compensation it will screw up the current figures totally, in a worst case scenario beyond repair.Kai Kowalewski0 -
Did some research and I will customize codeunit 8604 to work with a datefilter.
This way I can
- delete normal entries
- delete compressed entries which make an update not possible
and of course I will check if ledger entries are closed.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
- 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