BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Resource/item actual transactions

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.

Business process
Analyze project performance
Menu item
output:ProjListTransID
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 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 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 hereUse it to answer 'how many hours did each person post, and which items were consumed, on our projects?' for staffing and material reviews.
ExampleFor 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.
Resource/item 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 › Resource/item actual transactions
Set up firstAll timesheets Microsoft Learn
Used next byMissing timesheets Microsoft Learn
Related pagesProject actual transactions Microsoft Learn Resource/item forecast transactions Microsoft Learn
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 itMonthly, after timesheets are posted, for staffing and material reviews.
How oftenMonthly.
What the output showsPosted hours per worker and quantities per item, with projects at the next level if chosen. The report design is ProjListTrans.

Source: Microsoft Learn

Setup steps on this page

Review posted hours per person

See each worker's posted hours and each item's consumption across projects.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Actual transactions reports > Resource/item actual transactions.
  2. Turn on Hour for people or Item for materials; add the Time project type when the review covers all hours, not only billable ones.
  3. Enter the Project date range of the month you review.
  4. Keep Level 1 on Resource/item and add Project at Level 2 to see where each person's hours went.
  5. Compare hours per worker with their timesheets and follow up missing hours on Missing timesheets.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesWhich project types to include; turn on Time when you also want sick and leave hours, which post no ledger amounts.Microsoft Learn Time and material, Time
Include transaction typesHour and Item are the types that carry a worker or an item.Checked in Dynamics 365Hour, 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 is Resource/item on this report; add Project at Level 2 to split each person's hours.Checked in Dynamics 365Level 1 Resource/item, Level 2 Project

Common errors and fixes

MessageWhat to do
Sick or leave hours are missing.They are on Time projects; turn on the Time project type. Microsoft Learn

Test checklist

  1. Post 8.00 hours for R-0105 on PRJ-0042 and 8.00 on PRJ-0024.
  2. Run the report with Hour on and Level 2 Project.
  3. Check that R-0105 shows 16.00 hours split over two projects.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review posted hours per personTurn 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.Do hour reviews include Time projects?Comparing posted hours with capacity while Time projects are turned off.Test: Hours per worker

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. The report runs with the reporting framework's transaction scope switched off in code; there is no switch to set.

Microsoft Learn

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: The report changes no data. Microsoft Learn
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:ProjListTransID 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:ProjListTransID
Data migrationLoad 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
Everyone

8Sources