BeyondERP.Newsletter
Menu

Setup step on the Expense page · Project management and accounting

Check where project expenses came from

Trace expense lines back to journals, expense reports and vendor invoices.

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
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn 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 hereUse it to answer 'which expenses landed on the project, where did they come from, and will they be billed?'
ExampleThe 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.
Expense 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 › Transactions inquiries › Expense
Set up firstExpense journal Microsoft Learn
Used next byAdjust transactions Microsoft Learn
Related pagesCategory actual transactions Microsoft Learn
In this process Trace posted hours for one project · Confirm when items were consumed
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

Check where project expenses came from

Trace expense lines back to journals, expense reports and vendor invoices.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Transactions inquiries > Expense.
  2. Filter on Project ID and Category to see one kind of cost.
  3. Read Transaction origin to see whether each line came from a journal, an expense report or a vendor invoice.
  4. Check the Invoice status of chargeable lines, then include the open ones in the next invoice proposal.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Column displayChooses which group of columns the grid shows, for example prices.Checked in Dynamics 365Price
Invoice statusLimits the list to transactions in one invoicing state; All shows every state.Checked in Dynamics 365All
Transaction originThe document that created the expense line, such as an expense journal or a vendor invoice.Checked in Dynamics 365Vendor invoice
CategoryThe expense category posted; it decides the ledger accounts and the default line property.Microsoft Learn TRAVEL

Common errors and fixes

MessageWhat to do
A purchased service shows as expense but can't be invoiced.The purchase order line's line property decides chargeability; set a chargeable line property on the purchase order line. Microsoft Learn

Test checklist

  1. Post an expense journal of 1,160.00 EUR on PRJ-0042, category TRAVEL.
  2. Open the inquiry filtered on PRJ-0042 and TRAVEL.
  3. Check that one line of 1,160.00 EUR shows.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check where project expenses came fromFilter on Project ID and Category, then read Transaction origin.Expenses arrive from several documents; the origin tells you which document to correct.Should purchased services on projects default to chargeable?Assuming every vendor invoice line is billable; the line property set on the purchase order line decides it.Test: Expense origin is shown

Feature management and licence

Licence or add-inOn 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.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterA posted expense changes only through an adjustment, which reverses the original line and adds a new one. Microsoft Learn
Technical architect

6Technical

Menu itemProjTransCost Checked in Dynamics 365
FormProjTransCost Checked in Dynamics 365
TableProjCostTransShown 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 itPrivilegesMaintain 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 SMAServiceOrdersJournalize
7 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorService delivery manager SMAServiceDeliveryManager
Checked in Dynamics 365
Roles to set it up and use itTo 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 pageActions: Functions, InquiriesOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjTransCost
Data migrationLoad 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
Table definitionProjCostTrans columns and relations Microsoft data model
Everyone

8Sources