BeyondERP.Newsletter
Menu

Page · Project management and accounting

Fee

The project fee journal: a project journal of fee transactions, which also receives the progress billings that billing rules and billing schedules generate.

Used by
Chief executive officer, Field Service Integration User, Machine operator and 5 more roles
Business process
Manage project financials
Menu item
ProjJournalTableRevenue
Main table
ProjJournalTable
Data entity
ProjJournalTableEntity
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 isThe project fee journal: a project journal of fee transactions, which also receives the progress billings that billing rules and billing schedules generate.
What you do hereUse it to record and post fees on projects, such as a fixed service charge, and to review the fee journals created when billing schedule lines are invoiced.
ExampleFor example, BEAT charges a fixed project management fee of 1,500.00 on PRJ-0042 each month through fee journal PFEE-000031 with category PMFEE and line property CHARGE, so it is picked up by the invoice proposal.
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

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

Post fees with a chargeable line property

Get fees onto the invoice.

Steps from Microsoft

  1. Go to Project management and accounting > Journals > Fee.
  2. Select New, select the journal name and enter a description, then select Lines.
  3. Select New and enter the project date, project, fee category, quantity and sales price.
  4. Check the line property, then select Post.
  5. Create an invoice proposal for the project and check the chargeable fee is offered.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
CategoryThe fee category; it sets the posting account.Microsoft Learn PMFEE
Sales priceThe fee amount per unit.Microsoft Learn 1,500.00
Line propertyDecides whether the fee is chargeable to the customer.Microsoft Learn CHARGE
Journal nameThe fee journal name that sets the voucher series.Checked in Dynamics 365PFEE

Common errors and fixes

MessageWhat to do
A fee doesn't appear on the invoice proposal.Check the line property is chargeable; a fee with a non-chargeable line property is never offered for invoicing. Microsoft Learn

Test checklist

  1. Pick a Time and material project and open Project management and accounting > Journals > Fee.
  2. Create a journal, add a line with a fee category, sales price and line property, and post it.
  3. Open the project's posted transactions and check the fee shows as a Fee transaction with the expected line property (chargeable or not).
  4. Create an invoice proposal for the project and check the chargeable fee is picked up.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Post fees with a chargeable line propertyUse a fee category with a sales price from Sales price (fee) and a chargeable line property for fees the customer pays.The line property decides whether the fee is invoiced; the category sets the account.How are recurring project fees charged?Posting a fee journal created by a billing schedule by hand twice: the billing rule already generated it.Test: Fee reaches the proposal

Feature management and licence

Licence or add-inOn the live system, Project manager, Project accountant, Project assistant and Field Service Integration User use this page.

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 undoneHard to reverse: A posted fee transaction is not edited in the journal. You correct it through Adjust transactions, and only if its transaction status (for example Posted or Invoiced) is allowed for adjustment on the Project management and accounting parameters page. Microsoft Learn
If you change it laterWhen a billing schedule line is invoiced with Generate invoice, the system creates a fee journal with all the billing schedule lines. Microsoft Learn
Technical architect

6Technical

Menu itemProjJournalTableRevenue Checked in Dynamics 365
FormProjJournalTable Checked in Dynamics 365
TableProjJournalTableShown as “Project journal table” in Record infoKey field: JournalId, JournalType, JournalNameId, Description, TimesheetNbrChecked in Dynamics 365
Data entitiesProjJournalTableEntityProject hour journals Microsoft data model
Who can open itPrivilegesMaintain fee journals ProjJournalTableRevenueMaintainView fee journals ProjJournalTableRevenueViewDutiesMaintain project journals and journal transactions ProjProjectJournalsMaintainApprove project transactions ProjProjectTransactionApproveMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPostReview project transactions ProjProjectTransactionsReviewInquire into project transaction status ProjProjectTransactionStatusInquire
8 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserMachine operator JmgMachineOperatorShop supervisor JmgShopSupervisorProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject manager ProjProjectManagerProject accountant ProjProjectAccountantProject assistant ProjProjectClerkField Service Integration User FieldServiceIntegrationUserMachine operator JmgMachineOperatorTo use itProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjJournalTableRevenue
Integrate withProjJournalTableEntity data entity Microsoft data model
Data migrationProjJournalTableEntity (Project hour journals): loaded for each company; covers fee journal headers through the journal name.Load order: Load journal names, projects, categories and line properties first, then the journal headers. Open journals are usually posted in the old system instead.Load first: Project journal names (ProjJournalNameEntity), Projects, Project categories, Line propertiesMicrosoft Learn
Table definitionProjJournalTable columns and relations Microsoft data model
Everyone

8Sources