BeyondERP.Newsletter
Menu

Setup step on the Expense page · Project management and accounting

Charge project expenses with category and offset

Post expenses to the right project account.

Business process
Manage project delivery
Menu item
LedgerjournalTable7
Main table
LedgerJournalTable
Data entity
ExpenseJournalHeaderEntity
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 isThe project expense journal: a ledger journal of type Project expenses, where you enter expenses by project and category with an offset account and post them to the project and the ledger.
What you do hereUse it to charge costs such as materials bought on account, subcontractor fees or travel paid outside expense reports to a project, so project cost is complete and traceable.
ExampleFor example, BEAT charges a subcontractor fee of 3,200.00 to PRJ-0042 in expense journal PEXP-000118, category SUBCON, line property CHARGE, offset to the accrual account 2310, sales tax group STD.
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

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

Charge project expenses with category and offset

Post expenses to the right project account.

Steps from Microsoft

  1. Go to Project management and accounting > Journals > Expense.
  2. Select New, select the journal name, and then select Lines.
  3. On each line, select the project and the expense category, and enter the amount.
  4. Check the offset account, the sales tax groups and the line property.
  5. Review the entries for accuracy, then post the journal.
  6. Check the expense on Posted project transactions under the right category.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Project IDThe project the expense is charged to.Microsoft Learn PRJ-0042
CategoryThe project expense category; it decides the posting account and defaults the line property.Microsoft Learn SUBCON
Offset accountThe ledger account credited for the expense; defaults can be set on Default offset accounts for expenses.Microsoft Learn 2310
Line propertyDecides whether the expense is chargeable to the customer.Microsoft Learn CHARGE
Sales tax groupThe sales tax group used for the expense line.Checked in Dynamics 365STD

Common errors and fixes

MessageWhat to do
The expense posts to the wrong ledger account.The category decides the posting account; check the category's ledger posting setup and the default offset account for expenses. Microsoft Learn

Test checklist

  1. Create an expense journal line with project, expense category and amount.
  2. Review the line and post the journal.
  3. Check the expense in Posted project transactions under the right category.
  4. Check the voucher posts to the account set for that category.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Charge project expenses with category and offsetSet default offset accounts for expenses, and select the project and expense category on every line.The category decides the posting account and the line property; the offset account balances the entry.Where are project expenses paid outside expense reports entered?Using a general journal line to the cost account without project: the cost reaches the ledger but not the project.Test: Post a project expense

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: Posted expenses are corrected through project adjustments.
If you change it laterPosting debits the project cost or WIP account set for the category and credits the offset account; the cost then counts in project statements and invoicing. Microsoft Learn
Technical architect

6Technical

Menu itemLedgerjournalTable7 Checked in Dynamics 365
FormLedgerJournalTable Checked in Dynamics 365
TableLedgerJournalTableShown as “Ledger journal table” in Record infoKey field: JournalNumChecked in Dynamics 365
Data entitiesExpenseJournalHeaderEntityProject expense journal header Microsoft data model ExpenseJournalLineEntityProject expense journal lines Microsoft data model
Roles to set it up and use itTo set it up or change itProject manager ProjProjectManagerProject accountant ProjProjectAccountantProject assistant ProjProjectClerkField Service Integration User FieldServiceIntegrationUserRental manager RentalManagerTo use itChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerGive people one of these roles. On this system, 22 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=LedgerjournalTable7
Integrate withExpenseJournalHeaderEntity data entity Microsoft data model
Data migrationExpenseJournalHeaderEntity (Project expense journal header): loaded for each company.ExpenseJournalLineEntity (Project expense journal lines): loaded for each company.Load order: Load journal names, projects, project categories and ledger accounts first, then the journal headers, then the lines.Load first: Journal names, Projects, Project categories, Main accountsMicrosoft Learn
Table definitionLedgerJournalTable columns and relations Microsoft data model
Everyone

8Sources