Somesh Khare(OpenERP) has proposed merging
lp:~openerp-dev/openobject-addons/6.0-opw-574667-skh into
lp:openobject-addons/6.0.
Requested reviews:
Naresh(OpenERP) (nch-openerp)
Related bugs:
Bug #995990 in OpenERP Addons: "account invoice report category not correct"
https://bugs.launchpad.net/openobject-addons/+bug/995990
For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/6.0-opw-574667-skh/+merge/105948
Hello Sir,
[FIX] account_invoice_report : account invoice report category not correct
Steps To reproduce:
1 Install Sale module.
2. Goto Sales/Configuration/Pricelists/Pricelists and Open "Public Pricelist"
3. Open PriceList Version "Default Public Pricelist Version"
4. Product ListPrice items Select "Default Public Pricelist Line"
5. Create a Template "Test Template" which has Category as "Other Products /
Misc".
6. Create 3 Products Product 1,Poduct 2 and Product 3 with Different Category
eg: All Products, Marketable Products etc.
7. Create a Sale Order with these product and the PriceList ""Public
Pricelist". Confirm Sale Order and Pay the Created Invoice.
8. Open Invoice Analysis report from "Accounting/Reporting/Statistic
Reports/Invoices Analysis"
When use filter "Category Of Product".
Current result:
Instead of showing product category it shows undefined.
Expected result:
List should show the result according to the category.
This branch fixes this issue.
Kindly review the branch and please share your views on it.
Thanks,
Somesh Khare
--
https://code.launchpad.net/~openerp-dev/openobject-addons/6.0-opw-574667-skh/+merge/105948
Your team OpenERP R&D Team is subscribed to branch
lp:~openerp-dev/openobject-addons/6.0-opw-574667-skh.
=== modified file 'account/report/account_invoice_report.py'
--- account/report/account_invoice_report.py 2012-03-15 10:08:19 +0000
+++ account/report/account_invoice_report.py 2012-05-16 10:16:29 +0000
@@ -172,9 +172,10 @@
where a.id=ai.id)
ELSE 1
END) / cr.rate as residual
- from account_invoice_line as ail
+ from product_product as pro
+ left join account_invoice_line as ail ON (ail.product_id = pro.id)
left join account_invoice as ai ON (ai.id=ail.invoice_id)
- left join product_template pt on (pt.id=ail.product_id)
+ left join product_template pt on (pt.id=pro.product_tmpl_id)
left join product_uom u on (u.id=ail.uos_id),
res_currency_rate cr
where cr.id in (select id from res_currency_rate cr2 where (cr2.currency_id = ai.currency_id)
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp
