Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Rolling Forecast Form for 12 months from the current month

edited Jul 31, 2020 6:32AM in Planning 3 comments

Summary

To create a rolling forecast form which always shows 12 periods from the current open period.

Content

Client requires to have a rolling forecast for 12 months, from the current open period. Each month they will open the current period, and expect to forecast the next 12 months. 

Calculations needs to be based on the actuals from the current month.

Ex: Current Open Period = July.   Financial Year = Apr: Mar FY 21

     Expected forecasted periods are  Aug 20 to July 21.

 

Currently we have created a fixed budget, based on the current year actuals taken from oracle GL. We are looking to use the same rules created for the fixed budget.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!