Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010589Openbravo ERP09. Financial managementpublic2009-09-14 19:342009-10-06 11:20
Reportershuehner 
Assigned Toshuehner 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP6 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010589: CreateAccountingReport process misses some to_date calls and has extra, wrong to_number for c_acctschema_id
DescriptionThis process xsql file (erpCommon/ad_process/CreateAccountingReport_data.xsql) is missing two to_date calls for date fields (2.40 and 2.50) and has a to_number call (in 2.50) around c_acctschema_id (which will fails with newly create accounting schemas).
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0010590 closed shuehner CreateAccountingReport process misses some to_date calls and has extra, wrong to_number for c_acctschema_id 
blocks defect 0004038 closed shuehner Slow compilation in sqlC part due to high amount of data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-14 19:34shuehnerNew Issue
2009-09-14 19:34shuehnerAssigned To => rafaroda
2009-09-14 19:34shuehnerOBNetwork customer => No
2009-09-14 19:34shuehnerAssigned Torafaroda => shuehner
2009-09-14 19:35shuehnerStatusnew => scheduled
2009-09-14 19:35shuehnerfix_in_branch => pi
2009-09-14 19:36shuehnerRelationship addedblocks 0004038
2009-09-14 19:37hgbotCheckin
2009-09-14 19:37hgbotNote Added: 0019934
2009-09-14 19:37hgbotStatusscheduled => resolved
2009-09-14 19:37hgbotResolutionopen => fixed
2009-09-14 19:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8d6b665d24c06ae2b80e800fb4ac1fa1e88fbb03 [^]
2009-09-14 19:45hudsonbotCheckin
2009-09-14 19:45hudsonbotNote Added: 0019937
2009-09-14 19:50hudsonbotCheckin
2009-09-14 19:50hudsonbotNote Added: 0019938
2009-09-14 19:57hudsonbotCheckin
2009-09-14 19:57hudsonbotNote Added: 0019950
2009-09-14 20:42hudsonbotCheckin
2009-09-14 20:42hudsonbotNote Added: 0019959
2009-09-14 20:44hudsonbotCheckin
2009-09-14 20:44hudsonbotNote Added: 0019960
2009-09-14 20:47hudsonbotCheckin
2009-09-14 20:47hudsonbotNote Added: 0019963
2009-09-14 20:48hudsonbotCheckin
2009-09-14 20:48hudsonbotNote Added: 0019966
2009-09-14 21:07hudsonbotCheckin
2009-09-14 21:07hudsonbotNote Added: 0019974
2009-09-14 21:17hudsonbotCheckin
2009-09-14 21:17hudsonbotNote Added: 0019982
2009-09-14 23:15hudsonbotCheckin
2009-09-14 23:15hudsonbotNote Added: 0020004
2009-09-15 01:09hudsonbotCheckin
2009-09-15 01:09hudsonbotNote Added: 0020012
2009-09-15 09:45hudsonbotCheckin
2009-09-15 09:45hudsonbotNote Added: 0020021
2009-09-15 09:50hudsonbotCheckin
2009-09-15 09:50hudsonbotNote Added: 0020026
2009-09-15 10:34hudsonbotCheckin
2009-09-15 10:34hudsonbotNote Added: 0020033
2009-09-15 10:57hudsonbotCheckin
2009-09-15 10:57hudsonbotNote Added: 0020039
2009-09-15 11:09hudsonbotCheckin
2009-09-15 11:09hudsonbotNote Added: 0020045
2009-09-15 12:12hudsonbotCheckin
2009-09-15 12:12hudsonbotNote Added: 0020052
2009-09-15 12:35hudsonbotCheckin
2009-09-15 12:35hudsonbotNote Added: 0020066
2009-09-18 13:20psarobeStatusresolved => closed
2009-09-18 13:20psarobeFixed in Version => 2.50MP6
2009-09-19 00:00anonymoussf_bug_id0 => 2861738
2009-09-29 14:11hgbotCheckin
2009-09-29 14:11hgbotNote Added: 0020460
2009-09-29 14:11hgbotStatusclosed => resolved
2009-09-29 14:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/8d6b665d24c06ae2b80e800fb4ac1fa1e88fbb03 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/8d6b665d24c06ae2b80e800fb4ac1fa1e88fbb03 [^]
2009-10-06 11:20psarobeStatusresolved => closed
2009-10-06 11:20psarobeNote Added: 0020749

Notes
(0019934)
hgbot   
2009-09-14 19:37   
Repository: erp/devel/pi
Changeset: 8d6b665d24c06ae2b80e800fb4ac1fa1e88fbb03
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Sep 14 19:37:10 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8d6b665d24c06ae2b80e800fb4ac1fa1e88fbb03 [^]

Fixed 10589: Add missing to_date calls in selectInitial method. Removed
to_number in c_acctschema_id filter.

---
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
---
(0019937)
hudsonbot   
2009-09-14 19:45   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/863/ [^]
------
(0019938)
hudsonbot   
2009-09-14 19:50   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/756/ [^]
------
(0019950)
hudsonbot   
2009-09-14 19:57   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/177/ [^]
------
(0019959)
hudsonbot   
2009-09-14 20:42   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/352/ [^]
------
(0019960)
hudsonbot   
2009-09-14 20:44   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/346/ [^]
------
(0019963)
hudsonbot   
2009-09-14 20:47   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/864/ [^]
------
(0019966)
hudsonbot   
2009-09-14 20:48   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/757/ [^]
------
(0019974)
hudsonbot   
2009-09-14 21:07   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/97/ [^]
------
(0019982)
hudsonbot   
2009-09-14 21:17   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/178/ [^]
------
(0020004)
hudsonbot   
2009-09-14 23:15   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^]
------
(0020012)
hudsonbot   
2009-09-15 01:09   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/98/ [^]
------
(0020021)
hudsonbot   
2009-09-15 09:45   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/865/ [^]
------
(0020026)
hudsonbot   
2009-09-15 09:50   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/758/ [^]
------
(0020033)
hudsonbot   
2009-09-15 10:34   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-smoke-test/64/ [^]
------
(0020039)
hudsonbot   
2009-09-15 10:57   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/866/ [^]
------
(0020045)
hudsonbot   
2009-09-15 11:09   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/759/ [^]
------
(0020052)
hudsonbot   
2009-09-15 12:12   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/99/ [^]
------
(0020066)
hudsonbot   
2009-09-15 12:35   
Fixed Issue 10589

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/179/ [^]
------
(0020460)
hgbot   
2009-09-29 14:11   
Repository: erp/devel/pi-pageddatagrid
Changeset: 8d6b665d24c06ae2b80e800fb4ac1fa1e88fbb03
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Sep 14 19:37:10 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/8d6b665d24c06ae2b80e800fb4ac1fa1e88fbb03 [^]

Fixed 10589: Add missing to_date calls in selectInitial method. Removed
to_number in c_acctschema_id filter.

---
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
---
(0020749)
psarobe   
2009-10-06 11:20   
Closed again because hudson has reopened without no reason