Hello friends, I am trying to install the module report_analytic_line and there are one SQL statement that once is executed throws this error:
Can not drop columns from view!
This is the sql statement:
CREATE OR REPLACE VIEW report_account_analytic_line_to_invoice AS ( SELECT DISTINCT(to_char(l.date,'YYYY-MM-DD')) AS name, MIN(l.id) AS id, l.product_id, l.account_id, SUM(l.amount) AS amount, SUM(l.unit_amount*t.list_price) AS sale_price, SUM(l.unit_amount) AS unit_amount, l.product_uom_id FROM account_analytic_line l left join product_product p on (l.product_id=p.id) left join product_template t on (p.product_tmpl_id=t.id) WHERE (invoice_id IS NULL) and (to_invoice IS NOT NULL) GROUP BY to_char(l.date,'YYYY-MM-DD'), product_id, product_uom_id, account_id )
Please have someone one hint to solve this issue?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/1/13, 2:13 PM|
|Seen: 624 times|
|Last updated: 3/16/15, 8:10 AM|