Updating User-Adjusted Columns

During a forecast update, the newly generated user-adjusted forecast values do not overwrite any existing manually modified values. The application compares the values in the user-editable Sales, Payroll %, Vacation Hours, Holiday Hours, and Other Hours columns in the Sysforecast and Master versions to determine when to update the Master version:

  • If the values in the Sysforecast and Master versions of a column are identical, this indicates that the values were not edited. Therefore, the application updates the Master version with the values from the Sysforecast version.
  • If the values in the Sysforecast and Master versions of a column are different, this indicates that the values were edited. Therefore, the application does not update that column in the Master version with the values from that column in the Sysforecast version.

For example, suppose that when comparing the Master and Sysforecast versions, the values for the Sales, Vacation Hours, and Holiday Hours columns do not match, but the Payroll % and Other Hours columns do match. The application replaces only the values in the Sales, Vacation Hours, and Holiday Hours columns of the Master version with the newly forecasted values from the Sysforecast version.