Announcements
No record found.
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 ?
Thanks.
*This post is locked for comments
Please see
http://support2.microsoft.com/kb/904855
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.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
