Hello Community,
Problem:
The problem is I am facing an issue with my cash balance report as I see my balances with the double value as they should be.
Situation Overview:
Let me give you an overview of the situation. I created a report that shows the cash balances of our companies over time (weekly update). I have a table that shows the bank name and balances broken down by currency, and a filter which the user can choose which date period of balance status he wants to see (i.e. If he wants to see the latest balance status he chooses the last update (e.g. 09.05.3018), in other case if he wants to see any previous date of past balances status he can easily choose any past date from the filter (e.g. I f he wants to see last week's balance status he would choose 02.05.2018)).
The report was working fine until the time we reset the password of the database connection (the dashboard is connected with SQL Server). Since that day, in the final date status the balances are all the double amount as they really are, while on any other previous dates the balances are correct.
Can you please give me some explanation why this happens and how we can resolve this issue? Also, I am not sure if this issue is somehow correlated with the Database connection password reset or not.
Many thanks for your time and looking forward for your response.
