Announcements
No record found.
How to archive LedgerJournaltrans table in dynamics 365 F&O
Hi Akash,
Can you elaborate on your question on what you want to achieve and why do you want to archive LedgerJournalTrans table? Have you analysed how the other processes/inquiry screens/reports will be impacted if you archive data of the LedgerJournalTrans table? Have you analysed the records on related tables like LedgerJournalTrans_Project , LedgerJournalTrans_Asset and many more?
From a technical perspective, there are many standard archival processes as shown below and you can develop a new archival process using similar approach once you have analysed the impact.
the following link for your referencehttps://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/sysadmin/cleanuproutines#general-ledger
The link provided by Ding shows you that there is an out of the box cleanup task for journals and the journal lines.
Are you only looking for deleting old and posted journals or do you need to have all information available in an archive as well?
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 445 Most Valuable Professional
André Arnaud de Cal... 309 Super User 2026 Season 2
CU29091230-0 192
