Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Can not drop columns from view!

Sandro Regis
on 4/1/13, 2:13 PM 596 views

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 (
                DISTINCT(to_char(l.date,'YYYY-MM-DD')) AS name,
                MIN(l.id) AS id,
                SUM(l.amount) AS amount,
                SUM(l.unit_amount*t.list_price) AS sale_price,
                SUM(l.unit_amount) AS unit_amount,
                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)
                (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?

Best regards,

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 4/1/13, 2:13 PM
Seen: 596 times
Last updated: 3/16/15, 8:10 AM