BeyondERP.Newsletter
Menu

Setup step on the Resource/item forecast transactions page · Project management and accounting

Compare forecast hours per person with capacity

Read forecast hours per worker and quantities per item in one model.

Business process
Analyze project performance
Menu item
output:ProjListBudgetID
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 that lists forecast transactions of one forecast model grouped by resource or item: forecast hours per worker and forecast quantities per item. The report design is ProjListBudget.
What you do hereUse it to answer 'how many hours do we expect from each person, and how many units of each item?' for staffing and purchasing plans.
ExampleThe BEAT project assistant runs model FC-2026 for December with Hour and Item on and sees R-0105 forecast for 168.00 hours, 8.00 above capacity, and item CABLE-10 for 120.00 units, which goes to purchasing.
Resource/item forecast transactions 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

Business processAnalyze project performance
Menu pathProject management and accounting › Inquiries and reports › Forecast transactions reports › Resource/item forecast transactions
Set up firstHour forecasts Microsoft Learn
Used next byResource reservation analysis - Resource Microsoft Learn
Related pagesResource/item actual transactions Microsoft Learn
In this process Plan spending by category from the forecast
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 itBefore staffing and purchasing plans for the next months.
How oftenMonthly.
What the output showsForecast hours per worker and quantities per item for one model. The report design is ProjListBudget.

Source: Microsoft Learn

Setup steps on this page

Compare forecast hours per person with capacity

Read forecast hours per worker and quantities per item in one model.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Forecast transactions reports > Resource/item forecast transactions.
  2. Choose the Forecast model and turn on Hour for people or Item for materials.
  3. Enter the Project date range of the months you staff or buy for.
  4. Compare each worker's forecast hours with Resource reservation analysis - Resource, and pass item quantities to purchasing.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesWhich project types to include; the dialog toggles Time and material, Fixed-price, Investment, Internal and cost (Internal and Cost project types) and Time.Checked in Dynamics 365Time and material, Fixed-price, Investment
Include transaction typesHour and Item carry the worker or item on forecast lines.Checked in Dynamics 365Hour, Item
(Project date) From date / To dateThe range of forecast project dates; forecasts have no fiscal period.Microsoft Learn 1 November to 31 December
(Ledger date) From date / To dateLimits the report to transactions within a range of ledger dates.Microsoft Learn
Project statementThe statement the amounts follow; the dialog suggests Profit and loss.Checked in Dynamics 365Profit and loss
Forecast modelThe model whose forecast lines the report lists; a submodel shows only that part of the forecast. Budgets store their original and remaining amounts in two models, so budget data shows here too.Microsoft Learn FC-2026
Skip zeroLeave out rows where the amounts are zero.Microsoft Learn
Show amountHow amounts are shown; the dialog suggests With decimals.Checked in Dynamics 365With decimals
Show hourChoose whether to show hour quantities, hour cost values, or both.Microsoft Learn
PL ratioChoose whether to add a profit and loss ratio column, such as gross margin.Microsoft Learn

Common errors and fixes

MessageWhat to do
Forecast hours show without a worker.The forecast lines were entered for a role or without a resource; add the resource on the hour forecast lines. Microsoft Learn

Test checklist

  1. Forecast 40.00 hours for R-0105 on PRJ-0042 in FC-2026.
  2. Run the report for FC-2026 with Hour on.
  3. Check that R-0105 shows 40.00 hours.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Compare forecast hours per person with capacityChoose the model, turn on Hour or Item, and set the months you plan for.Forecast lines can carry a worker, a role or neither; only lines with a worker show per person.Are hour forecasts entered per worker or per role?Taking the per-worker total as the full forecast when part of it was entered for roles.Test: Hours per worker in the forecast

Feature management and licence

Licence or add-inOn the live system, Project assistant is the role that runs this report. Feature management controls whether this report skips the reporting framework's transaction scope (ProjSSRSSkipReportTransactionFeature), which helps large runs.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: forecast models are shared setup, but the forecast lines belong to the projects of the current legal entity. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterThe report shows the model as it is when you run it; forecast reduction and edits change it without history, so keep a copy of the original model for comparisons. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListBudgetID Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject assistant ProjProjectClerkGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListBudgetID
Data migrationLoad order: The Resource/item forecast transactions report has no data entity in Data management: it reads forecast lines. Load the forecasts with the forecast entities (for example ProjForecastEmplEntity for hours) and run the report to compare totals per model.Microsoft data model
Everyone

8Sources