BeyondERP.Newsletter
Menu

Setup step on the Resource/item profit and loss page · Project management and accounting

Run the Resource/item profit and loss report

Review revenue, cost and gross margin per resource (worker) or item for one date range.

Business process
Analyze project performance
Menu item
output:ProjListProjProfitLossEmplItem
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 isA report of revenue, cost and gross margin, one row per resource (worker) or item, for one date range, built from posted project transactions. The report design is ProjProfitLossEmpl.
What you do hereIt answers which resources and items make or lose money, as a snapshot for one period. On this system the Project manager, Project supervisor, CEO and CFO roles can run it; use it at month end to decide where to act on price, cost or scope.
ExampleBEAT runs Resource/item profit and loss for October 2026 on Time and material and Fixed-price projects. W-0042 shows revenue 18,000.00 against cost 12,000.00; the controller checks that the October hours were accrued before the figures go to the CFO.
Resource/item profit and loss 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 itAt month end, after costs are posted and revenue is accrued or invoiced.
How oftenMonthly
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 showsRevenue, cost and gross margin, one row per resource (worker) or item. The report design is ProjProfitLossEmpl.

Source: Microsoft Learn

Setup steps on this page

Run the Resource/item profit and loss report

Review revenue, cost and gross margin per resource (worker) or item for one date range.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Profit and loss reports > Resource/item profit and loss.
  2. Turn on the project types and transaction types the resource or item figures should cover; for revenue and margin keep Time and material and Fixed-price on with all transaction types, because Time projects carry no ledger amounts.
  3. Enter From date and To date under Ledger date to tie the profit and loss 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 revenue, cost and gross margin on each resource or item row; a row with cost but no revenue usually means hours are posted but not yet accrued or invoiced.
  6. Tie the total to Ledger reconciliation - profit and loss for the same dates, then follow up the resource or item with the weakest margin with its project manager.

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 each transaction type to include, such as Hour, Expense, Item, Fee and On-account.Microsoft Learn
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 blank IDLeaves out lines that have no resource or item ID.Checked in Dynamics 365
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
PL ratioWhich profit and loss ratio, such as the gross margin percentage, is added to each row.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
A resource or item shows cost but no revenue for the dates.For Time and material projects, revenue appears when it is accrued or invoiced; run Accrue revenue or post the invoice, then rerun the report. Microsoft Learn

Test checklist

  1. Run Resource/item profit and loss for BEAT for October 2026 with W-0042 in the data.
  2. Open the project's statement for the same dates and project types.
  3. Check that revenue and cost on the W-0042 row match the statement to the cent.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Resource/item profit and loss reportSet Ledger date to the closed period first, then the project and transaction types; leave Actual vs. budget on Actual.Ledger date ties the profit and loss figures to what is in the general ledger for the period; Project date can include work that is not posted yet.Should Resource/item profit and loss filter on ledger date or project date?Reading a resource or item with cost and no revenue as a loss, when the revenue is simply not accrued or invoiced yet.Test: Resource/item profit and loss 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: The report changes no data.
If you change it laterRerun after Post costs, Accrue revenue, invoice posting or adjustments; the figures change as soon as new transactions are posted for the dates. The report itself changes nothing downstream. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListProjProfitLossEmplItem 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:ProjListProjProfitLossEmplItem
Data migrationLoad order: Resource/item profit and loss 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