Cash Flow Beginning Balance of Last 12 Months

(0) Share

Report

Posted on by AmandaC

I am trying to write a cash flow statement that has a column for Last 12 Months calculations. I am having trouble pulling in the beginning balance for the last 12 months. This will change with each new base period selected. I can get the activity to pull by using the BASE-11:BASE in my period selection, however this can only be used with PERIODIC which doesn't allow for pulling the Beginning Balance. I know there are ways to do this manually, but I was hoping it could be a more automated process, so no one forgets to make the change.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (0)

Greg Byer 2,586 on at

Like (2)

Report

RE: Cash Flow Beginning Balance of Last 12 Months

Hi Amanda,

If you do BASE-11:BASE, you'll get the last 12 months, but not the beginning balance. If you do YTD, you'll get the beginning balance, but not the last 12 months. So, there's not a good way to do this. What you could try is to add a YTD/BB column and set the Period to BASE-11. That would give you the YTD beginning balance, 11 months back from the base period. You'd then have to create a CALC column that would add this column and the BASE-11:BASE column.

Hopefully others will have some suggestions for you as well.

Was this reply helpful? Yes No