Commit Graph

288 Commits

Author SHA1 Message Date
Denis Ledoux a7a71bcaa3 [FIX] purchase: report currency conversion
This is equivalent to revisions
- 000ce6a66d116b397768fd44cb348fdfa933cce1
- 48ccb19937
2016-03-14 12:42:33 +01:00
Goffin Simon 0f5a72e0a4 [FIX] purchase: Currency in Purchase Analysis
"Total Price" and "average price" in purchase analysis must take into account the currency.
Inspired from caf333eb59

opw:644621
2015-07-14 14:18:59 +02:00
Guewen Baconnier 96b53126a2 [IMP] purchase: Purchase report uses the state of lines instead of purchases
So canceled lines of not-canceled orders are correctly represented in the
analysis.
2015-06-08 18:19:20 +02:00
Adil Houmadi f2ef46e9f4 [FIX] product: purchase report, correct warehouse
Fix stock warehouse column on purchase report,
we need to join stock_picking_type and stock_warehouse
in order to have the warehouse itself

Closes #6409
2015-04-23 13:23:40 +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
Géry Debongnie 366a30db95 [FIX] correct various date issues in reporting
* remove old 'day', 'month', 'field' and replace them by the actual
date/datetime field
* remove weird cast to char when creating the view to prevent crash
when grouping on them
* remove duplicates (such as 'creation_date' and 'create_date')
* fix typing errors (field type date defined as a datetime in the
postgres view)
* fix search view definition
2014-07-30 15:11:22 +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 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
Quentin (OpenERP) 3b6d4d5eff [FIX] purchase: partial revert of preceeding commit where i messed with the merge with trunk and totally remove purchase/report while the psql view needs to be kept
bzr revid: qdp-launchpad@openerp.com-20140228163934-rrf3fsxcoo0nta0h
2014-02-28 17:39:34 +01:00
Quentin (OpenERP) e36b32a661 [MERGE] merged with main trunk (revision 9186)
bzr revid: qdp-launchpad@openerp.com-20140228131516-ihigousbe5p1nt68
2014-02-28 14:15:16 +01:00
openerp-sle 8a72eff36b [FIX] Fix useless import following the removal of rml purchase reports
bzr revid: openerp-sle@openerp-sle.home-20140214150700-2zuukk4ahs4q1zhs
2014-02-14 16:07:00 +01:00
openerp-sle 31cf553335 [IMP] Purchase quotation and purchase order converted to QWeb
bzr revid: openerp-sle@openerp-sle.home-20140214144627-se5x0alcl43gut4k
2014-02-14 15:46:27 +01:00
Quentin (OpenERP) 753f7541db [MERGE] main trunk
bzr revid: qdp-launchpad@openerp.com-20140203173000-mk092iw2wz3y0e3e
2014-02-03 18:30:00 +01:00
Gery Debongnie 85cb9774b7 [IMP] changes the reception analysis reporting view (warehouse) to select the correct pivot table (addon purchase)
bzr revid: ged@openerp.com-20140130124402-crfr39uqptlzc3cv
2014-01-30 13:44:02 +01:00
Gery Debongnie 90f2184e93 [IMP] improves the Purchase Analysis reporting view, removes old Day, Month, Year field from the postgres view and updates the dashboard graph view (addon purchase)
bzr revid: ged@openerp.com-20140129124739-6sir9fz6jak9ic0y
2014-01-29 13:47:39 +01:00
Gery Debongnie 5ff5cb1aba [IMP] removes old tree view in reporting and replaces it by the new graph view in pivot mode by default (addon purchase)
bzr revid: ged@openerp.com-20131231132740-q6n82cs2tfe9pvyj
2013-12-31 14:27:40 +01:00
Quentin (OpenERP) f5718efa6e [MERGE] merged with trunk
bzr revid: qdp-launchpad@openerp.com-20131230102802-y1ux8470wxnj4yfr
2013-12-30 11:28:02 +01:00
Denis Ledoux 1508c5dd00 [MERGE] Forward-port of latest 7.0 bugfixes, up to rev. 9718 rev-id: dle@openerp.com-20131224103535-rhtje7dnq1ie7jtb
bzr revid: tde@openerp.com-20131220162158-hbgktly09dv37958
bzr revid: dle@openerp.com-20131223155041-8zp8e08fihbr0ie2
bzr revid: dle@openerp.com-20131224112407-aw6dq2q92312kjbk
2013-12-24 12:24:07 +01:00
Xavier ALT 6e71e067ca [FIX] purchase: remove duplicate 'Warehouse' and 'Reference UOM' groupby filter in Purchase Analysis search view
bzr revid: xal@openerp.com-20131220085429-xxojh1oxjn1fo3a5
2013-12-20 09:54:29 +01:00
Quentin (OpenERP) df2d5e148e [MERGE] trunk
bzr revid: qdp-launchpad@openerp.com-20131129165644-fx0m3ok07l41o507
2013-11-29 17:56:44 +01:00
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 4cf2887153 [FIX] purchase: analysis view must not group by quantity, otherwise identical PO lines are counted only once
The product quantity is one of the columns that must be
aggregated, not used to fold PO lines into the same
result row.
This, combined with missing aggregation operators
was causing multiple identical PO lines from the
same PO to be merged together and only counted once
in some aggregations.

