Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter - ...
Microsoft Dynamics GP (Archived)

Management Reporter - Cash Flow

(0) ShareShare
ReportReport
Posted on by Timothy Sparks 290

Hello All
 
I'm building a Cash Flow statement and ran up against a problem.
Will you take a look at this at let me know what you think?
 
I get a "Circular row calculation reference detected between row 1450 and row 1450. Report will show zeroes for these rows"
And here is what our row format looks like. It looks exactly like what’s in the Management Reporter Book.
 

1330 DES
1360 NET INCREASE (Decrease) In Cash TOT 730+880+1270
1390 DES
1420 NP - Cash at Beginning of Period Account Modifier=[/BB] +Account = [10001:10103]
1450 Cash at Beginning of Period CAL B=B,1420,E=C,1420
1480 ---
1510 DES
1540 Cash and Equivalents at End of Period TOT 1360+1450

 
 
 

*This post is locked for comments

  • Peter White Profile Picture
    Peter White 60 on at
    RE: Management Reporter - Cash Flow

    HI Guys

    what does this mean B=B.1180, E=C.1180?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter - Cash Flow

    Dear Spark,

    Thanks for such detail explanation.

    It helps me alot.

    But one thing which I would like to know that no Balance at beginning shows when I want to see YTD 

    The account modifier shows Beginning Balance when my Column definition is Periodic

    No Balance shows when I change the definition from Periodic to YTD .

    What should I do ??

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter - Cash Flow

    Re-wrote line 905 to now read:

    "Closing Cash Balance", TOT, 880+890

    (line 880 is my "Calculated Net Change in Cash Flow")

    1) Now my MTD and YTD closing cash is calculating correctly, BUT...

    2) YTD opening cash still showing as $0 .: YTD closing cash = YTD change in cash.

    As soon as the YTD opening cash number comes in correctly, the YTD closing cash number will be correct.

    Thank you all.

    cg

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter - Cash Flow

    Hi All.  Having a problem with MR and my SCF.

    SCF is showing proper data for MTD: change, opening, closing cash.

    SCF is showing proper data for YTD: change in cash

    SCF is showing $0 for YTD: opening, closing cash  <--- this is the issue

    In my column definition...

    ---------------------------------------

    B = MTD

    C = YTD/BB ... (NP)

    D = YTD ... (NP)

    E = Calc (YTD - YTD/BB)

    In my row definition...

    ---------------------------------------

    line 885 = "NP - Cash, beginning of period", NP, Account Modifier=[/BB], +Natural = [10000:10999]

    line 890 = "Opening Cash Balance", CAL, "B=B.885, E=C.885"

    line 900 = "NP - Cash, end of period", NP, +Natural = [10000:10999]

    line 905 = "Closing Cash Balance", CAL, "B=D.900, E=D.900"

    Why for SCF/YTD am I getting $0 for opening/closing balance?

  • Suggested answer
    Timothy Sparks Profile Picture
    Timothy Sparks 290 on at
    RE: Management Reporter - Cash Flow

    Here's the Answer that worked for me. Sorry, Didn't realized I never responded to this :-)

    From what I can see everything looks correct except for one thing:

    On row 1450 you have - B=B,1420,E=C,1420

    It should be - B=B.1420,E=C.1420

    It appears you have comma's (,) instead of periods (.)

    I would give this a try at this point to see if it resolves the issue.

  • linda krawiecki Profile Picture
    linda krawiecki 75 on at
    RE: Management Reporter - Cash Flow

    Here is how I have it set up, I do have the priority set to columns first  Column layout equals the one below

    Any thoughts  

    I am on GP2013 could that be an issue?

    Thanks Linda

    100 DES

    130 Net Income from Operations C +Segment1 = [430000:599999]

    160 DES

    190 Add Back Non-Cash Expenses: DES 220

    220  Depreciation & Amortization -Segment1 = [189900:189904]

    250 ---

    280 Net Cash Flow from Operations TOT 130+220

    310 ---

    340 DES

    370 Sources (Uses) of Cash: DES

    400   Accounts Receivable C +Segment1 = [121000:136999]

    430   Inventory - Fuel C +Segment1 = [154000:154007]

    438   Inventory - Parts C +Segment1 = [150000]

    445   Inventory - Other C +Segment1 = [154008:159300]

    460   Prepaid Expenses C +Segment1 = [160000] +Segment1 = [169000]

    520   Accounts Payable C +Segment1 = [200000:220000]

    550   Accrued Benefits C +Segment1 = [223000:223500]

    580   Accrued Liabilities C +Segment1 = [223750:223795] +Segment1 = [163000] +Segment1 = [299999]

    610   Accrued Tax Liabilities C +Segment1 = [224001:236000]

    640 ---

    670 Total Sources (Uses) of Cash TOT 400:610

    700 ---

    730 Net Cash Flow from Operating Activities TOT 280+670

    760 ---

    790 DES

    820 CASH FLOW FROM INVESTING ACTIVITIES: DES 940

    850 DES 940

    880   Additions to Fixed Assets C +Segment1 = [171000:189007]

    910 --- 940

    940 TOT 880

    970 --- 940

    1000 CASH FLOW FROM FINANCING ACTIVITIES: DES 1120

    1030 DES 1120

    1060 Principal Payments on Notes C +Segment1 = [246000:250010]

    1090 --- 1120

    1120 TOT 1060

    1150 --- 1120

    1180 DES

    1210 Net Increase (Decrease) in Cash TOT 730+880+1120

    1240 DES

    1255

    1270 Cash at Beginning of Period Account Modifier=[/BB] +Segment1 = [100000:102004]

    1300 Cash at Beginning of Period CAL B=B.1270, E=C.1270

    1330 ---

    1360 DES

    1390 Cash and Equivalents at End of Period TOT 1210+1300

    1420 ===

    1450 DES

    1480 NP - Ending Cash Per Books NP +Segment1 = [100000:102004]

    1510 Check Total - Ending Cash Per Books CAL B=D.1480, E=C.1480 NP

    1540

    1570

    1600 Calculated Ending Cash Out of Balance with GL TOT 1390-1510

  • Suggested answer
    Marvin Burnett Profile Picture
    Marvin Burnett 165 on at
    RE: Management Reporter - Cash Flow

     

    Here are screen shots so they look a little more logical.

  • Marvin Burnett Profile Picture
    Marvin Burnett 165 on at
    RE: Management Reporter - Cash Flow

    Hey Tim,

    Here is a sample layout that I have working in a cash flow statement

    The row numbers are slightly different but I am sure you'll get the idea:

    1200 Increase (Decrease) in Cash CAL @575+@800+@1125

    1225                                      DES

    1250 NP-Cash at Beginning of Period                                       Account Modifier=[/BB]

    1275 Cash at Beginning of Period CAL B=B.1250, E=C.1250

    1300                                      DES

    1325 Cash at End of Period                   TOT 1200+1275

    And the Column layout is:

    DESC FD FD FD CALC

    ACTUAL ACTUAL ACTUAL

    BASE BASE BASE

    BASE BASE BASE

    PERIODIC YTD/BB YTD

    D-C

    30 14 14 14 14

    NP NP

    Please note that you have to make sure that the calculation priority has to be set to Columns first then rows or you will not get the right numbers.

    Hope this helps,

    Marvin

  • Marian.West@pngaming.com Profile Picture
    Marian.West@pngamin... on at
    RE: Management Reporter - Cash Flow

    I think it should read : CalB=B,1420,C=C,1420

    C=C or E=E depending on the column

    NOT E=C

  • Suggested answer
    linda krawiecki Profile Picture
    linda krawiecki 75 on at
    RE: Management Reporter - Cash Flow

    Any one have an answer on this  I too have this same issue

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans