You can schedule an alert to run at regular intervals (for example, daily) to determine if today is equal to or greater than the day that Explanation of Variances need to be created. The determination is based on today’s date and the status date of the project.
If, for example, you schedule the Explanation of Variance (EoV) process to occur daily, the system will check each project daily to see if today is equal to or greater than the project's status date. If it is, the system then figures out if thresholds have been exceeded. If they have, an Explanation of Variance is created for each control account that exceeds the thresholds as defined on the Thresholds tab. If there are no thresholds defined for the selected code file, no EoV's are created.
To schedule the automatic creation of EoV's:
Set up the project for explain variance using the Thresholds tab in the project form view.
Select the Automatically Create Explain Variance Workflows option to include the selected project in the scheduled creation process.
Schedule the Creation of Explanation of Variances
Set up the Cost Analysis Color Banding Ranges
Set up a project for explain variance
Assign an Explanation of Variance