Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0022354 | Openbravo ERP | A. Platform | public | 2012-11-20 14:01 | 2012-11-27 11:14 |
|
| Reporter | eduardo_Argal | |
| Assigned To | marvintm | |
| Priority | urgent | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0MP18 | |
| Merge Request Status | |
| Review Assigned To | AugustoMauch |
| 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 | 0022354: Default values in columns are not working properly for Date type references |
| Description | When defining a column of reference type date and adding a default value, system can not properly format default value and it results into a strange date. |
| Steps To Reproduce | Go to GLJournal table and define the following default value for datedoc column:
@SQL=SELECT COALESCE((SELECT ENDDATE FROM C_PERIOD WHERE C_PERIOD_ID = @C_PERIOD_ID@),to_date(@DateDoc@)) FROM DUAL
go to GL Journal window and in header create a new record. Mind that document date gets a really strange date. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-11-20 14:01 | eduardo_Argal | New Issue | |
| 2012-11-20 14:01 | eduardo_Argal | Assigned To | => eduardo_Argal |
| 2012-11-20 14:01 | eduardo_Argal | Modules | => Core |
| 2012-11-21 08:34 | marvintm | Status | new => acknowledged |
| 2012-11-21 08:34 | marvintm | Status | acknowledged => scheduled |
| 2012-11-21 08:34 | marvintm | fix_in_branch | => pi |
| 2012-11-21 08:34 | marvintm | Assigned To | eduardo_Argal => marvintm |
| 2012-11-21 08:35 | marvintm | Review Assigned To | => AugustoMauch |
| 2012-11-21 08:35 | marvintm | fix_in_branch | pi => |
| 2012-11-21 08:35 | hgbot | Checkin | |
| 2012-11-21 08:35 | hgbot | Note Added: 0054408 | |
| 2012-11-21 08:35 | hgbot | Status | scheduled => resolved |
| 2012-11-21 08:35 | hgbot | Resolution | open => fixed |
| 2012-11-21 08:35 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/7006f95b06fda6487b61b2339491027ddd14b199 [^] |
| 2012-11-21 19:58 | hudsonbot | Checkin | |
| 2012-11-21 19:58 | hudsonbot | Note Added: 0054439 | |
| 2012-11-27 11:14 | AugustoMauch | Note Added: 0054517 | |
| 2012-11-27 11:14 | AugustoMauch | Status | resolved => closed |
| 2012-11-27 11:14 | AugustoMauch | Fixed in Version | => 3.0MP18 |