Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007910 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 02. Master data management | major | always | 2009-02-23 15:17 | 2009-05-21 18:16 | |||
| Reporter | mirurita | View Status | public | |||||
| Assigned To | iperdomo | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.40MP4 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 4b427ecd4214 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.40 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0007910: Import Orders: Ordered date is not imported correctly | |||||||
| Description | When the imported order is inserted in I_Order table (ExternalSalesIOrderData class), dateordered field is formatted: to_date('23-03-2009 12:20:40', 'dd-MM-yyyy HH:mm:ss') Postgre can't distinguish between MM and mm so it takes the minutes like months. In this example the result will be: 2010-08-25 | |||||||
| Steps To Reproduce | Synchronize Orders between POS and ERP. Follow this tutorial: http://wiki.openbravo.com/wiki/Openbravo_POS_Integration#Openbravo_configuration [^] | |||||||
| Proposed Solution | Use other format to minutes. to_date('23-03-2009 12:20:40', 'dd-MM-yyyy HH:Mi:ss') | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0014900) hgbot (developer) 2009-03-24 14:29 |
Repository: erp/stable/2.40 Changeset: 4b427ecd4214f0266828cb5a5455cd9cc0b6153d Author: Iván Perdomo <ivan.perdomo <at> openbravo.com> Date: Tue Mar 24 14:28:33 2009 +0100 URL: http://code.openbravo.com/erp/stable/2.40/rev/4b427ecd4214f0266828cb5a5455cd9cc0b6153d [^] Fixes issue 7910: Removed date format to use the database default one --- M src/org/openbravo/erpCommon/ws/externalSales/ExternalSalesIOrder_data.xsql --- |
|
(0016563) psarobe (manager) 2009-05-21 18:16 |
Unable to test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-03-03 10:19 | rafaroda | Type | defect => backport |
| 2009-03-03 10:19 | rafaroda | fix_in_branch | => 2.40 |
| 2009-03-24 11:40 | rafaroda | Assigned To | pheenan => iperdomo |
| 2009-03-24 14:29 | hgbot | Checkin | |
| 2009-03-24 14:29 | hgbot | Note Added: 0014900 | |
| 2009-03-24 14:29 | hgbot | Status | scheduled => resolved |
| 2009-03-24 14:29 | hgbot | Resolution | open => fixed |
| 2009-03-24 14:29 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/4b427ecd4214f0266828cb5a5455cd9cc0b6153d [^] |
| 2009-05-10 19:37 | psarobe | Fixed in Version | => 2.40MP4 |
| 2009-05-21 18:16 | psarobe | Status | resolved => closed |
| 2009-05-21 18:16 | psarobe | Note Added: 0016563 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |