#idempiere IRC log for Friday, 2015-11-06

Not-d3eb[IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-2923 Fields with value starting with a single quote cannot be searched00:11
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292300:11
Not-d3eb[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2923 Attachment set to "IDEMPIERE-2923.patch"00:12
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292300:12
Not-d3eb[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-2923 labels set to "+Patch"00:12
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292300:12
Not-d3eb[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-292300:13
Not-d3eb[IDEMPIERE] Attaching a patch that solves partially the issue - with the patch you can search records starting XOR ending with a single quote. But I think we still have problems with records starting and ending with a single quote on an import CSV key.00:13
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292300:14
*** xapiens has joined #idempiere00:30
*** ChuckBoecking has quit IRC01:06
*** CarlosRuiz has quit IRC02:01
*** xapiens has quit IRC02:14
*** hieplq has joined #idempiere02:25
*** ChuckBoecking has joined #idempiere02:55
*** norbertbede1 has joined #idempiere03:05
*** hieplq_ has joined #idempiere03:07
*** hieplq has quit IRC03:09
*** silphium has joined #idempiere03:14
*** ChuckBoecking has quit IRC03:27
Not-d3eb[IDEMPIERE] norbert.bede created IDEMPIERE-2924 Export to XLS limited to 6553604:46
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292404:46
Not-d3eb[IDEMPIERE] norbert.bede updated IDEMPIERE-2924 description set to "atm idempiere export to xls supports max 65536 rows. This is the xls file limitation. Would be better replace library to xlsx (also), which supports 1,048,576 rows. reference - max row numbers in MS excel versions. +-----------------+-----------+--------------+---------------------+ | | Max. Rows | Max. Columns | Max. Cols by letter |04:47
Not-d3eb+-----------------+-----------+--------------+---------------------+ | Excel 365* | 1,048,576 | 16,384 | XFD | | Excel 2013 | 1,048,576 | 16,384 | XFD | | Excel 2010 | 1,048,576 | 16,384 | XFD | | Excel 2007 | 1,048,576 | 16,384 | XFD | | Excel 2003 | 65,536 | 256 | IV | | Excel 2002 (XP) | 65,536 | 256 | IV | | Excel 2000 | 65,536 | 256 | IV | | Excel 97 | 65,536 | 256 | IV | | Excel 95 | 16,384 | 256 | IV | | Excel04:47
Not-d3eb5 | 16,384 | 256 | IV | +-----------------+-----------+--------------+---------------------+"04:47
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292404:47
Not-d3eb[IDEMPIERE] norbert.bede created IDEMPIERE-2925 Pricelist "Both" Option05:31
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292505:31
*** norbertbede1 has quit IRC06:22
*** norbertbede1 has joined #idempiere06:22
*** hieplq_ has quit IRC06:23
*** norbertbede1 has quit IRC06:30
*** norbertbede1 has joined #idempiere06:47
*** norbertbede3 has joined #idempiere06:51
*** norbertbede1 has quit IRC06:53
*** mbozem has joined #idempiere07:03
*** KermitTheFragger has joined #idempiere07:39
*** nmicoud has joined #idempiere07:48
*** a42niem has joined #idempiere07:59
*** hieplq_ has joined #idempiere08:30
Not-d3eb[IDEMPIERE] tsvikruha updated IDEMPIERE-234108:38
Not-d3eb[IDEMPIERE] Hi [~deepak] I just found one typo in attached bug which resulted in missing error message in response when running process. In your [^IDEMPIERE-2341.patch] + RunProcessResponse rResp = stndResp.getRunProcessResponse(); should be replaced by + RunProcessResponse rResp = retDocument.getRunProcessResponse(); Attached [^IDEMPIERE-2341_typo.patch] fix this.08:38
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-234108:38
Not-d3eb[IDEMPIERE] tsvikruha updated IDEMPIERE-2341 Attachment set to "IDEMPIERE-2341_typo.patch"08:38
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-234108:38
*** nmicoud_ has joined #idempiere08:50
*** baba_ has joined #idempiere10:33
*** nmicoud_ has quit IRC10:41
*** hieplq_ has quit IRC10:48
*** hieplq_ has joined #idempiere10:51
Not-d3eb[IDEMPIERE] norbert.bede created IDEMPIERE-2926 Currency CostingPrecision is not used on m_cost and m_costhistory11:16
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292611:16
*** mbozem has quit IRC11:28
*** nmicoud_ has joined #idempiere11:58
*** nmicoud_ has quit IRC12:08
*** norbertbede3 has quit IRC12:27
Not-d3eb[IDEMPIERE] tsvikruha updated IDEMPIERE-2926 summary set to "Currency CostingPrecision is multiplied by hard-coded value"13:07
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292613:07
*** norbertbede1 has joined #idempiere13:17
*** mbozem has joined #idempiere13:24
Not-d3eb[IDEMPIERE] tsvikruha updated IDEMPIERE-2926 Attachment set to "IDEMPIERE-2926.patch"13:39
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292613:39
Not-d3eb[IDEMPIERE] tsvikruha updated IDEMPIERE-2926 labels set to "+Patch"13:40
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292613:40
Not-d3eb[IDEMPIERE] tsvikruha updated IDEMPIERE-2926 status set to "Peer Review Queue"13:40
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292613:40
Not-d3eb[IDEMPIERE] tsvikruha updated IDEMPIERE-292613:42
Not-d3eb[IDEMPIERE] [~norbert.bede] attached patch remove hard coded variable and intead of this, uses precision from Account schema. Please write some details about this solution, thanks.13:42
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292613:42
*** norbertbede1 has quit IRC14:19
*** norbertbede1 has joined #idempiere14:20
Not-d3eb[IDEMPIERE] norbert.bede updated IDEMPIERE-292614:58
Not-d3eb[IDEMPIERE] Thanks Tomas. The main idea came from too "long" cost prices. We discovered, cost price at average costing methods is multiplied by 2 with constant multiplier number 2. We understand this is "problably" because better precision calculation. I don't like this approach because when we generate Price list from Product Cost, and store to each pricelist limit price - to calculate transaction margins, then in14:58
Not-d3ebreports we had too long figures. Instead we design - add Cost Precision and Standard Precision to Accounting schema. This way implementor able to setup per tenant own standard and cost precision. In our case cost precision was on currency EUR 4 system calculates with 4x2 with 8. From now it is possible to setup per costing methods specific e.g. 8 to accurate costing calculation. I will use 5 decimal places in14:58
Not-d3ebcurrency, and based on requirement will setup specific precision on schema's per client or per orgs.14:58
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292614:58
*** norbertbede1 has quit IRC15:10
*** mbozem has quit IRC15:23
*** hieplq_ has quit IRC15:33
*** hieplq_ has joined #idempiere15:34
*** nmicoud has quit IRC16:09
*** KermitTheFragger has quit IRC16:43
*** fercho has joined #idempiere16:46
*** hieplq_ has quit IRC17:33
*** a42niem has quit IRC18:04
*** mike_ has joined #idempiere18:04
*** norbertbede1 has joined #idempiere18:38
*** CarlosRuiz has joined #idempiere19:10
*** ChanServ sets mode: +o CarlosRuiz19:10
*** mbozem has joined #idempiere19:11
*** norbertbede1 has quit IRC19:18
*** nmicoud has joined #idempiere19:55
Not-d3eb[IDEMPIERE] nmicoud created IDEMPIERE-2927 IDEMPIERE 2778 migration scripts fails on Oracle20:11
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292720:11
Not-d3eb[IDEMPIERE] nmicoud updated IDEMPIERE-2927 Attachment set to "IDEMPIERE-2927.patch"20:13
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292720:13
Not-d3eb[IDEMPIERE] nmicoud updated IDEMPIERE-2927 status set to "Peer Review Queue"20:13
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292720:13
Not-d3eb[IDEMPIERE] nmicoud updated IDEMPIERE-2927 labels set to "+Patch"20:13
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292720:13
Not-d3eb[IDEMPIERE] nmicoud updated IDEMPIERE-2927 assignee set to "Carlos Antonio Ruiz Gomez"20:13
Not-d3eb[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-292720:13
*** nmicoud has left #idempiere20:16
*** CarlosRuiz has quit IRC22:35
*** CarlosRuiz has joined #idempiere22:56
*** ChanServ sets mode: +o CarlosRuiz22:56
*** mbozem has quit IRC23:58

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!