BeyondERP.Newsletter
Menu

Setup step on the Hour page · Project management and accounting

Post hours with the right journal name and category

Price and post hours correctly.

Used by
Chief executive officer, Field Service Integration User, Machine operator and 5 more roles
Business process
Manage project delivery
Menu item
ProjJournalTableEmpl
Main table
ProjJournalTable
Data entity
ProjJournalTableEntity
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 isThe project hour journal: a journal of hours worked on projects, priced with the cost and sales prices of the price setup, that posts the hours to the project and the ledger.
What you do hereUse it to record project hours that don't come from a timesheet, for example corrections or hours for workers who don't enter timesheets, and post them.
ExampleFor example, a BEAT consultant's 8.00 hours on PRJ-0042 are entered in hour journal PJ-000412 at a cost price of 50.00 and a sales price of 75.00; posting records 400.00 cost and, on a project that accrues revenue, 600.00 of accrued revenue.
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

Post hours with the right journal name and category

Price and post hours correctly.

Steps from Microsoft

  1. Go to Project management and accounting > Journals > Hour.
  2. Select New, select the journal name, and then select Lines.
  3. Select New and enter the project date, project, resource, category and hours.
  4. On the General tab, check the cost price, sales price, line property and sales tax groups.
  5. Select Post.
  6. Check the hours on Posted project transactions for the project.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Sales priceThe price for the hours; the most detailed matching sales price setup is used.Microsoft Learn 75.00SalesPrice
Cost priceThe cost per hour from the cost price setup.Microsoft Learn 50.00
Journal nameThe hour journal name that sets the voucher series and defaults for the journal.Microsoft Learn PHOUR
Line propertyDecides whether the hours are chargeable to the customer.Microsoft Learn CHARGE
HoursThe number of hours worked on the line.Microsoft Learn 8.00

Common errors and fixes

MessageWhat to do
The hour journal can't be edited.With journal approval, a journal becomes read-only while its approval status doesn't allow editing; return it in the approval flow first. Microsoft Learn

Test checklist

  1. Create an hour journal line of 8.00 hours on PRJ-0042.
  2. Check the cost price 50.00 and sales price 75.00 default from the price setup.
  3. Post the journal.
  4. Check Posted project transactions shows 8.00 hours with a cost of 400.00.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Post hours with the right journal name and categoryUse a dedicated hour journal name and select the project category on every line, so prices and line property default.The category and the price setup decide the cost and sales price; the journal name decides the voucher series and approval.How are hours that don't come from timesheets approved?Overriding the sales price by hand on lines: the price setup is bypassed and the invoice shows a price nobody agreed.Test: Post an hour journal

Feature management and licence

Licence or add-inOn the live system, Project manager, Project accountant, Project assistant and Field Service Integration User use this page.

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 undoneHard to reverse: Posted hours are corrected through project adjustments.
If you change it laterPosting records the cost and, for projects that accrue revenue, the accrued revenue; with journal approval the journal becomes read-only while its approval status doesn't allow editing. Microsoft Learn
Technical architect

6Technical

Menu itemProjJournalTableEmpl Checked in Dynamics 365
FormProjJournalTable Checked in Dynamics 365
TableProjJournalTableShown as “Project journal table” in Record infoKey field: JournalId, JournalType, JournalNameId, Description, TimesheetNbrChecked in Dynamics 365
Data entitiesProjJournalTableEntityProject hour journals Microsoft data model
Who can open itPrivilegesMaintain hour journals ProjJournalTableEmplMaintainView hour journals ProjJournalTableEmplViewMaintain project journals ProjJournalTableMaintainView project journals ProjJournalTableViewDutiesMaintain project journals and journal transactions ProjProjectJournalsMaintainApprove project transactions ProjProjectTransactionApproveMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPostReview project transactions ProjProjectTransactionsReviewInquire into project transaction status ProjProjectTransactionStatusInquire
8 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserMachine operator JmgMachineOperatorShop supervisor JmgShopSupervisorProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject manager ProjProjectManagerProject accountant ProjProjectAccountantProject assistant ProjProjectClerkField Service Integration User FieldServiceIntegrationUserMachine operator JmgMachineOperatorTo use itProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjJournalTableEmpl
Integrate withProjJournalTableEntity data entity Microsoft data model
Data migrationProjJournalTableEntity (Project hour journals): loaded for each company; covers hour journal headers through the journal name.Load order: Load journal names, projects, categories and line properties first, then the journal headers. Open journals are usually posted in the old system instead.Load first: Project journal names (ProjJournalNameEntity), Projects, Project categories, Line propertiesMicrosoft Learn
Table definitionProjJournalTable columns and relations Microsoft data model
Everyone

8Sources