how to take backup of a System table data before the Deletion of records from a specific table?

kovaidon

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?

franjohn

Hi
check the link
https://learn.microsoft.com/en-us/previous-versions/dynamicsnav-2016/hh167693(v=nav.90)?redirectedfrom=MSDN

kovaidon

Thanks FarJohn for your kind reply!. Apologize for late response!.

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!!!!!