Report to forecast near term cash flow
Moderator: Renato
-
- Senior User
- Posts: 31
- Joined: Tue Jun 12, 2018 3:36 am
- Are you a spam bot?: No
Report to forecast near term cash flow
I had a desire for a report to forecast my cash flow for the next month. The Upcoming Transactions pane on the MMEX home page does not forecast far enough ahead for my desires. The built-in Cash Flow report when the Monthly option is selected gives you the aggregate information but I wanted detail lines as well as the total. I hope other MMEX users find this helpful. And I would appreciate your telling me if you find any errors. Thank you very much.
You do not have the required permissions to view the files attached to this post.
-
- Developer
- Posts: 345
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Report to forecast near term cash flow
There is a bug as it includes any Transfers in the near term expenses. It assumes only Deposit and Withdrawal are valid values for TRANSCODE.
Think it should be more like this:
Think it should be more like this:
You do not have the required permissions to view the files attached to this post.
-
- Senior User
- Posts: 31
- Joined: Tue Jun 12, 2018 3:36 am
- Are you a spam bot?: No
Re: Report to forecast near term cash flow
Thanks for paying attention. I did not have any Transfer transactions in my Recurring Transactions and completely overlooked the possibility of Transfer transactions in my SQL query. Thanks for pointing out this omission and posting a correction.
-
- New User
- Posts: 1
- Joined: Tue Jan 19, 2021 6:05 pm
- Are you a spam bot?: No
Re: Report to forecast near term cash flow
HI
I am new to MMEX but have managed to get the Cash Flow report discussed here to work THis is just what I was looking for - EXCEPT I would also like to add the running total - Can I ask you more learned users help me - what code would I need to add to the SQL to be able to add this feature? THANKS SO MUCH
I realise I have another request too - How can I split the report to show just one account?
Sorry to be a pain
I am new to MMEX but have managed to get the Cash Flow report discussed here to work THis is just what I was looking for - EXCEPT I would also like to add the running total - Can I ask you more learned users help me - what code would I need to add to the SQL to be able to add this feature? THANKS SO MUCH
I realise I have another request too - How can I split the report to show just one account?
Sorry to be a pain
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia