Populate Prior Periods Forecast From Actuals in Cost Plans – SQL

The Populate Prior Periods Forecast From Actuals in Cost Plans process updates Cost Plans for Active Projects, it updates the Forecast for previous months = Posted Actuals, to remove variances from past periods.

This is an On Demand process in Clarity named Populate Prior Periods Forecast From Actuals in Cost Plans and can be manually executed from the Organizer or scheduled through the “Execute a Process” job. If there are number of processes in the Organizer – Available Processes, this process can be filtered and then checked to Start. When the process is started it will be seen in the Initiated on the Processes tab. The process status can be monitored from Running to the Completed stage.

The process is very flexible and supports Cost Plans with any given grouping and it also works without any dependency on timeslices or other jobs. The process fetches Cost plan of records for all active projects in the system that have Actuals transactions in WIP table. It then process those cost plans to update all of the prior monthly forecast periods with the corresponding monthly Actuals.