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

I have the same question (0)

All responses (6)

Answers (1)

Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No
Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (1)

Report

Hi, hope the following helps.

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

https://yzhums.com/15246/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

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/

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report
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.

Was this reply helpful? Yes No
Verified answer

Kev L 92 on at

Like (1)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No