bzr revid: odo@openerp.com-20131105101930-f2qbcp12luom08je
2013-11-05 11:19:30 +01:00
Olivier Dony aac6fede99 [FIX] purchase: Purchase Analysis view was using incorrect JOIN order
The starting table for Purchase Analysis is purchase_order_line
not purchase_order. The previous code was using a wrong JOIN
combination starting from purchase_order, which resulted in
a crash if an empty PO was created.
In order to prevent this an extra  WHERE clause on product_id
being NOT NULL was added, but this was incorrect too as it
prevented PO lines with no product_id value from appearing
in the Purchase Analysis results, while being perfectly valid.

bzr revid: odo@openerp.com-20131104165826-kltuzlh4i8q89sk0
2013-11-04 17:58:26 +01:00
Pinakin Nayi (OpenERP) 982bb843ce [MERGE]merge with main branch
bzr revid: pna@tinyerp.com-20131015065406-5u51hu1bn79zyxur
2013-10-15 12:24:06 +05:30
Pinakin Nayi (OpenERP) d0c9bd0df2 [IMP]purchase : in search view remove UOM filter which display two times
bzr revid: pna@tinyerp.com-20131015060614-dvu9l8on2or7pc1t
2013-10-15 11:36:14 +05:30
Quentin (OpenERP) c4ef59844c [FIX] purchase: warehouse_id references fixed in reports
bzr revid: qdp-launchpad@openerp.com-20130905065240-apd56dl1pgr0zzbh
2013-09-05 08:52:40 +02:00
Josse Colpaert cc3dfdd3c0 [IMP] Change warehouse to picking_type_id on purchase + put destination address after picking type + adapt packaging
bzr revid: jco@openerp.com-20130903134600-7jraor07pqp8ijpo
2013-09-03 15:46:00 +02:00
Fabien Pinckaers 54631bda2a [MERGE] trunk
bzr revid: fp@openerp.com-20130803175004-ivqkxtsd7vh4npwe
2013-08-03 19:50:04 +02:00
Cedric Snauwaert 277531f21d [FIX]fix installation of several modules: purchase, sales, purchase_req, mrp, sale_stock
bzr revid: csn@openerp.com-20130709150027-wy8avglaosiktm5m
2013-07-09 17:00:27 +02:00
Amit Bhavsar (Open ERP) b9ed060fa8 [MERGE] merge with latest trunk
bzr revid: amb@tinyerp.com-20130624141146-sq4rh2q3rqz67mcj
2013-06-24 19:41:46 +05:30
Quentin (OpenERP) dee5ace29b [MERGE] trunk
bzr revid: qdp-launchpad@openerp.com-20130624095319-sqkrnk4r1mst8nvk
2013-06-24 11:53:19 +02:00
Quentin (OpenERP) 93fd5dd79e [FIX] purchase: removed fontName from RFQ and PO reports in order to allow a default style definition in company (to allow chinese characters for example, with Sun-ExtA font)
bzr revid: qdp-launchpad@openerp.com-20130528081955-20t8gzr5tm6vsktn
2013-05-28 10:19:55 +02:00
Thibault Delavallée 71df1a41bc [FORWARD] Forward port of addons 7.0 until revision 9172
bzr revid: tde@openerp.com-20130528104500-ds3irrs2u0qpst37
2013-05-28 12:45:00 +02:00
Pinakin Nayi (OpenERP) 0c570e8993 [IMP]purchase : in search view warehouse filter display two times
bzr revid: pna@tinyerp.com-20130508045621-00qnigii90n129y0
2013-05-08 10:26:21 +05:30
Vishmita Jadeja (openerp) fe128d7498 [Merge]Merge lp:openobject-addons
bzr revid: vja@tinyerp.com-20130418090337-51vfkhfl3lzg7mpf
2013-04-18 14:33:37 +05:30
Josse Colpaert 96ea6418c6 [IMP] Change standard_price field of product into a property: requires changing SQL queries
bzr revid: jco@openerp.com-20130417150213-4nm9tc8nzvsgm5ix
2013-04-17 17:02:13 +02:00
Vo Minh Thu e69326ee3b [REF] removed explicit model instanciations.
bzr revid: vmt@openerp.com-20130415102349-vgcrfok2k5y10cwz
2013-04-15 12:23:49 +02:00
Vo Minh Thu 5f73b48816 [REF] purchase: removed openerp.pooler imports.
bzr revid: vmt@openerp.com-20130327114111-gxtnb95f59m2k009
2013-03-27 12:41:11 +01:00
Vishmita 1c8227eb7d [Merge]Merge lp:openerp-addons
bzr revid: vja@tinyerp.com-20130128052704-jgcoeaqrodx2wlw8
2013-01-28 10:57:04 +05:30
Olivier Dony fc0c2942ba [MERGE] Another batch of bugfixes from 6.1
bzr revid: odo@openerp.com-20121218175547-7c1uxq4ypbi314gx
2012-12-18 18:55:47 +01:00
Paramjit Singh Sahota 38c56a45f5 [IMP] Improved code for
1). Changed report name test.pdf ==> requestforquotation.pdf.
2). Create a leave request for an employee:
It will display False instead of taking the employee Name (works fine when creating for the Administrator)

