Using the "Carry Forward From" option

This information was very helpful.

Thank you for sharing!

Thanks for sharing. Good to get additional insight.

Good information, thank you!

thanks for the insight.

Lots of great info here, thanks for sharing!

1 Like

interesting! might have to try something similar

Wow! Very creative approach. Thanks for sharing it.

Looks Good. look forward to more tips

Thank you for sharing.

Good work! Thanks for sharing.

Thanks for sharing! This is very interesting

Thanks for sharing.Great information.

Thanks for sharing the good information

Unfortunately I am not sure i can help with this.

This is a great idea, thanks!

We use named sets to help us determine actual vs forecasted months. Not the solution you are looking for unfortunately!

1 Like

I use the carry forward from actuals for our forecasting and have found it useful but we need to figure out a way of overwriting the actuals for a GL where we don’t have actual data in our ERP. I figured that we could journal the information in Prophix and that might work as it would create an ‘actual’ but I have yet to try it.

2 Likes

Great solution. Thanks!

We use a combination of EOMONTH formula and an IF statement to determine which months are actuals and which months are forecast. This allows us to see which months produce actuals in templates based on the roll forward for “current month” in the model manager.

2 Likes