BeyondERP.Newsletter
Menu

Setup step on the Project actual transactions page · Project management and accounting

Close the period by project

Review each project's posted totals for a closed ledger period.

Business process
Analyze project performance
Menu item
output:ProjListTransProj
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 report that lists posted project transactions grouped first by project, with amounts per transaction type, for the project and ledger dates you choose.
What you do hereUse it to answer 'what did each project actually cost and earn in this period?' at period end, before reviews with project managers.
ExampleAt October close the BEAT controller runs the report for Time and material and Fixed-price with Hour, Expense and Item on, ledger dates 1 to 31 October, and sees PRJ-0042 with 18,450.00 EUR cost against 24,600.00 EUR revenue.
Project actual transactions 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 processAnalyze project performance
Menu pathProject management and accounting › Inquiries and reports › Actual transactions reports › Project actual transactions
Set up firstPosted project transactions Microsoft Learn
Used next byAdjust transactions Microsoft Learn
Related pagesCategory actual transactions Microsoft Learn Resource/item actual transactions Microsoft Learn
In this process Check retained amounts before releasing them · Compare spending by category
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 itAt period end, after hours, expenses and items for the period are posted.
How oftenMonthly at period end.
What the output showsPosted amounts per project, broken down by the levels you choose.

Source: Microsoft Learn

Setup steps on this page

Close the period by project

Review each project's posted totals for a closed ledger period.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Actual transactions reports > Project actual transactions.
  2. Turn on Time and material and Fixed-price and the transaction types you close, leaving Time off because Time projects post no ledger amounts.
  3. Enter the Ledger date range of the closed period and leave the Project date range empty.
  4. Keep Level 1 on Project and set Level 2 to Category to see what drives each project's total.
  5. Send projects whose totals differ from Project statements back to their project manager for adjustment.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesWhich project types to include; the dialog toggles Time and material, Fixed-price, Investment, Internal and cost (Internal and Cost project types) and Time. Time projects post nothing to the ledger.Microsoft Learn Time and material, Fixed-price
Include transaction typesHour, Expense, Item, Fee and On-account; turn on what the review covers.Checked in Dynamics 365Hour, Expense, Item
(Project date) From date / To dateThe range of project dates: when the work was done.Microsoft Learn 1 October to 31 October
(Ledger date) From date / To dateThe range of ledger dates: when the transactions were posted to the ledger.Microsoft Learn
Project statementThe statement the amounts follow; the dialog suggests Profit and loss.Checked in Dynamics 365Profit and loss
Skip zeroLeaves out rows whose amounts are zero.Checked in Dynamics 365Yes
Show amountChoose how amounts appear, such as with or without decimals, or in thousands.Microsoft Learn
Show hourChoose whether to show hour quantities, hour cost values, or both.Microsoft Learn
PL ratioChoose whether to add a profit and loss ratio column, such as gross margin.Microsoft Learn
Layout - rowsLevel 1 to 3 set the row grouping; Level 1 is Project on this report.Checked in Dynamics 365Level 1 Project, Level 2 Category

Common errors and fixes

MessageWhat to do
Totals are lower than on Project statements.A transaction type or project type is turned off, or both date ranges were filled and filter twice. Microsoft Learn

Test checklist

  1. Post 10.00 hours and a 500.00 EUR expense on PRJ-0042 in October.
  2. Run the report with Hour and Expense on, ledger dates in October.
  3. Check that PRJ-0042 shows both amounts.
  4. Compare the total with Project statements for October.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Close the period by projectUse the Ledger date range of the closed period, leave Project date empty, and keep Level 1 on Project.Ledger dates match the general ledger period; project dates show when work happened and can fall in another period.Which date range drives period-end project reviews?Filling both date ranges, which filters twice and drops late-posted work.Test: Project totals for a period

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor, Project accountant, Project assistant and Chief executive officer run this report.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the report reads the posted project transactions of the current legal entity. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterThe report reflects postings and adjustments at the moment it runs, so totals for a closed period change if transactions are adjusted later. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListTransProj Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorProject accountant ProjProjectAccountantChief executive officer CompanyChiefExecutiveOfficerProject assistant ProjProjectClerkGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListTransProj
Data migrationLoad order: The Project actual transactions report has no data entity in Data management: it reads posted project transactions. Open balances from a former system are loaded as beginning balance journals, which update only the project subledger, so compare their totals with this report after cutover.Microsoft Learn
Everyone

8Sources

To cite this step: PM-RA-310, Close the period by project. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RA-310