Delete Posted General Journal

(2) Share

Report

Posted on by Kev L

Hi Experts,

I found that there's no way to set a retention policy to Posted General Journal (tbl ID: 181) nor able to delete any records.

My purpose is to keep this list neat and only showing the records up to 2 years before as time passes.

Note: I'm referring to Use the copy journal function on Posted General Journals and control date for reversing entries in Recurring General Journals - Dynamics 365 Release Plan | Microsoft Learn, not General Ledger Entries.

Regards,

Kevin

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (1)

Sort by

Gerardo Rentería Ga... 27,621 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Add Retention Policy To Your Business Central App | LinkedIn

Dynamics 365 Business Central: creating retention policies from AL – Stefano Demiliani

Best Regards
Gerardo
Ramesh Kumar 7,566 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Kev,

I think below link might be helpful and also Dev team should be able to add retention policy to given table.

https://learn.microsoft.com/en-ca/dynamics365/business-central/admin-data-retention-policies

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
Suggested answer

YUN ZHU 103,216 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following helps.

Dynamics 365 Business Central: Data cleanup tasks page (Data Administration page)

https://yzhums.com/15246/

Thanks.

ZHU
Suggested answer

Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Unfortunately, Posted General Journal is not part of the retention policy tables.

The only way is to customise it. You can check below post for how to add the table.

https://www.mynavblog.com/2020/12/21/clean-after-yourself-a-few-words-about-retention-policies/
Suggested answer

Jainam M. Kothari 17,045 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!
Hello,

Here, there are a few workarounds you can consider:

Archiving Old Entries: You can manually archive old entries by exporting them to an external file (e.g., Excel) and then removing them from the active view in Business Central. This way, you can keep a backup of old records while maintaining a clean view in the system.

Custom Development: If you have access to a developer or a partner with development capabilities, you can create a custom extension to handle the retention policy. This extension could automate the process of archiving and removing old records based on your specified criteria.

Filtering Views: You can create filtered views or saved filters in Business Central to only display records from the past 2 years. This won't delete the old records but will help you maintain a cleaner view. You can set up a filter on the posting date to only show entries within the desired date range.

Using Copy Journal Function: As you mentioned, you can use the copy journal function on Posted General Journals to create a copy of the entries you want to keep and then work with the copied journal. This can help you manage the entries more effectively.
Verified answer

Kev L 92 on at

Like (1)

Report
Copy link

Link copied!

Hi Experts,

Thanks for your advice.

I've found a workaround which utilise a 3rd party app, namely "IMPORT EXPORT POWERTOOL" from Insight Works to delete those older records that's not useful anymore. It's a shame that this app is not able to create a job queue.

Regards,

Kevin