BeyondERP.Newsletter
Menu

Setup step on the Fee page · Project management and accounting

Check fees before invoicing

Confirm fee amounts and invoice status before the invoice proposal.

Used by
Chief executive officer, Field Service Integration User, Project accountant and 4 more roles
Business process
Analyze project performance
Menu item
ProjTransRevenue
Main table
ProjRevenueTrans
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 fee transactions on projects, with project date, project, category, resource, sales currency, sales price, line property, invoice status and transaction origin.
What you do hereUse it to answer 'which fees did we charge to the project and are they invoiced?'
ExampleThe BEAT project accountant checks PRJ-0042 before invoicing and finds the October management fee of 1,500.00 EUR from the fee journal, chargeable and not yet invoiced, plus September's fee already invoiced.
Fee 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 › Fee
Set up firstFee journal Microsoft Learn Sales price (fee) Microsoft Learn
Used next byProject invoice proposals Microsoft Learn
Related pagesFee forecasts Microsoft Learn
In this process Confirm when items were consumed · Reconcile milestones on a Fixed-price project
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 fees before invoicing

Confirm fee amounts and invoice status before the invoice proposal.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Transactions inquiries > Fee.
  2. Filter on Project ID and set Invoice status to see open fees.
  3. Check Sales price and Sales currency against the fee agreed in the contract.
  4. Include the open fee lines in the next invoice proposal, or adjust a wrong one on Adjust transactions.

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
Sales priceThe fee amount per unit that will be invoiced.Checked in Dynamics 3651,500.00
CategoryThe fee category; fee sales prices apply to Fixed-price projects as well as Time and material.Microsoft Learn FEE-MGMT

Common errors and fixes

MessageWhat to do
A fee shows a different price than the contract.Fee prices come from Sales price (fee); check the price set up for the project, contract or price group. Microsoft Learn

Test checklist

  1. Post a fee journal line of 1,500.00 EUR on PRJ-0042.
  2. Open the inquiry filtered on PRJ-0042.
  3. Check that one fee line of 1,500.00 EUR shows as not invoiced.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check fees before invoicingFilter on Project ID, then set Invoice status to the open state.Fees are billed as posted; a wrong price here reaches the customer invoice.How are recurring fees charged?Comparing fee lines with hour prices; fees take their price from Sales price (fee).Test: Open fee shows before invoicing

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 fee changes only through an adjustment; its invoice status changes when an invoice proposal with it is posted. Microsoft Learn
Technical architect

6Technical

Menu itemProjTransRevenue Checked in Dynamics 365
FormProjTransRevenue Checked in Dynamics 365
TableProjRevenueTransShown as “Project fee transactions” in Record infoKey field: TransDate, ProjId, 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 fee transactions ProjTransRevenueViewDutiesMaintain 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: Inquiries, FunctionsOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjTransRevenue
Data migrationLoad order: The Fee transactions inquiry has no data entity in Data management that writes posted transactions: lines are created by posting journals, timesheets or source documents. Open fees from a former system are loaded as fee beginning balance lines (ProjBeginningBalanceFeeEntity).Microsoft Learn
Table definitionProjRevenueTrans columns and relations Microsoft data model
Everyone

8Sources