Custom Report for multiple accounts

Page 1 of 1
4 posts
Custom Report for multiple accounts

reachalex
Super MMEX User

Posts: 27
Joined: Tue Jul 06, 2010 6:37 pm
I have checked all the posts in the section and did not find something close to what I want.

Warning: I am not an SQL expert. I have tried my hand at a few, but I am unable to crack through the joins command.

What am I looking for: I have multiple accounts. I would like to view a report of all transactions for all accounts where status is "None" and Number = a certain value. 

What I want displayed: Date | Account Name | Payee | Category | Type | Number | Notes | Amount

Thank you so very much for helping me with this. 

If this has been already answered in any other threads, kindly point me to it. 

Thanks once again.
Re: Custom Report for multiple accounts

sterling
Super MMEX User

Posts: 82
Joined: Thu Dec 11, 2014 2:40 am
Heres the beginning to get you going, i've done the joins part for you and put some of the headings your after.
Code: Select all
select TRANSDATE,ACCOUNTNAME,PAYEENAME,CATEGNAME,TRANSCODE,TRANSAMOUNT
from
   CHECKINGACCOUNT_V1
   join
      ACCOUNTLIST_V1 on CHECKINGACCOUNT_V1.ACCOUNTID=ACCOUNTLIST_V1.ACCOUNTID
   join
      PAYEE_V1 on PAYEE_V1.PAYEEID=CHECKINGACCOUNT_V1.PAYEEID
   join
      CATEGORY_V1 on CATEGORY_V1.CATEGID=CHECKINGACCOUNT_V1.CATEGID;
Re: Custom Report for multiple accounts

reachalex
Super MMEX User

Posts: 27
Joined: Tue Jul 06, 2010 6:37 pm
Wow Sterling!! That is perfect. 
A little enhancement please.
Request you to also add the Number field in the view.

Under the built in "Reports > Cash Flow > Cash Flow - Specific Accounts" it gives a little window to select the account, Can that be incorporated into my report request.
Re: Custom Report for multiple accounts

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
DJWeinly wrote:Hi,
I registered for a new account, not for me but for Megan, but the email hasnt come through. Account registered for MeganPotthast. Was there a problem?
Some users can't register that's true.
Unfortunately I  can't help.
Page 1 of 1
Who is online

Users browsing this forum: Bing [Bot] and 2 guests

cron