BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Resource/item cash flow

A report of cash inflows, cash outflows and net cash flow, one row per resource (worker) or item, from paid and expected payments of project invoices and costs.

Business process
Analyze project performance
Menu item
output:ProjCashFlowEmplItem
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 cash inflows, cash outflows and net cash flow, one row per resource (worker) or item, from paid and expected payments of project invoices and costs.
What you do hereIt answers when cash comes in and goes out for each of the resources and items, so finance can plan cash and spot work that is done but not invoiced. Project managers, project supervisors, the CEO and the CFO can run it on this system.
ExampleBEAT runs Resource/item cash flow for December 2026. Item PUMP-200 shows an outflow of 12,600.00 on 4 December and the matching inflow of 15,900.00 only in January, which explains the dip.
Resource/item cash flow 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 itWhen you plan cash for the coming weeks, and at month end to compare cash with the forecast.
How oftenMonthly, or weekly in tight cash periods.
Batch settingsRun it from the dialog; run it in the background on a recurrence if it feeds a regular cash meeting.
What the output showsCash inflows, cash outflows and net cash flow, one row per resource (worker) or item.

Source: Microsoft Learn

Setup steps on this page

Run the Resource/item cash flow report

Review cash in and cash out per resource (worker) or item.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Cash flow reports > Resource/item cash flow.
  2. Turn on the project types and transaction types whose cash you plan for each resource or item, for example Time and material and Fixed-price with all transaction types.
  3. Enter the Payment date range you plan for, for example the next two months, and turn on both Include paid payment and Include expected payment for the full picture.
  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 cash inflows, outflows and net cash flow per resource or item; expected inflows are dated at due date plus the general and individual buffer days.
  6. For items or workers whose cost is paid long before it is billed, raise an on-account invoice or adjust the billing schedule.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include paid paymentIncludes payments already received from customers and paid to vendors.Checked in Dynamics 365Yes
Include expected paymentIncludes payments still expected. Expected inflow dates come from the invoice date, terms of payment and the general and individual buffer days.Microsoft Learn Yes
Include project typesTurn on each project type to include.Microsoft Learn Time and material and Fixed-price on
Include transaction typesTurn on each transaction type to include, for cash in (invoices) and cash out (costs).Microsoft Learn
Actual vs. budgetActual (the default) shows actual cash flows; Budget shows cash flows from the forecast model.Checked in Dynamics 365Actual
Forecast modelThe forecast model that holds the forecast cash flows when Actual vs. budget is Budget.Microsoft Learn FC-2026
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, without decimals, or in thousands or millions.Checked in Dynamics 365With decimals

Common errors and fixes

MessageWhat to do
Expected customer payments fall later than the customer usually pays.The expected date adds the General buffer days from the parameters and the Individual buffer days from the project contract to the due date; correct those days. Microsoft Learn

Test checklist

  1. Post a project invoice of 10,000.00 for PRJ-0042 dated 31 October 2026 with 14-day payment terms.
  2. Set General buffer days to 3 and Individual buffer days on the contract to 10.
  3. Run Resource/item cash flow with Include expected payment = Yes and check that the 10,000.00 inflow is dated 27 November 2026 (31 October + 14 + 13 days).

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Resource/item cash flow reportSet the Payment date range first and turn on both Include paid payment and Include expected payment.Paid payments alone show the past; expected payments alone hide cash already received. Both are needed for a net position.Should Resource/item cash flow add expected payments?Taking expected inflow dates as the customer's due date; they also include the general and individual buffer days.Test: Resource/item cash flow dates expected inflows with buffer days

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 invoices, payments or buffer days change; expected payment dates are recalculated from them. The report itself changes nothing downstream. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjCashFlowEmplItem 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:ProjCashFlowEmplItem
Data migrationLoad order: Resource/item cash flow 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