BeyondERP.Newsletter
Menu

Setup step on the Category actual transactions page · Project management and accounting

Compare spending by category

See which cost or revenue categories grow across projects.

Business process
Analyze project performance
Menu item
output:ProjListTransCategory
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 posted project transactions grouped first by project category, with amounts per category for the project and ledger dates you choose. The report design is ProjListTrans.
What you do hereUse it to answer 'what did we spend on each kind of cost or earn on each kind of revenue across projects?', for example travel against consulting.
ExampleBEAT's finance lead runs the report for October with Expense on and Level 1 Category and sees TRAVEL at 12,300.00 EUR across 9 projects, 40.00 percent above September, so travel approvals are reviewed.
Category actual 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 › Actual transactions reports › Category actual transactions
Set up firstProject categories Microsoft Learn
Used next byLedger posting setup Microsoft Learn
Related pagesProject actual transactions Microsoft Learn Category forecast transactions Microsoft Learn
In this process Close the period by project · Review posted hours per person
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 itMonthly, when you compare spending by category across projects.
How oftenMonthly.
What the output showsPosted amounts per category, with the projects at the next level if chosen. The report design is ProjListTrans.

Source: Microsoft Learn

Setup steps on this page

Compare spending by category

See which cost or revenue categories grow across projects.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Actual transactions reports > Category actual transactions.
  2. Turn on only the transaction type whose categories you compare, for example Expense for travel and hotel.
  3. Set the Project date range to the months you compare and turn on Skip zero to hide unused categories.
  4. Add Project at Level 2 so each category shows the projects behind it.
  5. Raise categories that grew sharply with the budget owner, and check their posting setup if amounts look misplaced.

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 365All but Time
Include transaction typesHour, Expense, Item, Fee and On-account; for a cost review turn on Expense only.Checked in Dynamics 365Expense
(Project date) From date / To dateThe range of project dates: when the work was done.Microsoft Learn 1 October to 31 October
(Ledger date) From date / To dateThe range of ledger dates: when the transactions were posted to the ledger.Microsoft Learn
Project statementThe statement the amounts follow; the dialog suggests Profit and loss.Checked in Dynamics 365Profit and loss
Skip zeroLeaves out rows whose amounts are zero.Checked in Dynamics 365Yes
Show amountChoose how amounts appear, such as with or without decimals, or in thousands.Microsoft Learn
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
Layout - rowsLevel 1 is Category on this report; add Project at Level 2 to see which projects carry each category.Checked in Dynamics 365Level 1 Category, Level 2 Project

Common errors and fixes

MessageWhat to do
A category you expected isn't listed.It had no transactions in the range and Skip zero hid it, or its transaction type is turned off. Checked in Dynamics 365

Test checklist

  1. Post two expenses of 300.00 EUR in TRAVEL on two projects.
  2. Run the report with Expense on and Level 1 Category.
  3. Check that TRAVEL shows 600.00 EUR.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Compare spending by categoryTurn on one transaction type, keep Level 1 on Category and add Project at Level 2.Category totals across projects show trends that per-project reports hide.Which levels does the monthly category review use?Mixing hour and expense categories in one run, so hours and money are compared.Test: Category total across projects

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor, Project accountant, Project assistant and Chief executive officer run this report. The report runs with the reporting framework's transaction scope switched off in code, so large runs don't hold the TempDB log; there is no switch to set.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the report reads the posted project transactions of the current legal entity. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterThe report reflects postings and adjustments at the moment it runs, so totals for a closed period change if transactions are adjusted later. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListTransCategory Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorProject accountant ProjProjectAccountantChief executive officer CompanyChiefExecutiveOfficerProject assistant ProjProjectClerkGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListTransCategory
Data migrationLoad order: The Category actual transactions report has no data entity in Data management: it reads posted project transactions. Open balances from a former system are loaded as beginning balance journals, which update only the project subledger, so compare their totals with this report after cutover.Microsoft Learn
Everyone

8Sources