EAC calculation

[Megumi Fujioka]

A customer is asking how to set the reference date for EAC calculation.

EAC = Sum of all actuals for past fiscal periods + Sum of functional cost for future fiscal periods

Suppose it’s May 31 today – EAC still is; Sum of actuals for Jan. to Apr. + Sum of functional cost for May to Dec.

The question is how to set "at 01:00 on June 01, EAC will be Sum of actuals for Jan. to May + Sum of functional cost for Jun. to Dec.? Any help?

[Dhiren Aghera]

Hi @Megumi Fujioka To ensure consistency in the EAC calculation OOTB detects the current date and based on that current Fiscal period. So even if it last day of the month it will considered current month and EAC will be calculated accordingly as per your formula. Would recommend not to alter any OOTB calculations as it may later become more complicated. And even if you alter, it may be just for the last day, the system will still consider second last day of the month as current month only.

[Rajesh_Singh]

@Megumi Fujioka .

I agree with @Dhiren Aghera response. EAC calculation OOTB detects the current date and based on that current Fiscal period. I too request you to keep it OOTB. However If you still want to implement a custom EAC calculation based on a specific time or schedule, you can follow the below steps to create a script include and a scheduled job to update the EAC calculation based on your requirements.

1. Create a Script Include that contains the EAC calculation logic:

2. Create a Scheduled Script Execution (Scheduled Job) to run the EAC calculation at 01:00 on the first day of each month:

This will create a scheduled job that runs the EAC calculation at 01:00 on the first day of each month, updating the reference date used in the EAC calculation accordingly.