Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0022300 | Openbravo ERP | 07. Sales management | public | 2012-11-14 13:37 | 2013-04-09 11:34 |
|
| Reporter | egoitz | |
| Assigned To | eduardo_Argal | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 3.0MP16.1 | |
| Target Version | 3.0MP19 | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | egoitz |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0022300: Long time to unpost a sales invoice where there are too many rows on fact_acct table |
| Description | Long time to unpost a sales invoice where there are too many rows on fact_acct table |
| Steps To Reproduce | -On a instance with a lot of entries on the fact_acct for invoice try to unpost a sales invoice.
It takes more than 40 seconds.
|
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | has duplicate | defect | 0021165 | 3.0MP14 | closed | jonalegriaesarte | Unpost process takes a long time when working with high volumes |
|
| Attached Files |  22300.diff (1,397) 2012-11-14 13:38
https://issues.openbravo.com/file_download.php?file_id=5729&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-11-14 13:37 | egoitz | New Issue | |
| 2012-11-14 13:37 | egoitz | Assigned To | => dmiguelez |
| 2012-11-14 13:37 | egoitz | Modules | => Core |
| 2012-11-14 13:37 | egoitz | Resolution time | => 1355439600 |
| 2012-11-14 13:37 | egoitz | Relationship added | has duplicate 0021165 |
| 2012-11-14 13:38 | egoitz | File Added: 22300.diff | |
| 2012-11-14 13:38 | egoitz | Note Added: 0054226 | |
| 2012-11-14 16:46 | dmiguelez | Assigned To | dmiguelez => jonalegriaesarte |
| 2012-12-04 11:50 | jonalegriaesarte | Target Version | 3.0MP18 => 3.0MP19 |
| 2012-12-10 16:36 | hgbot | Checkin | |
| 2012-12-10 16:36 | hgbot | Note Added: 0054803 | |
| 2012-12-10 16:36 | hgbot | Status | new => resolved |
| 2012-12-10 16:36 | hgbot | Resolution | open => fixed |
| 2012-12-10 16:36 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3c096d9564b07aaef3c8673c83fe85c511fa5f3d [^] |
| 2012-12-10 16:41 | jonalegriaesarte | Note Added: 0054805 | |
| 2012-12-10 16:41 | jonalegriaesarte | Status | resolved => new |
| 2012-12-10 16:41 | jonalegriaesarte | Resolution | fixed => open |
| 2012-12-11 17:54 | hudsonbot | Checkin | |
| 2012-12-11 17:54 | hudsonbot | Note Added: 0054863 | |
| 2012-12-12 12:06 | hgbot | Checkin | |
| 2012-12-12 12:06 | hgbot | Note Added: 0054883 | |
| 2012-12-12 12:06 | hgbot | Status | new => resolved |
| 2012-12-12 12:06 | hgbot | Resolution | open => fixed |
| 2012-12-12 12:06 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/3c096d9564b07aaef3c8673c83fe85c511fa5f3d [^] => http://code.openbravo.com/erp/devel/pi/rev/1b7d9e96eb3054c2c0bed3d308962e8c5d47a52a [^] |
| 2012-12-17 13:33 | hudsonbot | Checkin | |
| 2012-12-17 13:33 | hudsonbot | Note Added: 0054987 | |
| 2013-01-09 11:05 | egoitz | Review Assigned To | => egoitz |
| 2013-01-09 11:05 | egoitz | Note Added: 0055414 | |
| 2013-01-09 11:05 | egoitz | Status | resolved => closed |
| 2013-01-09 11:05 | egoitz | Fixed in Version | => 3.0MP19 |
| 2013-02-08 10:48 | hgbot | Checkin | |
| 2013-02-08 10:48 | hgbot | Note Added: 0056286 | |
| 2013-02-08 10:55 | eduardo_Argal | Assigned To | jonalegriaesarte => eduardo_Argal |
| 2013-02-08 10:55 | eduardo_Argal | Status | closed => new |
| 2013-02-08 10:55 | eduardo_Argal | Resolution | fixed => open |
| 2013-02-08 10:55 | eduardo_Argal | Fixed in Version | 3.0MP19 => |
| 2013-02-08 10:56 | eduardo_Argal | Triggers an Emergency Pack | => No |
| 2013-02-08 10:56 | eduardo_Argal | Type | defect => design defect |
| 2013-02-09 07:24 | hudsonbot | Checkin | |
| 2013-02-09 07:24 | hudsonbot | Note Added: 0056313 | |
| 2013-03-15 12:11 | hgbot | Checkin | |
| 2013-03-15 12:11 | hgbot | Note Added: 0057270 | |
| 2013-03-15 12:11 | hgbot | Status | new => resolved |
| 2013-03-15 12:11 | hgbot | Resolution | open => fixed |
| 2013-03-15 12:11 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/1b7d9e96eb3054c2c0bed3d308962e8c5d47a52a [^] => http://code.openbravo.com/erp/devel/pi/rev/768fee4f6be21a6df0a6e9a97f3ae6b87ba1efb1 [^] |
| 2013-03-15 12:12 | hgbot | Checkin | |
| 2013-03-15 12:12 | hgbot | Note Added: 0057273 | |
| 2013-03-15 12:19 | hgbot | Checkin | |
| 2013-03-15 12:19 | hgbot | Note Added: 0057274 | |
| 2013-03-22 13:24 | hgbot | Checkin | |
| 2013-03-22 13:24 | hgbot | Note Added: 0057389 | |
| 2013-03-22 13:40 | hgbot | Checkin | |
| 2013-03-22 13:40 | hgbot | Note Added: 0057390 | |
| 2013-03-25 17:33 | hgbot | Checkin | |
| 2013-03-25 17:33 | hgbot | Note Added: 0057449 | |
| 2013-03-26 16:39 | hudsonbot | Checkin | |
| 2013-03-26 16:39 | hudsonbot | Note Added: 0057472 | |
| 2013-03-27 16:38 | hgbot | Checkin | |
| 2013-03-27 16:38 | hgbot | Note Added: 0057505 | |
| 2013-04-01 18:58 | hudsonbot | Checkin | |
| 2013-04-01 18:58 | hudsonbot | Note Added: 0057550 | |
| 2013-04-02 11:54 | hgbot | Checkin | |
| 2013-04-02 11:54 | hgbot | Note Added: 0057563 | |
| 2013-04-07 01:03 | hudsonbot | Checkin | |
| 2013-04-07 01:03 | hudsonbot | Note Added: 0057755 | |
| 2013-04-08 18:49 | hgbot | Checkin | |
| 2013-04-08 18:49 | hgbot | Note Added: 0057790 | |
| 2013-04-08 19:38 | dmiguelez | Note Added: 0057792 | |
| 2013-04-08 19:38 | dmiguelez | Status | resolved => closed |
| 2013-04-09 11:34 | hudsonbot | Checkin | |
| 2013-04-09 11:34 | hudsonbot | Note Added: 0057796 | |
|
Notes |
|
|
(0054226)
|
|
egoitz
|
|
2012-11-14 13:38
|
|
|
possible solution attached |
|
|
|
(0054803)
|
|
hgbot
|
|
2012-12-10 16:36
|
|
Repository: erp/devel/pi
Changeset: 3c096d9564b07aaef3c8673c83fe85c511fa5f3d
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Mon Dec 10 16:35:46 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3c096d9564b07aaef3c8673c83fe85c511fa5f3d [^]
Fixes issue 0022300: Long time to unpost a sales invoice where there are too
many rows on fact_acct table
---
M src-db/database/model/functions/FACT_ACCT_RESET.xml
---
|
|
|
|
(0054805)
|
|
jonalegriaesarte
|
|
2012-12-10 16:41
|
|
|
|
|
|
|
|
|
(0054883)
|
|
hgbot
|
|
2012-12-12 12:06
|
|
Repository: erp/devel/pi
Changeset: 1b7d9e96eb3054c2c0bed3d308962e8c5d47a52a
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Wed Dec 12 12:06:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1b7d9e96eb3054c2c0bed3d308962e8c5d47a52a [^]
Fixes issue 0022300: Long time to unpost a sales invoice where there are too
many rows on fact_acct table
---
M src-db/database/model/functions/FACT_ACCT_RESET.xml
---
|
|
|
|
|
|
|
|
(0055414)
|
|
egoitz
|
|
2013-01-09 11:05
|
|
|
|
|
(0056286)
|
|
hgbot
|
|
2013-02-08 10:48
|
|
|
|
|
|
|
|
|
(0057270)
|
|
hgbot
|
|
2013-03-15 12:11
|
|
Repository: erp/devel/pi
Changeset: 768fee4f6be21a6df0a6e9a97f3ae6b87ba1efb1
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Mar 14 15:08:23 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/768fee4f6be21a6df0a6e9a97f3ae6b87ba1efb1 [^]
Fixed 22300 Reset accouting process refactor
---
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src-db/database/sourcedata/AD_TREENODE.xml
M src/org/openbravo/erpCommon/ad_actionButton/Posted.java
A src/org/openbravo/erpCommon/ad_process/ResetAccountingProcess.java
A src/org/openbravo/financial/ResetAccounting.java
---
|
|
|
|
(0057273)
|
|
hgbot
|
|
2013-03-15 12:12
|
|
|
|
|
(0057274)
|
|
hgbot
|
|
2013-03-15 12:19
|
|
|
|
|
(0057389)
|
|
hgbot
|
|
2013-03-22 13:24
|
|
|
|
|
(0057390)
|
|
hgbot
|
|
2013-03-22 13:40
|
|
|
|
|
(0057449)
|
|
hgbot
|
|
2013-03-25 17:33
|
|
Repository: erp/devel/pi
Changeset: 0419d3571df6a2de19bb62c78d881e5951c2860f
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Mar 25 17:32:56 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0419d3571df6a2de19bb62c78d881e5951c2860f [^]
Related to Issue 22300. Blocks Unpost of a Document if the Period
is closed for that DocBaseType.
---
M src/org/openbravo/erpCommon/ad_callouts/SL_Invoice_Amt.java
M src/org/openbravo/financial/ResetAccounting.java
---
|
|
|
|
|
|
|
|
(0057505)
|
|
hgbot
|
|
2013-03-27 16:38
|
|
Repository: erp/devel/pi
Changeset: 3f1d1d393dcb7690c703d144ecff19011ee216c3
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Mar 27 16:38:52 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3f1d1d393dcb7690c703d144ecff19011ee216c3 [^]
Related to issue 22300 and open/close period project
---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/event/OpenClosePeriodHandler.java
M src/org/openbravo/erpCommon/ad_actionButton/Posted.java
M src/org/openbravo/erpCommon/ad_process/ResetAccountingProcess.java
M src/org/openbravo/erpCommon/businessUtility/PeriodControlUtility.java
M src/org/openbravo/financial/ResetAccounting.java
---
|
|
|
|
|
|
|
|
(0057563)
|
|
hgbot
|
|
2013-04-02 11:54
|
|
|
|
|
|
|
|
|
(0057790)
|
|
hgbot
|
|
2013-04-08 18:49
|
|
Repository: erp/devel/pi
Changeset: 76cf439f486f0dbcb2a439a307ea1dae202a6926
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Apr 08 18:49:05 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/76cf439f486f0dbcb2a439a307ea1dae202a6926 [^]
Related to Issue 22300. Removes wrongly commented section.
---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/Reconciliation.java
---
|
|
|
|
|
|
|
|
|
|