bzr revid: psa@tinyerp.com-20121218085008-429nosi350ez5mgd
2012-12-18 14:20:08 +05:30
Paramjit Singh Sahota 1e1a1a330a [IMP] Improved code for
Create a quotation, then print it:- problems in the pdf report (quantity unit of measure + quantity number blending)

bzr revid: psa@tinyerp.com-20121218072930-l1d2kb9v2hw215uo
2012-12-18 12:59:30 +05:30
Olivier Dony b67f73c327 [MERGE] Sync with trunk
bzr revid: odo@openerp.com-20121218025230-zig415ldtmazgbxt
2012-12-18 03:52:30 +01:00
Olivier Dony 84d7987f33 [MERGE] Bugfixes from 6.1 until revision 6900
rev.6900 = xal@openerp.com-20120720134532-t07xr3lp8ouhn2dv

bzr revid: odo@openerp.com-20121218021123-9ligpn7bkr9zo4n7
2012-12-18 03:11:23 +01:00
Cecile Tonglet 15fe515601 [MERGE] From trunk
bzr revid: cto@openerp.com-20121217144306-tkodwpox30cuvb28
2012-12-17 15:43:06 +01:00
Fabien Pinckaers d9b7d8155e [IMP] multi-currency stuff
bzr revid: fp@tinyerp.com-20121215162309-yav3g8hu50bp9wvv
2012-12-15 17:23:09 +01:00
Vo Minh Thu 6072fd11af [MERGE] merged trunk.
bzr revid: vmt@openerp.com-20121210111654-0pm3pupnqqeip52n
2012-12-10 12:16:54 +01:00