Commit Graph

357 Commits

Author SHA1 Message Date
Raf Ven 38c9deeab4 [FIX] sale: Wrong filter definition
'state', 'in', ('draft') is an invalid definition, ('draft') is not a tuple
should have been ('draft',)

Replacing by simpler 'state', '=', 'draft'

Fixes #8115
Closes #9016
2015-10-13 10:47:48 +02:00
Commandant Custo 1881a13699 [FIX] sale: report: find sales of subcategories
When searching for sales of a specific category,
display the products of the whole category subtree.
Consistent with:
* 633df8dc92
* https://github.com/odoo/odoo/blob/8.0/addons/account/report/account_invoice_report_view.xml#L72

Closes #4631
2015-10-12 15:43:36 +02:00
Goffin Simon 48ccb19937 [FIX] sale: currency in report sale analysis
In Sale Report Analysis, the price total must be in the currency
of the company.
Introduced by b5c1cb4298
opw:649781
2015-09-29 16:43:47 +02:00
Goffin Simon 7f5f945dcf [FIX] sale: _sales_count
The field "state" in "sale.report" model must consider the state used
by "sale.order.line" to be consistent with the view created in this model.

The function _sale_count in 'product.product' model must return
the number of product included in a "confirmed" or "done" sale order line.

opw:644200
2015-07-23 15:28:36 +02:00
Goffin Simon b5c1cb4298 [FIX] sale: Currency in Sales Analysis
The "Total Price" in Sales Analysis must take into account the currency.
Inspired from caf333eb59
2015-07-14 14:19:00 +02:00
Guewen Baconnier 3a314780c0 [FIX] sale_*, delivery: more consistent ignore of cancelled SO lines
Sales Order lines have a cancelled state, but this state is not
always considered when looping over lines. This check is
done in some places already and this patch's aim is to do it in the
remaining places.

- Cancel the procurement of a sale line in sale.order.line
instead of sale.order, so a line canceled individually with
sale_order_line.button_cancel will properly cancel it
procurement.
- Sale report: uses the state of lines instead of Sales order,
so canceled lines of not-canceled orders are correctly represented
in the analysis.
- test: do not create invoices lines for canceled sale lines
- test: creation of moves with canceled lines
- test: check if lines are still canceled when sale order is done

Closes #6036
2015-04-24 17:29:51 +02:00
Christophe Simonis 8ac8281a7f [MERGE] forward port of branch saas-3 up to d3e7a8e 2015-04-10 18:35:34 +02:00
Christophe Simonis d3e7a8ef5e [MERGE] forward port of branch 7.0 up to 856bc6f 2015-04-10 18:24:46 +02:00
Somesh Khare c09095cbc9 [FiX] sale(_stock): missing state on report
The state 'Quotation Sent' was not visible on the sales analysis report (e.g.
group by Status). Add the missing state to the report to correctly disaply it.
opw 619748
2015-04-08 16:36:04 +02:00
celm1990 d039249dd2 [FIX] fix wrong filter in search view (account/sale)
the field section_id is created in addon sale, but used in the account
reporting views.  This commit moves the search view definition
in the correct file.
2014-11-06 14:15:19 +01:00
Denis Ledoux 74072441cc [FIX] sale: backport of rev 709e22c32a
[FIX] sale: sale report view, wrong domain

Quotations are sale.order with state draft and sent
Sale orders are sale.order with state other than draft, sent and cancel
2014-09-15 16:57:51 +02:00
qdc f57787e07e [IMP] Cleaning of reporting (group_by, filters), adding new favourites and default views, some renaming (py and xml files) 2014-08-26 11:56:49 +02:00
Christophe Simonis 5a5f811d23 [REVERT] commit 5e5c73e
Branch 8.0 is a **stable** branch. This mean no database schema
changes.
2014-08-22 13:59:22 +02:00
qdc 5e5c73e7ba [IMP] Cleaning of reporting (group_by, filters), adding new favourites and default views, some renaming (py and xml files) 2014-08-22 09:49:09 +02:00
Olivier Dony 6c4cf84ce8 [IMP] sale, crm: remove remaining interval filters, continuing 366a30d 2014-07-30 15:13:38 +02:00
Denis Ledoux d9339e1e2d [FIX] sale, crm_claim, crm_helpdesk: report menus
crm claims and helpdesk reports should be in Sales Report menu, not in project
The sales report menu is now defined in sales_team, which is a common dependance between crm and sales, instead of redefining this menu in each modules
2014-07-22 19:13:13 +02:00
Raphael Collet 2398f480cd [IMP] addons: add _depends on models backed up by an sql view and used by other models 2014-07-08 15:32:38 +02:00
Thibault Delavallée 27fa618882 [REV] Partial revert of search view changes: indeed the graph view is not already capable of handling group_by on any field, declaring them is still necessary. 2014-07-04 16:44:55 +02:00
Thibault Delavallée 44a5268c00 [IMP] addons: search view cleaning / improvements due to the new search view display 2014-07-01 11:28:08 +02:00
Géry Debongnie 62900fe01b Merge remote-tracking branch 'odoo/master' into master-inline-searchview-ged
Conflicts:
	addons/crm/crm_case_section_view.xml
