Customer want to reduce the size of system table(eg., GL Entry) which is huge in size. he was asking for option for selecting record for specific period and delete the records. Before deletion fo records , he is expecting to take back up of data for the filtered period before the deletion process begins.
Up to my understanding , we need to take backup for the related tables which is linked with that specific system table (correct me if am wrong).
how to acheive it. Please suggest?
If we are talking about a SQL database backup, you cannot backup individual tables. For a SQL backup, a filegroup is the smallest unit that can be backed up. The only way to “backup” a single table would be to copy the desired records to another medium. Such as an Excel workbook a text file, or another database, etc.
Define huge? What is the expectation from deleting records? Keep in mind, he can’t simply delete records. Their financial data has to still be accounted for. It’s more of a date compression process. Not that I fully recommend that either.
To reduce the size of a large system table like GL Entry, the customer can select records for a specific period and delete them. Before deletion, they should take a backup of the data for the filtered period. In addition to the system table, related tables linked to it should also be backed up to ensure data integrity.
Probably, Date Compression is what they need:
If you choose “Archive data”, the data is stored in a “Archive” table and can be exported as CSV or Excel format:
1 Like
In SaaS the way to go for keeping the database size in check is through Retention Policies.
Clean Up Data with Retention Policies - Business Central | Microsoft Learn
Do not try to delete G/L Entries yourself!
Go with “pjllaneras” solution - use Date Compression.
It is located in “Administrator Role Center” or (BC18+) “Data Administration Guide”
First of all I Apologize for late response! Thank you every one for your Valuable suggestion !. One thing i forgot to metion is Customer is expecting this functionality in NAV2018 Version.
Can we acheive the deletion of G/l Entries by doing modification in Navigate Page. because it has option to show Related Data for a specific G/L Entry for specific Date range. Can we do it and able to achieve the deletion of Gl Entry? Please help experts!!!
Thanks for your valuable input.
But as far as i analyzed Success rate of Date Compression in NAV System is low it seems. Please correct me if am wrong.
and Customer is expecting this solution in NAV2018 Version sir!
Thanks for your valuable input.
But as far as i analyzed Success rate of Date Compression in NAV System is low it seems. Please correct me if am wrong.
and Customer is expecting this solution in NAV2018 Version sir!