Hi All,
I'm working on purging the data for a few tables of D365FO that include custom tables too. I would like to know from you if there is any impact on day to day activities by truncating the data for certain periods (ex: 30/60/90/365 days and soon).
Hi Chandra,
Martin provided already a valuable reply. In general, Microsoft provides cleanup tasks for tables which are supported to be cleaned up. E.g. there is a task called Inventory Dimensions Cleanup to delete InventDim records which are not referenced on any transaction. There is also a job to move InventTrans records to a historical transactions tables: Feature trial: Inventory transactions archive - Dynamicspedia.
Like Martin, I'm quite concerned about auditability and consistency if you would try to delete records yourself. Instead, if you encounter database size or performance issues, you could contact Microsoft Support.
It depends a lot in what you mean by "to purge". Your list include several critical tables and removing data from them would likely make your system unusable. You would lose information about available quantity of all items (InventSum) and about inventory transactions, all tables using inventory dimensions (such as color or warehouse) would lose the information and would become unusable (because of deleting InventDim data), you lose accounting data (GeneralJournalEntry / GeneralJournalAccountEntry) and so on. I would recommend not touching these tables at all, and if you really want, you must be extremely careful. Even if you believe that you don't need some data anymore, think about audting reasons, that you may need to return orders even several years old and so on.
On the other hand, there are tables in your list that you can purge without any issue, such as EcoResReleasedProduct2Staging.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,340
André Arnaud de Cal... 835 Super User 2025 Season 2
Sohaib Cheema 640 User Group Leader
