BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Ledger updates - consumption

A report that lists the general ledger updates made by project consumption, the cost of hours, expenses and items posted to projects, per project for a ledger date range.

Business process
Manage project financials
Menu item
output:ProjListLedgerUpdatesConsumption
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 that lists the general ledger updates made by project consumption, the cost of hours, expenses and items posted to projects, per project for a ledger date range.
What you do hereUse it at period close to see which project costs reached the ledger, and on which date, before you compare with actual cost.
ExampleFor October 2026 BEAT's project manager sees PRJ-0042 with 18,950.00 of consumption ledger updates: 12,400.00 hours, 3,550.00 expenses and 3,000.00 items, matching actual cost on the Cost control page.
Ledger updates - 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

Business processManage project financials
Menu pathProject management and accounting › Inquiries and reports › General ledger reconciliation reports › Ledger updates - consumption
Set up firstPost all approved timesheets Microsoft Learn
Used next byLedger reconciliation - profit and loss Microsoft Learn
Related pagesLedger updates - WIP Microsoft Learn Project consumption Microsoft Learn
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 period close, when you review how project consumption (items and expenses) was posted to the ledger.
How oftenOn demand, at period close.
What the output showsProject cost reaches the ledger only when the cost and revenue profile posts that transaction type to Balance or Profit and loss; with No ledger it is posted later through Post costs, with Never ledger never. The report changes nothing; it only lists amounts.

Source: Microsoft Learn

Setup steps on this page

Set the ledger dates and layout for Ledger updates - consumption

Get a result that can be matched with the general ledger for one period.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > General ledger reconciliation reports > Ledger updates - consumption.
  2. Under Ledger date, enter the From date and To date of the consumption postings to review.
  3. Under Layout, choose the Project view and Project level to group hour, expense and item consumption per project.
  4. Turn on Skip zero, run the report, and compare each project's consumption with actual cost on the project's Cost control page.
  5. For a project with consumption but no ledger update, check its cost and revenue profile: No ledger or Never ledger posts nothing now.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
From dateFirst ledger date of the postings to include.Checked in Dynamics 3652026-10-01
To dateLast ledger date of the postings to include.Checked in Dynamics 3652026-10-31
Project viewGroups the rows of the report, for example by project.Checked in Dynamics 365Project
Project levelHow many levels of subprojects are shown; 0 shows the project level as grouped.Checked in Dynamics 3650
Skip zeroLeave out rows whose amounts are zero.Checked in Dynamics 365Yes

Common errors and fixes

MessageWhat to do
A posted transaction has no consumption ledger update.Check its ledger date against the range and the cost and revenue profile of the project: with No ledger the cost is posted later by Post costs, with Never ledger never. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set the ledger dates and layout for Ledger updates - consumptionUse the ledger date range of the period and group by Project so that each voucher can be traced to one project.The report lists the ledger updates of consumption postings; grouping by project lets you match them with the project reports of the same family.How do you group the ledger updates?Expecting all project transactions here: transactions whose cost and revenue profile posts nothing to the ledger now (No ledger, Never ledger) make no ledger update.Test: Ledger updates - consumption matches a known posting

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 page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer legal entity: the report reads only the project data of the company you are signed in to, so run it in each company you close. Checked in Dynamics 365
Can it be undoneReversible: the report changes no data: The consumption ledger updates report only reads data; it changes nothing. Microsoft Learn
If you change it laterProject cost reaches the ledger only when the cost and revenue profile posts that transaction type to Balance or Profit and loss; with No ledger it is posted later through Post costs, with Never ledger never. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListLedgerUpdatesConsumption 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:ProjListLedgerUpdatesConsumption
Data migrationLoad order: Ledger updates - consumption has no data entity in Data management: the menu item ProjListLedgerUpdatesConsumption opens a report that only reads posted project data. There is nothing to migrate for the report itself; load the project data it reads, for example opening balances through Journals > Beginning balance, then run the report in the new system and compare its totals with the old one.Checked in Dynamics 365
Everyone

8Sources