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.
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.
Comments
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.
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.