Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007762Openbravo ERP02. Master data managementpublic2009-02-23 15:172009-03-26 00:00
Reportermirurita 
Assigned Toiperdomo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS20OS VersionrPath Linux
Product Version2.40 
Target VersionFixed in Version 
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
Summary0007762: 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
related to defect 0007524 closed Dowid Import Order. Process Successful message and Warning displayed completing orders. 
depends on backport 0007910 closed iperdomo Import Orders: Ordered date is not imported correctly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-23 15:17miruritaNew Issue
2009-02-23 15:17miruritaAssigned To => rafaroda
2009-02-24 09:54DowidRelationship addedrelated to 0007524
2009-02-24 15:22rafarodaNote Added: 0014028
2009-02-24 15:22rafarodaStatusnew => feedback
2009-02-24 16:55miruritaNote Added: 0014030
2009-03-03 10:19rafarodaOBNetwork customer => No
2009-03-03 10:19rafarodaAssigned Torafaroda => pheenan
2009-03-03 10:19rafarodaPrioritynormal => high
2009-03-03 10:19rafarodaSeverityminor => major
2009-03-03 10:19rafarodaStatusfeedback => new
2009-03-03 10:19rafarodaStatusnew => scheduled
2009-03-03 10:19rafarodafix_in_branch => trunk
2009-03-24 11:40rafarodaAssigned Topheenan => iperdomo
2009-03-25 09:21iperdomoRegression testing => No
2009-03-25 09:21iperdomoStatusscheduled => closed
2009-03-25 09:21iperdomoNote Added: 0014927
2009-03-25 09:21iperdomoResolutionopen => no change required
2009-03-26 00:00anonymoussf_bug_id0 => 2712897

Notes
(0014028)
rafaroda   
2009-02-24 15:22   
Mikel,

Is there a way of reproducing this without using Openbravo POS? I'm afraid that not, but just to know.

Thank you.
(0014030)
mirurita   
2009-02-24 16:55   
Hi,

Sorry, but I don't think so, Openbravo POS is needed.

Don't hesitate to ask me for any help.

Regards.
(0014927)
iperdomo   
2009-03-25 09:21   
All the date formatting is already handled