Cash Flow Graph on Dashboard

Answered

Alp

• April 16, 2021 10:53

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?

Vote

6

• 

  SSP Automation

  • April 16, 2021 10:55

  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]
  
• 

  Rasmus Jensen

  • April 16, 2021 10:56

  Hi Alp

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

  Alp

  • April 16, 2021 10:59

  Hi Rasmus,

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

  
• 

  Rasmus Jensen

  • April 16, 2021 11:01

  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
• 

  Alp

  • April 16, 2021 11:04

  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.
• 

  Rasmus Jensen

  • April 16, 2021 12:18

  >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 
• 

  Alp

  • April 16, 2021 12:34

  Thanks Rasmus. I'm waiting
• 

  Michael Haak

  • April 16, 2021 23:34

  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
• 

  Romain Van Den Abbeel

  • April 29, 2021 14:34

  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.

Please sign in to leave a comment.