Cash Flow Graph on Dashboard Answered

Alp

Hello, we are using SAP Business ONE for SQL and B1 Usability Package applications. We need a chart in the dashboard for cash flow, but I couldn't find any solution. Is there anyone who can help?

Comments

9 comments

  • Comment author
    SSP Automation
    Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
    (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
    Read more about the Feature Request process here
    [Internal Id: 55330]
    0
  • Comment author
    Rasmus Jensen

    Hi Alp

    How would such a chart look like? Do you have an example from another system

    0
  • Comment author
    Alp

    Hi Rasmus,

    This is the cash flow statement used in SAP Business ONE for HANA.

    0
  • Comment author
    Rasmus Jensen

    Thanks.. It is not something we have at the moment, but if this get enough votes we will evaluate if it will be possible int the furture

    0
  • Comment author
    Alp

    Thanks. I know there is no such structure on the B1UP application. What I want is not to come to the default features of the program. What tables can I use to get something like this. I would like a suggestion like these.

    0
  • Comment author
    Rasmus Jensen

    >What tables can I use to get something like this. I would like a suggestion like these

    I'm afraid I know even less about cash flow and how it gets its data :-) ... But perhaps other can answer here with more knowledge on the topic 

    0
  • Comment author
    Alp

    Thanks Rasmus. I'm waiting

    0
  • Comment author
    Michael Haak

    My suggestions:

    SALES

    OINV A/R Invoice
    OINV A/R Reserve Invoice
    OINV A/R Invoice + Payment
    ODPI A/R Down Payment Invoice
    ORIN A/R Credit Memo (negative)

     

    PURCHASE

    OPCH A/P Invoice (negative)
    OPCH A/P Reserve Invoice (negative)
    ODPO A/P Down Payment Invoice (negative)
    ORPC A/P Credit Memo

    Always Net Total with Due Date, not canceled and no Cancelations

    0
  • Comment author
    Romain Van Den Abbeel

    Hello, 

    I'm looking for the same features as well. What I need is to find a way to have such a dashboard (Hana Cashflow forecast) runing on SQL :

    Thanks in advance for your feedback.

    0

Please sign in to leave a comment.