2014-05-26 10:06:31 +02:00
Olivier Dony 2af03e1b6e [MERGE] Forward-port latest 7.0 bugfixes, up to f8671cb 2014-05-22 16:44:33 +02:00
Olivier Dony 02035b27b8 [RESTORE] Restore *.sxw files, skipped during bzr-to-git conversion to discard older binary blobs 2014-05-22 14:07:15 +02:00
Géry Debongnie 555677f14d [IMP] replace all 'Group By...' by 'Group By'
in all searchview, the 'Group By...' looks weird, next to the Custom
Reports and Filters.  This change was requested by the upper management
2014-05-22 11:44:35 +02:00
Christophe Simonis a756b82372 [MERGE] forward port of branch saas-4 up to revid bb26dea 2014-05-20 20:19:55 +02:00
Martin Trigaux 583fe74ba2 Forward-port of latest saas-3, up to revision 9455 (rev-id mat@openerp.com-20140514080416-m4t23y0rxx2ot7y6) 2014-05-14 10:37:54 +02:00
Denis Ledoux 709e22c32a [FIX] sale: sale report view, wrong domain
Quotations are sale.order with state draft and sent
Sale orders are sale.order with state other than draft, sent and cancel
2014-05-13 10:15:01 +02:00
Thibault Delavallée 919bd97509 [MERGE] Sync with upstream (trunk) 2014-05-12 14:56:31 +02:00
Cedric Snauwaert 9d9cfd585f [FIX]sale_report: change type of field date from date to datetime to match field date on sale_order
bzr revid: csn@openerp.com-20140512114532-726a1z0wqbpz96t8
2014-05-12 13:45:32 +02:00
Prashant Panchal (OpenERP) 6c0389279a [IMP]add groups 'base.group_multi_salesteams' on sales team dependent module 2014-05-09 13:13:13 +05:30
Ravi Gadhia 6ccbd2cd82 [IMP] no need to inherit sale.order report we are already in sale/report +change file name for invoice report 2014-05-02 17:23:18 +05:30
Randhir Mayatra rma-openerp 27ee024847 [IMP] optimize code 2014-04-22 12:53:03 +05:30
Denis Ledoux 7715bf1823 [MERGE] Forward-port of latest 7.0 bugfixes, up to rev. 9969 revid:dle@openerp.com-20140409162932-y5fxd5wbojing2t2
bzr revid: dle@openerp.com-20140409163132-n3apqh6nvfg2qof9
2014-04-09 18:31:32 +02:00
Denis Ledoux 32f4824434 [MERGE][FIX] sale: sale order report, pto in invoice template should not cover the whole document
Courtesy of Stefan Rijnhart (Therp)

