BeyondERP.Newsletter
Menu

Page · Project management and accounting

All timesheets

The project accountant's list of project timesheets in the legal entity, opened on the current timesheet period, with each timesheet's resource, period, approval status and total hours.

Used by
Project accountant
Business process
Manage project delivery
Menu item
TSTimesheetEntryGridViewAllTimesheets
Main table
TSTimesheetTable
Data entity
TSTimesheetTableEntity
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 isThe project accountant's list of project timesheets in the legal entity, opened on the current timesheet period, with each timesheet's resource, period, approval status and total hours.
What you do hereUse it to find any timesheet, create one, check where it is in the approval workflow, and follow time recorded on projects of another legal entity.
ExampleFor example, at week end the BEAT project accountant opens All timesheets, filters Approval status on Submitted and finds 7 timesheets with 263.50 hours still waiting for approval.
All timesheets 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

Review timesheets by approval status

See which timesheets block the period close.

Steps from Microsoft

  1. Go to Project management and accounting > Timesheets > All timesheets.
  2. Filter the Approval status column, for example on Submitted, to see what still waits for approval.
  3. Check the Period start date, Period end date and Timesheet total columns.
  4. Select New to create a timesheet for a resource, or Edit to open the selected one.
  5. For approved timesheets that are not yet posted, run Post all approved timesheets.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Legal entityThe legal entity of the project the time is recorded for; it defaults to the current one.Microsoft Learn BEAT
Approval statusWhere the timesheet is in its workflow, for example Created, Submitted or Approved.Checked in Dynamics 365Submitted
Timesheet totalThe total hours on the timesheet.Checked in Dynamics 36537.50
Period start dateThe first day of the timesheet period.Checked in Dynamics 36507/12/2026

Common errors and fixes

MessageWhat to do
A timesheet you expect is not in the list.The page opens on the current period; widen the period filter or check the Legal entity of the project. Microsoft Learn

Test checklist

  1. Create a timesheet for a resource for the current period with 8.00 hours on PRJ-0042.
  2. Submit it.
  3. Filter All timesheets on Submitted.
  4. Check the timesheet is listed with a total of 8.00.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review timesheets by approval statusFilter Approval status first, on Submitted for approvals still to do and on Approved for timesheets still to post.The page opens on the current period and mixes every status, so totals without a status filter mean nothing.How are timesheets posted after approval?Reading Approved as posted: approved hours reach the project only when the timesheet is posted.Test: Find timesheets waiting for approval

Feature management and licence

Licence or add-inOn the live system, Project accountant use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own timesheets; a worker can still record time for a project of another legal entity through intercompany timesheets. Microsoft Learn
Can it be undoneReversible: An unposted timesheet can be returned and changed in its workflow; posted hours are corrected with a project adjustment. Microsoft Learn
If you change it laterA timesheet posts project hours only after it is approved and posted; until then it doesn't change project cost. Microsoft Learn
Technical architect

6Technical

Menu itemTSTimesheetEntryGridViewAllTimesheets Checked in Dynamics 365
FormTSTimesheetEntry Checked in Dynamics 365
TableTSTimesheetTableShown as “Timesheets” in Record infoChecked in Dynamics 365
Data entitiesTSTimesheetTableEntityTimesheet Headers Microsoft data model
Who can open itPrivilegesMaintain ledger postings ProjPostingMaintainDutiesMaintain project ledger postings ProjProjectLedgerPostingsMaintain
1 security roleProject accountant ProjProjectAccountant
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject accountant ProjProjectAccountantGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageTimesheet: Maintain, Related information, Print, PolicyOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=TSTimesheetEntryGridViewAllTimesheets
Integrate withTSTimesheetTableEntity data entity Microsoft data model
Data migrationTSTimesheetTableEntity (Timesheet Headers): loaded for each company.Load order: Timesheets are usually not migrated; post the open ones in the old system. If loaded, load workers, projects, project categories and timesheet periods first, then the headers.Load first: Workers, Projects, Project categories, Timesheet period typesMicrosoft Learn
Table definitionTSTimesheetTable columns and relations Microsoft data model
Everyone

8Sources