BeyondERP.Newsletter
Menu

Setup step on the Grant transactions page · Project management and accounting

Report grant spending with the right filters

Give funders correct figures.

Used by
Accountant, Project manager, Project supervisor
Business process
Manage project contracts
Menu item
ProjGrantTransactionsListPage
Main table
ProjPostTransView
Data entity
ProjPostTransViewEntity
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 isThe list of posted project transactions charged to grants, with project date, project, grant, category, resource and item, filtered by invoice status and transaction type.
What you do hereUse it to see what has been spent against each grant and what has been billed to the funder, for grant reporting and drawdowns.
ExampleFor example, for the quarterly report on GR-2026-03 BEAT's grant manager sets Transaction type to Hour and Invoice status to Invoiced and finds 342.00 hours billed, then checks the expense transactions of 6,800.00 still to bill.
Grant 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 processManage project contracts
Menu pathProject management and accounting › Grants › Grant transactions
Set up firstGrants Microsoft Learn
Used next byProject invoice proposals Microsoft Learn
Related pagesPosted project transactions Microsoft Learn
In this process Follow your grants by status and amount · Cost grant applications as project quotations
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.

Setup steps on this page

Report grant spending with the right filters

Give funders correct figures.

Steps from Microsoft

  1. Go to Project management and accounting > Grants > Grant transactions.
  2. In the Invoice status field, choose which transactions to show.
  3. In the Transaction type field, choose which transactions to show.
  4. Filter on the grant and the reporting period.
  5. Use the totals for the grant report, then bill the uninvoiced amounts through a project invoice proposal.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Invoice statusChooses which transactions to list by their invoicing state.Checked in Dynamics 365Invoiced
Transaction typeChooses which kind of transactions to list, for example Hour or Expense.Checked in Dynamics 365Hour
GrantThe grant the transaction is charged to.Microsoft Learn GR-2026-03
CategoryThe project category of the transaction.Checked in Dynamics 365HOURS

Common errors and fixes

MessageWhat to do
Hours posted to a grant-funded project don't appear for the grant.Check the project is linked to the grant, which needs the grant status Active or Awarded, and that the Invoice status filter includes the transaction. Microsoft Learn

Test checklist

  1. Post 8.00 hours on a project linked to an awarded grant.
  2. Open Grant transactions, set Transaction type to Hour.
  3. Filter on the grant.
  4. Check one transaction of 8.00 hours is listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Report grant spending with the right filtersSet Transaction type and Invoice status before reading totals, and filter on one grant and period.The filters decide whether you see spending, billed amounts or both.Which figure goes on the grant report?Reporting all statuses as billed: uninvoiced transactions are spent but not yet billed to the funder.Test: Hours for one grant

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor and Accountant use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the list shows the grant transactions of the legal entity you work in. Microsoft Learn
Can it be undoneReversible: Reversible: the list changes no data.
If you change it laterThe list reads posted project transactions; a project adjustment changes what is shown here as a reversal and a new transaction. Microsoft Learn
Technical architect

6Technical

Menu itemProjGrantTransactionsListPage Checked in Dynamics 365
FormProjGrantTransListPage Checked in Dynamics 365
TableProjPostTransViewShown as “Project transactions” in Record infoChecked in Dynamics 365
Data entitiesProjPostTransViewEntityProject posted transactions Microsoft data model
Who can open itPrivilegesMaintain grants ProjGrantMaintainView grants ProjGrantViewDutiesInquire into grant master ProjGrantMasterInquireInquireMaintain grant master ProjGrantMasterMaintain
3 security rolesAccountant LedgerAccountantProject manager ProjProjectManagerProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject manager ProjProjectManagerTo use itProject supervisor ProjProjectSupervisorAccountant LedgerAccountantGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageGrant transactions: Process, Maintain, Related informationOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjGrantTransactionsListPage
Integrate withProjPostTransViewEntity data entity Microsoft data model
Data migrationProjPostTransViewEntity (Project posted transactions): per company, transaction category.Load order: Posted transactions aren't loaded through this view; grant-funded opening balances go through the Beginning balance journal.Load first: Grants, ProjectsMicrosoft Learn
Everyone

8Sources

To cite this step: PM-OPS-360, Report grant spending with the right filters. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-OPS-360