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.
Custom Report for multiple accounts
Moderator: Renato
-
- Senior User
- Posts: 38
- Joined: Wed Jul 07, 2010 12:37 am
- Are you a spam bot?: No
-
- Super User
- Posts: 72
- Joined: Thu Dec 11, 2014 8:40 am
- Are you a spam bot?: No
Re: Custom Report for multiple accounts
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;
-
- Senior User
- Posts: 38
- Joined: Wed Jul 07, 2010 12:37 am
- Are you a spam bot?: No
Re: Custom Report for multiple accounts
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.
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.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Custom Report for multiple accounts
Some users can't register that's true.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?
Unfortunately I can't help.