BeyondERP.Newsletter
Menu

Setup step on the Hour page · Project management and accounting

Trace posted hours for one project

Find who posted hours on a project and whether they are invoiced.

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
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn 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 hereUse 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.
ExampleA 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.
Hour 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.

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

  1. Go to Project management and accounting > Inquiries and reports > Transactions inquiries > Hour.
  2. Set Invoice status to narrow the list, then filter on Project ID and the project date range.
  3. Set Column display to Price to compare cost price and sales price per line.
  4. Select a line and use Voucher or Ledger updates to see what it posted to the ledger.
  5. If the price, category or line property is wrong, correct the line on Adjust transactions.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Column displayChooses which group of columns the grid shows, for example prices.Checked in Dynamics 365Price
Invoice statusLimits the list to transactions in one invoicing state; All shows every state.Checked in Dynamics 365All
HoursThe posted quantity of hours on the line.Checked in Dynamics 3657.50
Line propertyDecides whether the hours are chargeable and whether revenue accrues; it is the reason a line can or can't be invoiced.Microsoft Learn Chargeable
Role IDThe role the hours were posted under; role-based hour prices use it.Microsoft Learn CONSULT

Common errors and fixes

MessageWhat to do
An hour line shows no voucher.Hours on Time projects are not posted to the ledger; they appear as project transactions without voucher transactions. Microsoft Learn

Test checklist

  1. Post an hour journal of 7.50 hours on PRJ-0042.
  2. Open the inquiry filtered on PRJ-0042.
  3. Check that one line of 7.50 hours shows with the journal's category and line property.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Trace posted hours for one projectSet 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.Where do project accountants correct a posted hour line?Reading Time project hours as missing ledger postings; Time projects never post to the ledger.Test: Posted hours appear with status

Feature management and licence

Licence or add-inOn 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.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterPosted 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 itemProjTransEmpl Checked in Dynamics 365
FormProjTransEmpl Checked in Dynamics 365
TableProjEmplTransShown 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 itPrivilegesMaintain 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 SMAServiceOrdersJournalize
7 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorService delivery manager SMAServiceDeliveryManager
Checked in Dynamics 365
Roles to set it up and use itTo 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
Actions on the pageActions: Functions, Inquiries, View accountingOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjTransEmpl
Data migrationLoad 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
Table definitionProjEmplTrans columns and relations Microsoft data model
Everyone

8Sources