BI4 Job Budget Forecast

Job Budget Forecast produces Profit and Loss with Actuals and Budgets for MTD, YTD and Full Year.

An Actual Forecast column is calculated as follows.

This report is a useful month-end report.

Forecast_Actual = Full_Year_Budget - YTD_Last_Month_Budget + YTD_Last_Month_Actuals
 
ie. Actual YTD Last Month + Remaining Budget for rest of Year

Based upon GL Profit & Loss 5.7

Status	Rev	Date	Notes	Ref
fix	6.2	17jun19	Duplicating Amount when using Report Group dimension	BIC-175 - Getting issue details... STATUS
new	6.1	01apr19	Added Report Group Dimesion
fix	6.0	20feb17	SQL Errors when Periods in Year = 13	BIC-133 - Getting issue details... STATUS
fix	5.9	14dec17	Job Mgr and JobLv2 Budget Dups - need two-part key in Consolidated Reports
fix	5.8	13dec17	Add two-part key for Consolidated reporting
fix	5.5	16aug16	Precautionary changes to stop Values duplication on Consolidated Files	BIC-50 - Getting issue details... STATUS
new	5.4	25Jul16	Debut

BI Knowledge Base