Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
This is my first week using Dynamics AX and came across the INVENTSUMLOGTTS table. This table has 57 million transactions. Can this data be archived or deleted ?
This table is only deleted if you use master planning. Don't be afraid, you can delete it, do it from sql (it is faster than doing it from Dynamics with a job) with nobody logged into AX
Please be aware that writing direct SQL DELETE statements against your AX database is not best practice.
Of course is not the best practice, but deleting 57 million transactions in this table with a job inside Dynamics will cost a lot, too much in fact. I would consider deleting it from SQL and then programming a batch process to delete the registers once you have done it.
Master Planning program does not clear the INVENTSUMLOGTTS table on certain runs. The next run of the Master Planning program does not clear the old data. We typically see approx. 3 to 5 million transactions in this table.
We created a SQL process to truncate the table every week. We do not archive the data.
Thank you all for the responses.
The article Michael links to actually states: "You can schedule a job in Microsoft SQL Server to periodically delete the records.".
So I guess in this case it should be perfectly safe to do directly from SQL, even though it certanly isn't normal best pratice.
Business Applications communities