BeyondERP.Newsletter
Menu

Page · Project management and accounting

Beginning balance

The beginning balance journal for Project Operations integrated with ERP: it holds the actuals dated on or before the cut-off date and, when posted, updates only the project subledger, not the general ledger.

Used by
Chief executive officer, Field Service Integration User, Project accountant and 3 more roles
Business process
Manage project financials
Menu item
ProjJournalTableBegBal
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 beginning balance journal for Project Operations integrated with ERP: it holds the actuals dated on or before the cut-off date and, when posted, updates only the project subledger, not the general ledger.
What you do hereUse it at go-live to bring in the costs, revenue, WIP and billing of projects that were already under way, so revenue recognition and invoicing continue correctly.
ExampleFor example, BEAT goes live on 01/01/2027 with cut-off 31/12/2026; Import beginning balances creates a journal with 1,240.00 hours and 96,500.00 of unbilled sales for 18 running projects, which the accountant posts before the first revenue recognition run.
Beginning balance 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 processManage project financials
Menu pathProject management and accounting › Journals › Beginning balance
Set up firstProject management and accounting parameters Microsoft Learn
Used next byCreate revenue recognition Microsoft Learn
Related pagesPosted project transactions Microsoft Learn
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

Load project opening balances through Import beginning balances

Start running projects with correct subledger balances.

Steps from Microsoft

  1. Go to Project management and accounting > Journals > Beginning balance.
  2. If no journal is listed, set Create beginning balances, the As of date and the journal name on the parameters, then run Periodic > Project operations integration > Import beginning balances.
  3. Select the journal created by the import, and then select Lines.
  4. Check the lines cover the actuals dated on or before the cut-off date.
  5. Select Post to post the journal.
  6. Run revenue recognition for the beginning balances.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Create beginning balancesParameter on the General tab that turns on beginning balance journals.Microsoft Learn Yes
As of dateThe cut-off date; actuals on or before it go to this journal, later ones to the integration journal. It can't be changed after the first posting.Microsoft Learn 31/12/2026
Beginning balance journal nameThe journal name the import uses for the beginning balance journal.Microsoft Learn PBEG
Transaction statusSet per contract line type; billed sales are created as Fully invoiced, costs and unbilled sales as Posted.Microsoft Learn Posted

Common errors and fixes

MessageWhat to do
Billed milestones and retainers are missing from the beginning balances.These aren't supported by the beginning balance feature; migrate fully invoiced billing milestones with the milestone cutover process. Microsoft Learn

Test checklist

  1. On the parameters General tab select Create beginning balances, set the As of date and the journal name.
  2. Run Import beginning balances and check a Beginning balance journal is created with actuals dated on or before the cut-off date.
  3. Post the journal and check project transactions appear with no ledger voucher.
  4. Check the As of date can no longer be edited.
  5. Import an actual dated after the cut-off and check it goes to the integration journal instead.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Load project opening balances through Import beginning balancesTurn on the feature, set Create beginning balances, the As of date and the journal name, run Import beginning balances and post the journal before any revenue recognition.The cut-off date can't be changed after the first posting, and the journal updates only the project subledger, so the ledger balances must already be loaded separately.How are project opening balances loaded?Expecting general ledger entries from the journal: it generates none, so the opening ledger balances are a separate load.Test: Post beginning balances

Feature management and licence

Feature to turn onEnable beginning balances in Project Operations Integrated with ERP (Must be on)
Licence or add-inOn the live system, Project accountant, Project assistant, Project manager and Project supervisor use this page. The page needs the feature Enable beginning balances in Project Operations Integrated with ERP and Dynamics 365 Finance 10.0.46 or later, for Project Operations integrated with ERP deployments.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneOne-way: Warning: the cut-off date (As of date) on the parameters becomes non-editable after the first Beginning balance journal transaction is posted. Posting creates project subledger entries only, with no general ledger entries. Microsoft Learn
If you change it laterThe cut-off date can't be changed after the first beginning balance transaction is posted. Microsoft Learn
Technical architect

6Technical

Menu itemProjJournalTableBegBal 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 beginning balance journals ProjJournalTableBegBalMaintainView beginning balance journals ProjJournalTableBegBalViewDutiesMaintain project transactions ProjProjectTransactionsMaintainMaintain project transactions ProjProjectTransactionsMaintainNoPostReview project transactions ProjProjectTransactionsReviewInquire into project transaction status ProjProjectTransactionStatusInquire
6 security rolesChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserProject 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 accountant ProjProjectAccountantProject assistant ProjProjectClerkTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerField Service Integration User FieldServiceIntegrationUserGive people one of these roles. On this system, 6 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=ProjJournalTableBegBal
Integrate withProjJournalTableEntity data entity Microsoft data model
Data migrationProjJournalTableEntity (Project hour journals): backed by ProjJournalTable; the beginning balance lines themselves are created by Import beginning balances, not loaded.Load order: Bring the actuals into Project Operations journals first; Import beginning balances then creates this journal from the actuals on or before the As of date.Load first: Project Operations actuals dated on or before the cut-off date, Parameters: Create beginning balances, As of date, journal nameMicrosoft Learn
Table definitionProjJournalTable columns and relations Microsoft data model
Everyone

8Sources