Project management and accountingInquiries and reportsActual transactions reports
output:ProjListTransID
Business process
Analyze project performance
Menu item
output:ProjListTransID
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 is
A report that lists posted project transactions grouped first by resource or item: the hours each worker posted and the items consumed, for the dates you choose. The report design is ProjListTrans.
What you do here
Use it to answer 'how many hours did each person post, and which items were consumed, on our projects?' for staffing and material reviews.
Example
For November the BEAT project manager runs the report with Hour and Item on and Level 1 Resource/item, and sees R-0105 with 142.50 hours on 3 projects and item CABLE-10 with 60.00 units on PRJ-0042.
The page in Dynamics 365. page title tab to open what to set or check
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 it
Monthly, after timesheets are posted, for staffing and material reviews.
How often
Monthly.
What the output shows
Posted hours per worker and quantities per item, with projects at the next level if chosen. The report design is ProjListTrans.
Turn on Hour (and Time projects for all hours), keep Level 1 on Resource/item, add Project at Level 2.Time projects hold non-billable hours such as sick time; leaving them out understates the hours a person worked.
On the live system, Project manager, Project supervisor, Project accountant, Project assistant and Chief executive officer run this report. The report runs with the reporting framework's transaction scope switched off in code; there is no switch to set.
Per company: the report reads the posted project transactions of the current legal entity. Microsoft data model
Can it be undone
Reversible: Reading the page changes no data.
If you change it later
The 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 item
output:ProjListTransIDChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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
Load order: The Resource/item 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