Refreshing Job Forecast Balances

Occasionally, after a forecast has been created, data that is critical to the forecast is updated in the general ledger, such as:

  • Current Actuals (ledger types AA/AU)

  • Budgets (ledger types JA/JU)

  • Open commitments (ledger types PA/PU)

  • Pending change orders (ledger type from the processing options).

To pull updated data from the general ledger into the forecast, you can use the Refresh Balances feature. This feature is available only in the following situations:

  • When the Forecast Status is set to Open and the processing options for the P51F100 are set to allow balance refresh.

  • When the Forecast Status is set to In Review and the processing options for the P51F100 are set to allow both allow balance refresh and updates to a forecast when it is in the In Review status.

To refresh the balances for a forecast:

  1. From the Work With Job Forecasts form, search for and select the forecast you want to update.

  2. From the Row menu, select Refresh Balances.

    This menu option is only available if you are allowed to refresh the balances on the selected forecast.

  3. Click the Refresh button. The system retrieves the updated data from the general ledger using the existing Thru G/L Date on the forecast. The system also updates the Forecast Basis Date and Time to reflect the recent update.

    Note that the system does not update or delete any data that you might have entered previously in the editable fields.