bzr revid: dle@openerp.com-20140408193910-2vztatyowndyasj9
2014-04-08 21:39:10 +02:00
Ravish (Open ERP) 7699504d62 [Add new sale_team module] 2014-03-28 15:28:35 +05:30
openerp-sle 12e9d218b0 [IMP] Sale order report converted to QWeb
bzr revid: openerp-sle@openerp-sle.home-20140212182247-0ahbbrgob4ssz9bn
2014-02-12 19:22:47 +01:00
Gery Debongnie e4cb7e5aa1 [FIX] change the name of the sales filter to Sales -> this is the name required in some other places that inherits it (addon sale)
bzr revid: ged@openerp.com-20140127143219-2ljcrieylv3pdz8c
2014-01-27 15:32:19 +01:00
Gery Debongnie fcb9f7a76e [IMP] improves the Sales Analysis reporting views (add filters and changes the row/col definitions) in pivot table mode (addon sale)
bzr revid: ged@openerp.com-20140127110102-so4cma7679uvdwtk
2014-01-27 12:01:02 +01:00
Gery Debongnie 9477cacd5f [IMP] removes old tree view in reporting (sales, sales_crm, sales_stock) and replaces them by the new graph view in pivot mode by default (addon sale, sale_crm, sale_stock)
bzr revid: ged@openerp.com-20131231111824-1altk73m9l4iszkq
2013-12-31 12:18:24 +01:00
Gery Debongnie ae13bea0d8 [IMP] changes the xml description of the graphs to use the new graph view (and to make sure the result is as close as possible) (addon sale)
bzr revid: ged@openerp.com-20131224102942-5g4gchmgyloo2s06
2013-12-24 11:29:42 +01:00
Turkesh Patel (Open ERP) b08503e373 [MRG] merge with lp:openobject-addons
bzr revid: tpa@tinyerp.com-20131126052924-xn4qn67lehe6x2pj
2013-11-26 10:59:24 +05:30
Olivier Dony 44664076da [MERGE] Forward-port of latest 7.0 fixes up to rev 9618 rev-id: dle@openerp.com-20131120142131-s333lyva85cyn41o
bzr revid: odo@openerp.com-20131120144059-yyh7emvgdarff09b
bzr revid: odo@openerp.com-20131120144318-11nmn1zj00zmi10z
2013-11-20 15:43:18 +01:00
Olivier Dony 0f7099bb30 [FIX] sale,sale_stock: sales analysis view using incorrect JOIN and group by clause
Similarly to the recent fixes in Purchase Analysis,
the Sales Analysis view must not group on the quantity
field. It is one of the columns that must be aggregated,
not used to fold PO lines into the same
result row.
The line count was also incorrect because of this, and
had to be corrected to actually count() the underlying
SO lines.

In addition, the JOINs were done in the wrong order,
which could cause problems (e.g. if an empty SO ever
landed in the database, all the SO line columns
would be empty in the JOIN, and cause errors)

bzr revid: odo@openerp.com-20131105103011-vkix07lsb6q3y9fd
2013-11-05 11:30:11 +01:00
Turkesh Patel (Open ERP) 6e1b899aa9 [IMP] improved code
bzr revid: tpa@tinyerp.com-20130904114335-jfptxzwdgt2xjzm1
2013-09-04 17:13:35 +05:30
Turkesh Patel (Open ERP) b63f89a74e [RMV] remove improvemets to calculate amount based on currency from analysis reports.
bzr revid: tpa@tinyerp.com-20130904112540-4ovecz1mpjkok7ge
2013-09-04 16:55:40 +05:30
Turkesh Patel (Open ERP) edf31c829c [MRG] improved sale analysis report to convert amount in cureent user currency:lp:~openerp-dev/openobject-addons/trunk-salesteam-kanban-tpa-improve-chirag
bzr revid: tpa@tinyerp.com-20130808091035-4smdbjrxi3jpomcc
2013-08-08 14:40:35 +05:30
Chirag Dodiya (OpenERP Trainee) ac12aa981a [IMP] Improved Sale Analysis report
bzr revid: chiragdd7@gmail.com-20130808054940-b1a8ikj4hd49rpru
2013-08-08 11:19:40 +05:30
Turkesh Patel (Open ERP) 9daabe3754 [IMP] show sales analysis based on cretion date for quatation and for sales based on confirm date.
bzr revid: tpa@tinyerp.com-20130806091124-650f98bm7d1e004e
2013-08-06 14:41:24 +05:30
Turkesh Patel (Open ERP) 0049c8efe8 [IMP] Improved code of sale report to inherit and add fields in sale_crm,sale_stock modules, added proper domins on the actions in sales teams kanban
bzr revid: tpa@tinyerp.com-20130729101117-6sxwrsh2coz8ygkd
2013-07-29 15:41:17 +05:30
Turkesh Patel (Open ERP) edff1d9575 [IMP] Fixed issue of traceback when we enter non integer number,improved css and help.
bzr revid: tpa@tinyerp.com-20130726071834-hd9qyyotf41ja57w
2013-07-26 12:48:34 +05:30
sgo@tinyerp.com 2bda4f7b3c [MERGE]sync with trunk
bzr revid: sgo@tinyerp.com-20130607113500-jzhet9cr98c0ss4s
2013-06-07 17:05:00 +05:30