I have a report on the account.invoice model and want to show how many products in the invoice line. Below will show a picture of what I want to do.
The idea is to count how many products there are on the invoice and return the number of the quantity of products.
Maybe it may be simple, but really do not know everything about Odoo.
Thanks for your advice and help.
I try to query into report, it's working...
_name = "customer.report"
_description = "Orders Statistics"
_auto = False
name = fields.Many2one('res.partner', readonly=True)
p_id = fields.Many2one('preorder.config','PreOrder Ref')
tot_product = fields.Integer('# of Unique Product')
tot_piece = fields.Integer('# of Piece')
def init(self, cr):
"""Initialize the sql view for the event registration """
# TOFIX this request won't select events that have no registration
cr.execute(""" CREATE VIEW customer_report AS (
poc.id::varchar || '/' || coalesce(poc.id::varchar,'') AS id,
poui.customer AS p_id,
poui.partner_id AS name,
count(pl.product_id) AS tot_product,
count(poc.id) AS tot_piece
left join preorder_user_input poui on (poui.preorder_id = poc.id)
left join preorder_product_rel ppr on (ppr.preorder_id = poc.id)
left join preorder_user_input_product_line pl on (pl.user_input_id = poui.id)
poc.id, poui.preorder_id, poui.partner_id
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/4/16, 2:10 PM|
|Seen: 241 times|
|Last updated: 4/7/16, 1:04 AM|