An inquiry that lists posted expense transactions on projects, with project date, project, category, resource, quantity, cost price, sales price, line property, invoice status and transaction origin.
Project management and accountingInquiries and reportsTransactions inquiries
ProjTransCost
Used by
Chief executive officer, Field Service Integration User, Project accountant and 4 more roles
Business process
Analyze project performance
Menu item
ProjTransCost
Main table
ProjCostTrans
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 is
An inquiry that lists posted expense transactions on projects, with project date, project, category, resource, quantity, cost price, sales price, line property, invoice status and transaction origin.
What you do here
Use it to answer 'which expenses landed on the project, where did they come from, and will they be billed?'
Example
The BEAT project manager sees 3,120.00 EUR of travel on PRJ-0042 in October; filtering the inquiry on category TRAVEL shows two vendor invoice lines of 980.00 EUR each and an expense journal line of 1,160.00 EUR, all chargeable.
The page in Dynamics 365. page title tab to open what to set or check
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
Check where project expenses came from
Trace expense lines back to journals, expense reports and vendor invoices.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Transactions inquiries > Expense.
Filter on Project ID and Category to see one kind of cost.
Read Transaction origin to see whether each line came from a journal, an expense report or a vendor invoice.
Check the Invoice status of chargeable lines, then include the open ones in the next invoice proposal.
Filter on Project ID and Category, then read Transaction origin.Expenses arrive from several documents; the origin tells you which document to correct.
On the live system, Project accountant and Project assistant maintain this page; Project manager, Project supervisor, Chief executive officer, Field Service Integration User and Service delivery manager view it.
A posted expense changes only through an adjustment, which reverses the original line and adds a new one. Microsoft Learn
Technical architect
6Technical
Menu item
ProjTransCostChecked in Dynamics 365
Form
ProjTransCostChecked in Dynamics 365
Table
ProjCostTransShown as “Project expense transactions” in Record infoKey field: TransDate, ProjId, ActivityNumber, CategoryId, LinePropertyId, Resource, Resource_Name, Resource_ResourceId, Resource_ResourceCompanyId, ResourceCategoryChecked in Dynamics 365
Who can open it
PrivilegesMaintain all posted project transactions ProjPostedProjectTransactionsMaintainView all posted project transactions ProjPostedProjectTransactionsViewView expense transactions ProjTransCostViewDutiesMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPostReview project transactions ProjProjectTransactionsReviewInquire into project transaction status ProjProjectTransactionStatusInquireApprove posting of service orders SMAServiceOrdersJournalize7 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorService delivery manager SMAServiceDeliveryManagerChecked in Dynamics 365
Roles to set it up and use it
To set it up or change itProject accountant ProjProjectAccountantProject assistant ProjProjectClerkTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserService delivery manager SMAServiceDeliveryManagerGive people one of these roles. On this system, 7 roles can open this page.Checked in Dynamics 365
Actions on the page
Actions: Functions, InquiriesOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer
7Developer
Open it by URL
https://<your-environment>/?mi=ProjTransCost
Data migration
Load order: The Expense transactions inquiry has no data entity in Data management that writes posted transactions: lines are created by posting journals, timesheets or source documents. Open expenses from a former system are loaded as beginning balance journal lines (ProjBeginningBalanceCostSaleEntity).Microsoft Learn