BeyondERP.Newsletter
Menu

Setup step on the Copy forecasts to ledger page · Project management and accounting

Transfer the project forecast to a ledger budget

Show the approved project plan in the ledger budget.

Business process
Plan projects
Menu item
action:ProjForecastBudgettransfer
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 isA periodic job that transfers the forecast transactions of a project forecast model to a general ledger budget model as budget amounts.
What you do hereUse it to turn an approved project forecast into ledger budget amounts, so budget reports in the general ledger show the project plan.
ExampleBEAT approves the 2026 forecast for PRJ-0042 in model FC-2026: 186,400.00 of cost. The project accountant transfers the cost and revenue statement types for project dates 01/01-12/31/2026 to ledger budget model BUD-2026, so the ledger budget report shows the project plan by month.
Copy forecasts to ledger 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 processPlan projects
Menu pathProject management and accounting › Periodic › Forecasts › Copy forecasts to ledger
Set up firstForecast models Microsoft Learn
Used next byBudget register entries Microsoft Learn
Related pagesCopy forecasts Microsoft Learn Delete forecasts Microsoft Learn
In this process Delete forecast transactions safely · Carry remaining project budgets forward
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.

When to run it

When to run itWhen a project forecast is approved and the ledger budget must reflect it.
How oftenOn demand, after each approved forecast revision.
Batch settingsRun in the background for models that cover many projects.
What the output showsBudget amounts in the chosen ledger budget model for the ledger dates. A later transfer to the same model can overwrite the earlier one.

Source: Microsoft Learn

Setup steps on this page

Transfer the project forecast to a ledger budget

Show the approved project plan in the ledger budget.

Steps from Microsoft

  1. Go to Project management and accounting > Periodic > Forecasts > Copy forecasts to ledger.
  2. Under Include statement, select the statement types to transfer.
  3. Enter the Project date range of the forecast transactions and the Ledger date range that receives the amounts.
  4. Select the From forecast model and the To ledger budget model. If the Cash flow project forecast feature is on, stop: transferring would count project forecasts twice in cash flow.
  5. Run the job and open Budgeting > Budget register entries for BUD-2026 to compare the total with the project forecast.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include statementThe statement types whose forecast transactions are transferred.Microsoft Learn Cost and Revenue
Project dateThe date range of the project forecast transactions to copy.Microsoft Learn 01/01/2026 to 12/31/2026
Ledger dateThe date range in the general ledger that receives the transferred amounts.Microsoft Learn 01/01/2026 to 12/31/2026
From forecast modelThe project forecast model to transfer.Microsoft Learn FC-2026
To ledger budget modelThe general ledger budget model that receives the amounts.Microsoft Learn BUD-2026

Common errors and fixes

MessageWhat to do
The cash flow forecast shows project amounts twice.With the Cash flow project forecast feature on, project forecasts already feed cash flow; don't also transfer them to a ledger budget model. Microsoft Learn

Test checklist

  1. Total the cost forecast of FC-2026 for 2026 (for example 186,400.00).
  2. Run the transfer to BUD-2026.
  3. Total the budget register entries of BUD-2026 for the ledger dates: 186,400.00.
  4. Run the transfer again and check the total is still 186,400.00.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Transfer the project forecast to a ledger budgetTransfer only approved forecast models, to a dedicated ledger budget model, and not at all when the Cash flow project forecast feature is on.A dedicated model can be overwritten safely; with the cash flow feature on, project forecasts are already in cash flow.Should project forecasts reach the ledger budget?Transferring while the Cash flow project forecast feature is on, which counts project forecasts twice.Test: Transfer a forecast model

Feature management and licence

Licence or add-inOn the live system, Project accountant uses this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the job reads project forecasts and writes ledger budget amounts of the legal entity you run it in. Microsoft data model
Can it be undonePartly reversible: A new transfer overwrites the earlier amounts in the same model.
If you change it laterCreates or overwrites general ledger budget amounts. Ledger budget reports, budget control and cash flow forecasts that include budget register entries change. Microsoft Learn
Technical architect

6Technical

Menu itemaction:ProjForecastBudgettransfer Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itProject accountant ProjProjectAccountantGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:ProjForecastBudgettransfer
Data migrationLoad order: Copy forecasts to ledger has no data entity in Data management: it is a periodic job and keeps no records of its own. Migrate project forecasts with their forecast entities and ledger budgets with the budget register entities, then rerun the transfer.Load first: ProjForecastEmplEntityMicrosoft data model
Everyone

8Sources