BeyondERP.Newsletter
Menu

Inquiry page · Project management and accounting

On-account

An inquiry that lists on-account forecast lines, with forecast model, project date, project, description, sales currency and sales price. You can also enter and edit them here.

Used by
Project accountant, Project assistant, Project manager
Business process
Plan projects
Menu item
ProjForecastOnAcc
Main table
ProjForecastOnAcc
Data entity
ProjForecastOnAccEntity
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 isAn inquiry that lists on-account forecast lines, with forecast model, project date, project, description, sales currency and sales price. You can also enter and edit them here.
What you do hereUse it to answer 'what do we expect to bill on account, and when?', mainly the billing schedules of Fixed-price projects.
ExampleThe BEAT project accountant checks model FC-2026 for Fixed-price project PRJ-0057 and finds three on-account lines: 20,000.00 EUR on signing, 30,000.00 EUR at first delivery and 50,000.00 EUR at final delivery.
On-account 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 › Inquiries and reports › Forecasts inquiries › On-account
Set up firstForecast models Microsoft Learn Project contracts Microsoft Learn
Used next byCopy forecasts Microsoft Learn Copy forecasts to ledger Microsoft Learn
Related pagesOn-account transactions Microsoft Learn Project on-account (actual vs. budget) 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

Match on-account forecasts to the billing schedule

Check that forecast milestones match what the contract lets you bill.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Forecasts inquiries > On-account.
  2. Filter on the Forecast model and the Fixed-price project you plan to bill.
  3. Compare the forecast dates and amounts with the billing schedule agreed in the project contract.
  4. Use Copy to repeat a line, or Edit to move a milestone date, then check the totals on Project forecast transactions.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Forecast modelThe forecast model that the on-account line belongs to.Microsoft Learn FC-2026ModelId
Project dateThe date the on-account amount is expected to be billed.Microsoft Learn 2026-12-15
Sales priceThe forecast on-account amount for the line.Checked in Dynamics 36530,000.00

Common errors and fixes

MessageWhat to do
On-account forecasts on a Time and material project don't match its invoices.Time and material projects bill hours, expenses, items and fees; use on-account forecasts for Fixed-price billing schedules. Microsoft Learn

Test checklist

  1. Enter three on-account lines on PRJ-0057 in FC-2026 for 20,000.00, 30,000.00 and 50,000.00 EUR.
  2. Filter the inquiry on FC-2026 and PRJ-0057.
  3. Check that the three lines total 100,000.00 EUR.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Match on-account forecasts to the billing scheduleFilter on the Forecast model and the Fixed-price project; compare dates and amounts with the billing schedule.Fixed-price invoices consist of on-account transactions billed on a schedule, so the forecast must follow that schedule.Should on-account forecasts mirror the billing schedule exactly?Treating these lines as the billing schedule itself; invoices use the on-account transactions, not the forecast.Test: On-account forecast totals the contract value

Feature management and licence

Licence or add-inOn the live system, Project manager, Project accountant and Project assistant maintain this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: forecast lines belong to the legal entity of the project, and each line sits in one forecast model. Microsoft data model
Can it be undoneReversible: Reading changes nothing. Edits and deletions here change the forecast model at once and keep no history; copy the model first if you need the original. Microsoft Learn
If you change it laterChanges to on-account forecasts change cash inflow and revenue views on the model at once; they don't change the billing schedule that invoices use. Microsoft Learn
Technical architect

6Technical

Menu itemProjForecastOnAcc Checked in Dynamics 365
FormProjForecastOnAcc Checked in Dynamics 365
TableProjForecastOnAccShown as “On-account forecast” in Record infoKey field: ModelId, TransDate, ProjId, ProjFundingSource, ProjFundingSource_ContractId, ProjFundingSource_FundingSourceIdChecked in Dynamics 365
Data entitiesProjForecastOnAccEntityProject on-account forecasts Microsoft data model
Who can open itPrivilegesMaintain on-account forecasts ProjForecastOnAccMaintainView on-account forecasts ProjForecastOnAccViewDutiesMaintain project budgets ProjProjectBudgetsMaintainMaintain project forecasts ProjProjectForecastMaintainInquire into project forecast status ProjProjectForecastStatusInquire
3 security rolesProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject manager ProjProjectManagerProject accountant ProjProjectAccountantProject assistant ProjProjectClerkGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjForecastOnAcc
Integrate withProjForecastOnAccEntity data entity Microsoft data model
Data migrationProjForecastOnAccEntity Project on-account forecasts; loads the lines of this page.Load order: Load forecast models and Fixed-price projects, then on-account forecasts with ProjForecastOnAccEntity.Load first: Forecast models, Projects V2 (ProjProjectV2Entity)Microsoft data model
Table definitionProjForecastOnAcc columns and relations Microsoft data model
Everyone

8Sources