Hi,
Is there a way to delete transaction like matrial request, po, purchase receipt etc for date older than for example 3 years via the apps.? ( i dont want to delete all transaction, only the old and unused one)
Should we/ is it ok to do it on mariadb directly ?
Regards
Aditya
You could just filter out the list and delete them as required, but it is not adviced to directly delete them in the database, unless you know every document that would be affected on deleting the said document. Then you need to perform all those changes to all those affected documents as well, which is not practical.
A solution would be to write a background job that cancels and then deletes the said documents through an API.
Hi,
Thank You,
I think that is the safest way to do for now.
Regards,
Aditya