idid=ididNnamenameYly_fullly_fullYly_runningly_runningYly_currently_currentYfy1fy1Yfy2fy2Yfy3fy3Yfy4fy4Yfy5fy5Yfy6fy6Yfy7fy7Yfy8fy8Yfy9fy9Yfy10fy10Yfy11fy11Yfy12fy12Ytotal_fytotal_fyY320256YMerge joinMergeJoinY1noneINNERlast year fulllast year running dateidid112160YMerge join 10MergeJoinY1noneINNERMerge join 9month8idid1072160YMerge join 11MergeJoinY1noneINNERMerge join 10month9idid1072256YMerge join 12MergeJoinY1noneINNERMerge join 11month10idid960256YMerge join 13MergeJoinY1noneINNERMerge join 12month11idid832256YMerge join 14MergeJoinY1noneINNERMerge join 13month12idid720256YMerge join 15MergeJoinY1noneINNERMerge join 14total_fyidid608256YMerge join 2MergeJoinY1noneINNERMerge joinlast year onlyidid240160YMerge join 3MergeJoinY1noneINNERMerge join 2month1idid384160YMerge join 4MergeJoinY1noneINNERMerge join 3month2idid480160YMerge join 5MergeJoinY1noneINNERMerge join 4month3idid576160YMerge join 6MergeJoinY1noneINNERMerge join 5month4idid672160YMerge join 7MergeJoinY1noneINNERMerge join 6month5idid768160YMerge join 8MergeJoinY1noneINNERMerge join 7month6idid864160YMerge join 9MergeJoinY1noneINNERMerge join 8month7idid976160Ycombine selectSelectValuesY1noneidnamely_fullly_runningly_currentfy1fy2fy3fy4fy5fy6fy7fy8fy9fy10fy11fy12total_fyN464256Ylast year fullTableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as ly_full from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_last_year_date()::date
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90last year fullid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1last year fullname.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormally_full-1-1last year fullly_full######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN11264Ylast year onlyTableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as ly_current from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date", 'YYYY-MM') = get_last_year_month()
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90last year onlyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1last year onlyname.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormally_current-1-1last year onlyly_current######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN38464Ylast year running dateTableInputY1nonedw bi indoteknik (localhost)-- query for ratio profit and loss
select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as ly_running from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_last_current_date()::date
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90last year running dateid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1last year running datename.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormally_running-1-1last year running dately_running######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN24064Ymonth1TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy1 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '01'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month1id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month1name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy1-1-1month1fy1######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN48064Ymonth10TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy10 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '10'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month10id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month10name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy10-1-1month10fy10######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN960336Ymonth11TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy11 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '11'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month11id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month11name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy11-1-1month11fy11######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN832336Ymonth12TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy12 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '12'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month12id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month12name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy12-1-1month12fy12######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN720336Ymonth2TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy2 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '02'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month2id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month2name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy2-1-1month2fy2######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN57664Ymonth3TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy3 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '03'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month3id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month3name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy3-1-1month3fy3######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN67264Ymonth4TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy4 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '04'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month4id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month4name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy4-1-1month4fy4######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN76864Ymonth5TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy5 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '05'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month5id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month5name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy5-1-1month5fy5######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN86464Ymonth6TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy6 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '06'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month6id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month6name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy6-1-1month6fy6######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN97664Ymonth7TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy7 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '07'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month7id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month7name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy7-1-1month7fy7######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN107264Ymonth8TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy8 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '08'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month8id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month8name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy8-1-1month8fy8######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN116864Ymonth9TableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as fy9 from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
and to_char(am."date",'MM') = '09'
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month9id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month9name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalfy9-1-1month9fy9######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN1072336Ytotal_fyTableInputY1nonedw bi indoteknik (localhost)select afrr.id, afrr.name,
(
select 0-coalesce(sum(balance),0) as total_fy from account_move_line aml
join account_move am on am.id = aml.move_id
where aml.account_id in(
select account_id from account_account_financial_report aafr
where aafr.report_line_id in(
select id from account_financial_report afr where id = afrr.id
)
)
and am.state = 'posted'
and to_char(am."date",'YYYY') = get_now_year()
)
from account_financial_report afrr
where afrr.parent_id = 321
order by id0NNNNIntegernormalid90month12 2id####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalname2147483647-1month12 2name.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormaltotal_fy-1-1month12 2total_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN608336YN