BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Resource/item consumption

A report of the hours, expenses and items consumed, one row per resource (worker) or item, for one date range, built from posted project transactions.

Business process
Analyze project performance
Menu item
output:ProjListProjConsumptionEmplItem
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 of the hours, expenses and items consumed, one row per resource (worker) or item, for one date range, built from posted project transactions.
What you do hereIt answers how much work and material went into each of the resources and items, as a snapshot for one period, so project managers see whether effort runs ahead of plan before it shows in profit. The Project manager, Project supervisor, CEO and CFO roles can run it on this system.
ExampleBEAT runs Resource/item consumption for week 44 of 2026 on Hour, Expense and Item transactions. W-0042 shows 214.00 hours and 1,247.90 of expenses, so the project manager can see effort before invoicing.
Resource/item consumption 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.

When to run it

When to run itWeekly or at month end, after timesheets and expense journals are posted.
How oftenWeekly or monthly
Batch settingsRun it from the dialog for one review, or run it in the background on a monthly recurrence for the close pack.
What the output showsHours, expense amounts and item amounts consumed, one row per resource (worker) or item.

Source: Microsoft Learn

Setup steps on this page

Run the Resource/item consumption report

Review hours, expenses and items consumed per resource (worker) or item for one date range.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Consumption reports > Resource/item consumption.
  2. Turn on the project types and the Hour, Expense and Item transaction types you want counted for each resource or item; consumption is about effort, so include Internal and cost projects if internal work matters.
  3. Enter From date and To date under Ledger date to tie the consumption figures to a closed ledger period, or under Project date to see when the work was done, for example 1 October 2026 to 31 October 2026.
  4. Turn on Skip zero to hide resources and items with no amounts, and Skip blank ID to leave out lines that carry no resource or item ID.
  5. Read the hour quantity and the expense and item amounts on each resource or item row; compare hours with what was planned before they turn into cost.
  6. Check the hour total against Ledger updates - consumption, then ask for a forecast or budget update for any resource or item that runs ahead of plan.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesTurn on each project type to include; at least one must be on. Time projects post no ledger transactions, so they add hours but no amounts to financial totals.Microsoft Learn Time and material and Fixed-price on
Include transaction typesTurn on the transaction types to include: hours, expenses and items are what the consumption figures count.Microsoft Learn Hour, Expense and Item on
(Project date) From date / To dateLimits the report to transactions by the date of the work on the project.Checked in Dynamics 3651 October 2026 to 31 October 2026
(Ledger date) From date / To dateLimits the report to transactions by the date they were posted to the ledger, so totals line up with ledger periods.Checked in Dynamics 3651 October 2026 to 31 October 2026
Forecast modelThe forecast model that holds the budget figures. With project budget control, pick the original or remaining budget forecast model that the project's budget uses.Microsoft Learn BUD-REM
Actual vs. budgetActual (the default) shows posted figures; Budget shows the amounts in the chosen forecast model.Checked in Dynamics 365Actual
Skip zeroLeaves out rows where every amount is zero.Checked in Dynamics 365Yes
Show amountHow amounts are printed: With decimals (the default), without decimals, or in thousands or millions.Checked in Dynamics 365With decimals
Show hourWhether hour lines show the number of hours, their cost value or both.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
Fee and on-account amounts are missing from the report.The consumption dialog counts hours, expenses and items only; use the matching profit and loss report for fees and on-account billing. Checked in Dynamics 365

Test checklist

  1. Run Resource/item consumption for BEAT for October 2026 with W-0042 in the data.
  2. Open Posted project transactions filtered on the same project and dates.
  3. Check that the hour total on the W-0042 row equals the sum of the hour transactions, for example 214.00 hours.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Resource/item consumption reportSet Ledger date to the closed period first, then the project and transaction types; leave Actual vs. budget on Actual.Ledger date ties the consumption figures to what is in the general ledger for the period; Project date can include work that is not posted yet.Should Resource/item consumption filter on ledger date or project date?Reading the hour total as billable effort; it also counts internal and non-chargeable hours on the project types you turned on.Test: Resource/item consumption matches the source figures

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor, Chief executive officer and Chief financial officer can run this report.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer legal entity: the report reads the projects, transactions and setup of the company you run it in. Run it in each company to compare them. Checked in Dynamics 365
Can it be undoneReversible: Reversible: the report changes no data. Checked in Dynamics 365
If you change it laterRerun after timesheets, expense journals and item journals are posted; the consumption totals change with every posting for the dates. The report itself changes nothing downstream. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListProjConsumptionEmplItem Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListProjConsumptionEmplItem
Data migrationLoad order: Resource/item consumption has no data entity in Data management: it is a report. Move the project transactions, timesheets and forecasts it reads, and the report shows them when it runs.Checked in Dynamics 365
Everyone

8Sources