Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007910Openbravo ERP02. Master data managementpublic2009-02-23 15:172009-05-21 18:16
Reportermirurita 
Assigned Toiperdomo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40 
Target VersionFixed in Version2.40MP4 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007910: Import Orders: Ordered date is not imported correctly
DescriptionWhen 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 ReproduceSynchronize Orders between POS and ERP.

Follow this tutorial:
http://wiki.openbravo.com/wiki/Openbravo_POS_Integration#Openbravo_configuration [^]
Proposed SolutionUse other format to minutes.
to_date('23-03-2009 12:20:40', 'dd-MM-yyyy HH:Mi:ss')
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0007762 closed iperdomo Import Orders: Ordered date is not imported correctly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-03 10:19rafarodaTypedefect => backport
2009-03-03 10:19rafarodafix_in_branch => 2.40
2009-03-24 11:40rafarodaAssigned Topheenan => iperdomo
2009-03-24 14:29hgbotCheckin
2009-03-24 14:29hgbotNote Added: 0014900
2009-03-24 14:29hgbotStatusscheduled => resolved
2009-03-24 14:29hgbotResolutionopen => fixed
2009-03-24 14:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/4b427ecd4214f0266828cb5a5455cd9cc0b6153d [^]
2009-05-10 19:37psarobeFixed in Version => 2.40MP4
2009-05-21 18:16psarobeStatusresolved => closed
2009-05-21 18:16psarobeNote Added: 0016563

Notes
(0014900)
hgbot   
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   
2009-05-21 18:16   
Unable to test