The project fee journal: a project journal of fee transactions, which also receives the progress billings that billing rules and billing schedules generate.
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 is
The 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 here
Use 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.
Example
For 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.
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
Post fees with a chargeable line property
Get fees onto the invoice.
Steps from Microsoft
Go to Project management and accounting > Journals > Fee.
Select New, select the journal name and enter a description, then select Lines.
Select New and enter the project date, project, fee category, quantity and sales price.
Check the line property, then select Post.
Create an invoice proposal for the project and check the chargeable fee is offered.
Use 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.
Hard 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 later
When 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 item
ProjJournalTableRevenueChecked in Dynamics 365
Form
ProjJournalTableChecked in Dynamics 365
Table
ProjJournalTableShown as “Project journal table” in Record infoKey field: JournalId, JournalType, JournalNameId, Description, TimesheetNbrChecked in Dynamics 365
PrivilegesMaintain 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 ProjProjectTransactionStatusInquire8 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserMachine operator JmgMachineOperatorShop supervisor JmgShopSupervisorProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChecked in Dynamics 365
Roles to set it up and use it
To 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 page
Options: Personalize, Page options, Edit, ShareChecked in Dynamics 365
ProjJournalTableEntity (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