BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Project WIP (2 periods)

A report of the work in progress (WIP) balances held on balance sheet accounts, one row per project, for two ledger date ranges side by side. The report design is ProjWIPProj2Prd.

Business process
Analyze project performance
Menu item
output:ProjListProjWIPProj2ColumnPeriod
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 work in progress (WIP) balances held on balance sheet accounts, one row per project, for two ledger date ranges side by side. The report design is ProjWIPProj2Prd.
What you do hereIt answers how much cost, revenue or on-account billing is still held in WIP for each of the projects, as a period-on-period comparison, so the controller knows what still has to be recognized or eliminated. The Project manager, Project supervisor, CEO and CFO roles can run it on this system.
ExampleBEAT compares WIP at Q2 and Q3 2026 in Project WIP (2 periods). PRJ-0042 grew from 12,820.50 to 19,461.00, so the controller checks whether revenue recognition was calculated and posted for Q3.
Project WIP (2 periods) 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 revenue recognition is calculated and before it is posted, when you want to see how the figures moved from one period to the next.
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 showsWIP balances, one row per project, for period 1 and period 2 side by side. The report design is ProjWIPProj2Prd.

Source: Microsoft Learn

Setup steps on this page

Run the Project WIP (2 periods) report

Review work in progress (WIP) balances per project for two ledger date ranges side by side.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > WIP reports > Project WIP (2 periods).
  2. Turn on Fixed-price and Investment projects, whose costs and on-account amounts are held in WIP accounts until revenue is recognized or the project is eliminated, and the transaction types that build each project's WIP.
  3. Enter Ledger date - period 1 and Ledger date - period 2, for example September 2026 and October 2026, so the two WIP columns compare like with like.
  4. Set Project view to Project (the default) or to a grouping such as customer, and set Project level to 1 to see parent projects with their subprojects summed into them.
  5. Read the WIP balance on each project row; a balance that keeps growing on a finished project means revenue recognition or elimination has not been posted.
  6. Tie the WIP total to Ledger reconciliation - WIP, then calculate and post revenue recognition for the projects whose WIP should be released.

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. On this dialog the toggles are Time and material, Fixed-price, Investment and Internal.Checked in Dynamics 365Fixed-price and Investment on
Include transaction typesTurn on each transaction type to include. On this dialog the toggles are Hour, Expense, Item, Fee and On-account.Checked in Dynamics 365
Actual vs. budgetActual (the default) shows posted figures; Budget shows the amounts in the chosen forecast model.Checked in Dynamics 365Actual
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-ORIG
Project viewHow the first column is grouped: Project by default, or a grouping such as project group or customer.Checked in Dynamics 365Project
Project levelHow many subproject levels the rows show; 1 sums subprojects into their parent project.Checked in Dynamics 3651
Skip blank IDLeaves out lines that have no project 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
(Ledger date - period 1) From date / To dateThe ledger date range shown in the period 1 column.Checked in Dynamics 365
(Ledger date - period 2) From date / To dateThe ledger date range shown in the period 2 column.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
A Time and material project with posted cost shows no WIP.WIP only appears where the cost and revenue profile or project group posts to balance sheet WIP accounts; check the accounting setup of the project before reading the report. Microsoft Learn
The period 2 column is empty although work was done.Ledger date ranges only pick up transactions that are posted to the ledger; post the open journals and timesheets for period 2, then rerun. Checked in Dynamics 365

Test checklist

  1. Run Project WIP (2 periods) for BEAT for October 2026 with PRJ-0042 in the data.
  2. Open the WIP ledger account balance for the same date in the trial balance.
  3. Check that the report's WIP total equals the ledger balance; a difference goes to Ledger reconciliation - WIP.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Project WIP (2 periods) reportSet both ledger date ranges to complete periods of the same length first, then the project and transaction types.Unequal or open periods make one column look better or worse for reasons that are only about the calendar.Which two periods should Project WIP (2 periods) compare?Treating WIP as profit; WIP is cost or billing held on the balance sheet until revenue recognition or elimination is posted.Test: Project WIP (2 periods) 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 revenue recognition is calculated, posted or eliminated; those steps move amounts out of WIP. The report itself changes nothing downstream. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListProjWIPProj2ColumnPeriod 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:ProjListProjWIPProj2ColumnPeriod
Data migrationLoad order: Project WIP (2 periods) 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