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.
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
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.
What you do here
Use it to answer 'what do we expect to bill on account, and when?', mainly the billing schedules of Fixed-price projects.
Example
The 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.
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
Match on-account forecasts to the billing schedule
Check that forecast milestones match what the contract lets you bill.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Forecasts inquiries > On-account.
Filter on the Forecast model and the Fixed-price project you plan to bill.
Compare the forecast dates and amounts with the billing schedule agreed in the project contract.
Use Copy to repeat a line, or Edit to move a milestone date, then check the totals on Project forecast transactions.
Filter 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.
On the live system, Project manager, Project accountant and Project assistant maintain this page.
Checked in Dynamics 365
Solution architect
5Design impact
Shared or per company
Per 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 undone
Reversible: 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 later
Changes 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 item
ProjForecastOnAccChecked in Dynamics 365
Form
ProjForecastOnAccChecked in Dynamics 365
Table
ProjForecastOnAccShown as “On-account forecast” in Record infoKey field: ModelId, TransDate, ProjId, ProjFundingSource, ProjFundingSource_ContractId, ProjFundingSource_FundingSourceIdChecked in Dynamics 365
PrivilegesMaintain on-account forecasts ProjForecastOnAccMaintainView on-account forecasts ProjForecastOnAccViewDutiesMaintain project budgets ProjProjectBudgetsMaintainMaintain project forecasts ProjProjectForecastMaintainInquire into project forecast status ProjProjectForecastStatusInquire3 security rolesProject accountant ProjProjectAccountantProject assistant ProjProjectClerkProject manager ProjProjectManagerChecked in Dynamics 365
Roles to set it up and use it
To 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 page
Options: Personalize, Page options, ShareChecked in Dynamics 365
ProjForecastOnAccEntity 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