News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Cash Flow Beginning Ba...

Finance | Project Operations, Human Resources, ...

Unanswered

Cash Flow Beginning Balance of Last 12 Months

(0) Share

Report

Report

Posted on by AmandaC

5

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

All responses Img

All responses (1)

Answers Img

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans