Merge lp:~openerp-dev/openobject-addons/7.0-test-ui-partnership-analyis-bug into lp:openobject-addons/7.0

Proposed by Pariket Trivedi(OpenERP)
Status: Needs review
Proposed branch: lp:~openerp-dev/openobject-addons/7.0-test-ui-partnership-analyis-bug
Merge into: lp:openobject-addons/7.0
Diff against target: 16 lines (+2/-2)
1 file modified
crm_partner_assign/report/crm_partner_report.py (+2/-2)
To merge this branch: bzr merge lp:~openerp-dev/openobject-addons/7.0-test-ui-partnership-analyis-bug
Reviewer Review Type Date Requested Status
OpenERP Core Team Pending
Review via email: mp+223906@code.launchpad.net

Description of the change

Hello all,

> Partnership Analysis Report genrate Error.
> I have to FIX this issue for chnage account_invoice_report insted of account_invoice.

Thanks,
ptr

To post a comment you must log in.
Revision history for this message
Christophe Matthieu (OpenERP) (chm-openerp) wrote :

Please put and synchro this branch on git.
Thanks

Unmerged revisions

10072. By Pariket Trivedi(OpenERP)

[FIX]: Partnership Analysis Report change for sql query report in crm_partner_assign

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'crm_partner_assign/report/crm_partner_report.py'
2--- crm_partner_assign/report/crm_partner_report.py 2012-12-06 14:56:32 +0000
3+++ crm_partner_assign/report/crm_partner_report.py 2014-06-20 12:18:39 +0000
4@@ -59,11 +59,11 @@
5 p.user_id,
6 p.section_id,
7 (SELECT count(id) FROM crm_lead WHERE partner_assigned_id=p.id) AS opp,
8- i.price_total as turnover,
9+ i.amount_total as turnover,
10 i.period_id
11 FROM
12 res_partner p
13- left join account_invoice_report i
14+ left join account_invoice i
15 on (i.partner_id=p.id and i.type in ('out_invoice','out_refund') and i.state in ('open','paid'))
16 )""")
17