BeyondERP.Newsletter
Menu

Job page · General ledger

Clean up ledger journals

A cleanup routine that deletes posted General ledger, Accounts receivable, and Accounts payable journals.

Business process
Manage data
Menu item
Action:LedgerJournalCleanUp
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA cleanup routine that deletes posted General ledger, Accounts receivable, and Accounts payable journals.
What you do hereUse this page to remove posted ledger journals, and the information related to their original transactions, when reversing them won't be needed.
Clean up ledger journals page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage data
Menu pathGeneral ledger › Periodic tasks › Clean up ledger journals
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itOnly for posted journals you are sure you will never need to reverse.
How oftenRarely, as part of data housekeeping; there's no fixed cadence.
Batch settingsRun it as a batch job, and turn on Delete journals batch process performance improvement in Feature management (10.0.47 and later) so it runs more efficiently.
What the output showsThe posted General ledger, Accounts receivable and Accounts payable journals in the date range are deleted, together with all information related to their original transactions.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to General ledger > Periodic tasks > Clean up ledger journals.
  2. Under Date range, enter the From date and To date of the posted journals to delete.
  3. Expand General ledger, Accounts receivable and Accounts payable and set the options for each area, so only the journal types you mean are deleted.
  4. Under Run in the background, run it as a batch job; with the Delete journals batch process performance improvement feature (10.0.47 and later) it uses a top picking pattern.
  5. Afterwards, open the journal lists for the date range and check that only the posted journals you meant to remove are gone.

Source: Microsoft Learn

Test checklist

  1. Only posted journals in the date range were deleted.
  2. Unposted journals in the range are still there.
  3. The batch job history shows the run ended without errors.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted journals and the related transaction information can't be restored, and those transactions can no longer be reversed. Run it only when you are sure no reversal is needed. Microsoft Learn
If you change it laterDeleting a posted journal removes all the information related to the original transaction, so run it only when reversing those transactions won't be needed. Microsoft Learn
Technical architect

5Technical

Menu itemAction:LedgerJournalCleanUp Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorRental manager RentalManagerRental sales manager RentalSalesManagerRental purchasing manager RentalPurchasingManagerGive people one of these roles. On this system, 5 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=Action:LedgerJournalCleanUp
Everyone

7Sources