Contract Forecasting - Color Highlights and Hover Text for Cost to Complete and Cost Forecast Columns

The following color and hover text will appear for the Cost to Complete column, as well as the Projected Cost Forecast column. This is applicable for A method lines.

Field	Sigma Grid Forecast Highlight Color	Kendo Grid Forecast Highlight Color	Hover Text
CTC (with details)	Yellow	Yellow	Cost to complete has detail lines
CTC (with details)	Red	Yellow	Cost to Complete detail lines are not in sync with the Projected Cost
Projected Cost Forecast	Red	Red	Spent/Committed exceeds the override from the previous forecast
Projected Cost Forecast (Incl. CO)	Light Green	Red	Spent/Committed exceeds the override from the previous forecast
Projected Cost Forecast	Red	Purple	The override from the previous stored forecast has been cleared NOTE: After changes have been made to the spent/committed amounts, the system will clear the overrides if the forecast is refreshed within the same period.
Projected Cost Forecast (Incl. CO)	Light Red	Purple	The override from the previous stored forecast has been cleared NOTE: After changes have been made to the spent/committed amounts, the system will clear the overrides if the forecast is refreshed within the same period.
Proj Cost Forecast (Incl. Pending CO)	Yellow	Orange	When the Spent/Committed Total (JCCF_ALL_SPENT_COMMITTED_AMT) amount is greater than the Current Budget (Cost) amount and there isn't an override by the user
Proj Cost Forecast (Incl. Pending CO)	Green	Blue	When there’s a previous period override for the line (jccf_prev_per_ovrd_flg=’Y’)

Projected Forecast Cost column will be colored in red when JccfOvrdAutoClearFlag is ‘Y’.

The auto clear override (JccfOvrdAutoClearFlag) is reset, when user manually overrides the cost to complete or projected cost amount.

When amounts are overridden (without saving), the red color disappears and the column will be highlighted in yellow, if conditions are fulfilled or no color if otherwise.

The hover messages (in case of red or yellow color) are now moved to properties file and may be changed using the entries as:
- jccf.projFcastCostAmtRedTitle = The override from the previously stored forecast has been cleared.
- jccf.projFcastCostAmtYellowTitle = The Cost to Complete override amount must be updated in order to synchronize with the stored Projected Cost Forecast amount.

Cost to Complete amount highlighted in red when jccf_ctc_popup_match_clac_flg is ‘Y’.
Enhancement for A-method override behavior when forecast exceeds previous forecast but less than budget.

For example:

Case:1

Period 2018/1

NO Previous Forecast Exists. For ‘A’ (Amounts) method lines,
- CTC Detail entries exist, and matches the main screen CTC = Yellow Highlight, Override check appears
- CTC Details DO NOT exist, but overridden in the main screen = No highlight, Override check appears

Period 2:

Case:1

Period 2018/2

Previous Forecast Exists, with overrides . For ‘A’ (Amounts) method lines, the overrides are carried forward

CTC Detail entries exist, and matches the main screen CTC = Yellow Highlight, Override check appears
CTC Details DO NOT exist, but overridden in the main screen = No highlight, Override check appears
CTC Detail entries exist, but overridden amount = Red Highlight, Override Check appears

The Cost to Complete fields on the Contract Forecasting screen are highlighted in yellow when matching details exist for ‘A’ lines in the Standard Cost Detail pop-up. The Enhanced Cost Detail pop-up also functions this way.

When the Cost to Complete column is displaying a frozen line with a negative amount, the amount is highlighted in light red.

Summary for Conditional Formatting in Cost To Complete (CTC) column:

Negative CTC: Red Text
CTC for A Lines Details Exist: Yellow highlight
CTC Detail Lines are NOT in sync with Projected Cost Forecast and when a line is frozen: Red Highlight
CTC is negative and detail lines are NOT in sync with Projected Cost Forecast and when a line is frozen: Red Text and Red highlight