Credit Card Account

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

Post Reply
fabianfp
New MMEX User
Posts: 10
Joined: Sun Sep 28, 2014 10:29 pm
Are you a spam bot?: No

Credit Card Account

Post by fabianfp »

when i use my credits cards, i can't see in this sql inform. how can i change for see the credit card movements? only see the movemet in Chekinggs acount.

-- TODO: Update payee name in line 19. select strftime('%Y', t.TRANSDATE) as YEAR    , total(case when '01' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Enero    , total(case when '02' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Febrero    , total(case when '03' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Marzo    , total(case when '04' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Abril    , total(case when '05' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Mayo    , total(case when '06' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Junio    , total(case when '07' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Julio    , total(case when '08' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Agosto    , total(case when '09' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Septiembre    , total(case when '10' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Octubre    , total(case when '11' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Noviembre    , total(case when '12' = strftime('%m', t.TRANSDATE) then t.TRANSAMOUNT * c.BASECONVRATE else null end) as Diciembrefrom CHECKINGACCOUNT_V1 as tinner join ACCOUNTLIST_V1 as a on a.ACCOUNTID = t.ACCOUNTIDinner join CURRENCYFORMATS_V1 as c on c.CURRENCYID = a.CURRENCYIDinner join  SUBCATEGORY_V1 as p on t.SUBCATEGID = p.SUBCATEGIDwhere p.SUBCATEGNAME = 'Supermercado'    and t.TRANSCODE='Withdrawal'    and t.STATUS <> 'V'group by yearorder by year desc;
User avatar
GabrieleV
MMEX Developer
Posts: 158
Joined: Wed Apr 09, 2014 7:45 pm
Are you a spam bot?: No
Location: Italy

Re: Credit Card Account

Post by GabrieleV »

Query seems to don't have any filter for account type, are excluded only void transactions..

Or maybe it's a currency problem, try to open account and re-set the currency.
Post Reply