web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Cash inflow vs. cash outflow chart report problem

(0) ShareShare
ReportReport
Posted on by

Can someone tell me why when I run the "Cash inflow vs. cash outflow chart" or the "Expected cash in the next x days chart", they come back with no data in them?

Thank you 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Subramani Profile Picture
    50 on at
    RE: Cash inflow vs. cash outflow chart report problem

    Hi al_75a,

    Can u tel me how you got the data to run the "Cash inflow vs. cash outflow chart" report.

    2017_2D00_06_2D00_07_5F00_17_2D00_28_2D00_48.jpg

    Thanks,

    Subbu

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Cash inflow vs. cash outflow chart report problem

    Hi al_75a,

    Good to hear :-)

    Would you mind verifying the solution as answer to get this thread closed?

    Many thanks and best regards,

    Ludwig

  • Community Member Profile Picture
    on at
    RE: Cash inflow vs. cash outflow chart report problem

    Thank you so much Ludwig! The reports now have data in them. Thanks again

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Cash inflow vs. cash outflow chart report problem

    Hi al_75a,

    Just wondering if your report came up with some data or whether they are still blank?

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Cash inflow vs. cash outflow chart report problem

    Hi al_75a,

    I would not worry to much about those issues as the reports are based on the General Ledger and AR cubes.

    I cannot think why the inventlocation or the buyergroup should have an influence on the Report.

    Please see the underlying queries of those reports yourself.

    reports4.png

    reports4.png

    Hope this helps.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at
    RE: Cash inflow vs. cash outflow chart report problem

    Hello back, there are 4 errors/warnings due to duplicate keys in Invetlocationexpanded table and buyergtoup table. It seems to be skipping those and finishing the process successfully. Should I be concerned or fix the errors? And how do I fix then if I shall?

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Cash inflow vs. cash outflow chart report problem

    Hi al_75a, the process progress window in the SQL Server Management studio should indicate if there are any warnings/errors. If you open the report now, does it Show some data or is it still empty?

    Ludwig

  • Community Member Profile Picture
    on at
    RE: Cash inflow vs. cash outflow chart report problem

    I processed the cubes in MA Analysis Server, it says that it was successfully processed with warnings or errors, how do I know what the errors or warnings are?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Cash inflow vs. cash outflow chart report problem

    Hi al_75a,

    Have your cubes been processed recently and do you have some open customer transactions?

    Ludwig

  • Community Member Profile Picture
    on at
    RE: Cash inflow vs. cash outflow chart report problem

    Yes- the cubes have been deployed. The report runs, it produces a chart with a line and no data

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans