Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Advanced Financial Report Definition

Posted on by 32,738

Throughout the definition phase of the "Cash Flow" statement, I have come across a certain issue regarding the sign of the (net balance).  As described below;

Reports > Financial > Advanced Financial

Report One

Row definition:

  • Type: Begining balance Category
  • Cash flow section: Operating

Report Type:

  • Profit and Loss

The report details are shown below; 

Bank Balances and Cash /Unrestricted       

 X

Bank Balances and Cash /Restricted

Y

Total

X+Y


Report Two

Row Definition:

  • Type: Begining balance Category
  • Cash flow section: Operating

Report Type:

  • Statement of Cash Flow

The report details are shown below; 

Bank Balances and Cash /Unrestricted       

 X

Bank Balances and Cash /Restricted

-Y

Total

X+(-Y)



Question:

Why is the value of (Y) associated with the second category (Bank Balances and Cash /Restricted) differs when the report type is changed ? 

Considering that Y is the same value (for instance 654,444 ) which means same calculation criteria, but different signs.

Please clarify.


Your efforts are highly appreciated.

Thanks in advance

 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Advanced Financial Report Definition

    Hello Mahmoud,

    I guess you calculations for both reports for this field does not match, first one might bring the cash category to the report and the second one might be calculating the cash based on your activities, you will need o review both reports formulas and check how it works, these reports are based on your business needs and other people desn't have the same formulas, that's why I am "guessing" the resons!

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    Re: Advanced Financial Report Definition

    Any clarification.

    Thanks,

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans