Skip to Content
Dette spørgsmål er blevet anmeldt
expensessqlbisql
1 Svar
3394 Visninger
Avatar
Hendy

Query :

SELECT a.analytic_account_id AS x_analytic_account_id, SUM(a.debit - a.credit) AS x_expense FROM account_move_line AS a LEFT JOIN account_account AS b ON a.account_id=b.id LEFT JOIN account_account_type AS c ON b.user_type_id=c.id WHERE c.name = 'Expenses' AND c.parent_state ='Posted' GROUP BY a.analytic_account_id


Example Error

The SQL query is not valid:
column c.parent_state does not exist
LINE 11: c.name = 'Expenses' AND c.parent_state ='Posted'
^
HINT: Perhaps you meant to reference the column "a.parent_state".


So ,  I  want  to  show  query with  status  = Posted 

Avatar
Kassér
Avatar
Karthik Jain
Bedste svar

Hi Hendy,

I have just changed the referencing name of models for easy understanding

select aml.analytic_account_id as x_analytic_account_id, SUM(aml.debit - aml.credit) as x_expense
from account_move_line as aml
left join account_account as aa on aml.account_id = aa.id
left join account_account_type as aat on aa.user_type_id = aat.id
where aat.name = 'Expenses' and aml.parent_state ='posted'
group by
aml.analytic_account_id

parent_state field is in account_move_line  and  not  in  account_account_type,  you  were  calling  it  wrongly,

Hope  it  helps,

Thanks


Avatar
Kassér
Hendy
Forfatter

Thanks !

Related Posts Besvarelser Visninger Aktivitet
Expense menu not appearing in Odoo Løst
expenses
Avatar
Avatar
Avatar
Avatar
4
nov. 25
410
How to make a report for expenses more than 80? Løst
expenses
Avatar
Avatar
1
feb. 25
2144
Título: ¿Existen módulos OCA para agrupar diferentes tipos de gastos en Odoo?
expenses
Avatar
0
okt. 24
2300
How to delete " approved or paid _ expense in Odoo expense app"
expenses
Avatar
Avatar
1
feb. 23
3311
Usage Of SQl Queries In odoo
sql
Avatar
Avatar
1
nov. 22
7539