An inquiry that lists posted hour transactions on projects, with project date, project, category, resource, role, hours, cost price, sales price, line property and invoice status.
Project management and accountingInquiries and reportsTransactions inquiries
ProjTransEmpl
Used by
Chief executive officer, Field Service Integration User, Project accountant and 4 more roles
Business process
Analyze project performance
Menu item
ProjTransEmpl
Main table
ProjEmplTrans
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 is
An inquiry that lists posted hour transactions on projects, with project date, project, category, resource, role, hours, cost price, sales price, line property and invoice status.
What you do here
Use it to answer 'who booked how many hours on which project, at which price, and are they invoiced?' and to drill to the ledger voucher behind an hour line.
Example
A BEAT customer queries November's invoice, so the project accountant filters PRJ-0042 with Invoice status All and finds 37.50 hours by resource R-0105 at a sales price of 150.00 EUR, 7.50 of them still chargeable and not yet invoiced.
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.
Setup steps on this page
Trace posted hours for one project
Find who posted hours on a project and whether they are invoiced.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Transactions inquiries > Hour.
Set Invoice status to narrow the list, then filter on Project ID and the project date range.
Set Column display to Price to compare cost price and sales price per line.
Select a line and use Voucher or Ledger updates to see what it posted to the ledger.
If the price, category or line property is wrong, correct the line on Adjust transactions.
Set Invoice status first, then filter on Project ID and the date range.The same hours appear as chargeable before invoicing and as invoiced after; the status filter decides which question the list answers.
On the live system, Project accountant and Project assistant maintain this page; Project manager, Project supervisor, Chief executive officer, Field Service Integration User and Service delivery manager view it.
Posted hours can't be edited here; an adjustment reverses the line and creates a new one, and the invoice status changes when an invoice proposal is posted. Microsoft Learn
Technical architect
6Technical
Menu item
ProjTransEmplChecked in Dynamics 365
Form
ProjTransEmplChecked in Dynamics 365
Table
ProjEmplTransShown as “Project hour transactions” in Record infoKey field: TransDate, ProjId, ActivityNumber, CategoryId, LinePropertyId, Resource, Resource_Name, Resource_ResourceId, Resource_ResourceCompanyId, ResourceCategoryChecked in Dynamics 365
Who can open it
PrivilegesMaintain all posted project transactions ProjPostedProjectTransactionsMaintainView all posted project transactions ProjPostedProjectTransactionsViewView hour transactions ProjTransEmplViewDutiesMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPostReview project transactions ProjProjectTransactionsReviewInquire into project transaction status ProjProjectTransactionStatusInquireApprove posting of service orders SMAServiceOrdersJournalize7 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorService delivery manager SMAServiceDeliveryManagerChecked in Dynamics 365
Roles to set it up and use it
To set it up or change itProject accountant ProjProjectAccountantProject assistant ProjProjectClerkTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserService delivery manager SMAServiceDeliveryManagerGive people one of these roles. On this system, 7 roles can open this page.Checked in Dynamics 365
Load order: The Hour transactions inquiry has no data entity in Data management that writes posted transactions: lines are created by posting journals, timesheets or source documents. Open hours from a former system are loaded as beginning balance journal lines (ProjBeginningBalanceCostSaleEntity), which update only the project subledger.Microsoft Learn