BeyondERP.Newsletter
Menu

Setup step on the Delete project journals page · Project management and accounting

Delete old posted project journals

Remove posted project journals of a closed, audited year.

Business process
Manage project delivery
Menu item
action:ProjJournalCleanUp
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic job that permanently deletes posted project journals (hour, fee and beginning balance journals) that are no longer needed.
What you do hereUse it during data cleanup to remove old posted journal headers and lines, so the journal lists stay short and system resources are freed. Delete only journals you will never need to reverse.
ExampleBEAT closed fiscal year 2024 in March 2026. The project accountant selects the 214 posted hour journals and 38 posted fee journals dated 2024, such as journal PJ-024417 with 46.50 hours on PRJ-0042, and deletes them after the audit sign-off.
Delete project 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

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 itAfter a fiscal year is closed and audited, when its posted project journals are no longer needed.
How oftenOnce a year, as part of data cleanup.
Batch settingsRun it as a batch job outside office hours when many journals are deleted.
What the output showsThe selected posted journals are deleted. The infolog shows how many journals were removed.

Source: Microsoft Learn

Setup steps on this page

Delete old posted project journals

Remove posted project journals of a closed, audited year.

Steps from Microsoft

  1. Go to Project management and accounting > Periodic > Journals > Delete project journals.
  2. Select Select and, in the Criteria field, choose the posted journals to delete, for example a range of journal numbers from a closed fiscal year; select Add to put more journals in the criteria.
  3. Leave Hour and Fee off unless you really want every posted hour or fee journal deleted, whatever the criteria say.
  4. Check with the auditors that the journals are no longer needed, because the journal information can't be restored.
  5. Run the job, then open Journals > Hour and filter on Posted to check that the chosen journals are gone and later journals are still listed.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
HourWhen turned on, deletes all posted hour journals, not only the journals chosen in the criteria.Microsoft Learn Off, so only the journals chosen in the criteria are deleted.
FeeWhen turned on, deletes all posted fee journals, not only the journals chosen in the criteria.Microsoft Learn Off for a targeted cleanup of 2024 journals.
Criteria (Select)The query that lists the posted journals to delete, for example by journal number or posting date.Checked in Dynamics 365Journal number PJ-024001..PJ-024417

Common errors and fixes

MessageWhat to do
Journals outside the intended range are gone after the run.Hour or Fee was turned on, which deletes all posted journals of that type. Leave both off and limit the criteria. Deleted journals can't be restored. Microsoft Learn

Test checklist

  1. Count the posted hour journals in the criteria range before the run (for example 214).
  2. Run the job with the same criteria.
  3. Filter Journals > Hour on Posted: the count for the range is 0.
  4. Filter Journals > Hour on Posted for a later range: those journals are still listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Delete old posted project journalsDelete by criteria (journal number or date range of a closed fiscal year), with Hour and Fee turned off.The criteria limit the delete to journals you checked; Hour and Fee delete every posted journal of that type.How should posted project journals be cleaned up?Turning on Hour or Fee to 'save time' and losing the posted journals of the current year.Test: Delete posted hour journals of a closed year

Feature management and licence

Licence or add-inOn the live system, Project accountant and Project assistant use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the job deletes posted journals of the legal entity you run it in. Microsoft data model
Can it be undoneIrreversible: Deleted journals can't be restored.
If you change it laterDeletes posted project hour, fee and beginning balance journals. All information related to the original journal transactions is removed, so delete only journals you are sure you won't have to reverse. Microsoft Learn
Technical architect

6Technical

Menu itemaction:ProjJournalCleanUp Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itProject accountant ProjProjectAccountantProject assistant ProjProjectClerkGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:ProjJournalCleanUp
Data migrationLoad order: Delete project journals has no data entity in Data management: it is a periodic job and keeps no records of its own. Migrate open project journals with ProjJournalTableEntity if you need them, and run this cleanup in the target system only after its own fiscal year close.Load first: ProjJournalTableEntityMicrosoft data model
Everyone

8Sources

To cite this step: PM-JOB-010, Delete old posted project journals. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-JOB-010