Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0040829Openbravo ERPA. Platformpublic2019-05-09 16:372019-05-21 15:17
prakashmurugesan88 
caristu 
immediatemajoralways
closedfixed 
5
 
3.0PR19Q3 
alostale
Core
No
0040829: Unable to create record with fields having references 'DateTime_From (Date)' and 'DateTime_To (Date)'
1. Save Error:
While trying to create a record with fields having reference 'DateTime_From (Date)' or 'DateTime_To (Date)', an error occurs "Unparsable Date".
Please Refer Attachment "SaveError".

2. TimeStamp displayed in grid view but not in form view:
Try to generate record using reference "Date" instead of 'DateTime_From (Date)' or 'DateTime_To (Date)'.
Both in form view and grid view only date is visible.
Again change the reference from "Date" to 'DateTime_From (Date)' or 'DateTime_To (Date)'.
In Form View only date is visible but in grid view date with timestamp is visible.
Please Refer Attachment "FormView" & "GridView".
* Alternative 1

Open Purchase Order window create a record say SPPO1000005.
As the reference for "Order Date" and "Scheduled Delivery Date" is "Date", record will be created successfully.
Now Notice the dates in form view as well grid view, only dates are displayed.

To Reproduce the issue configure "Order Date" and "Scheduled Delivery Date" in "Purchase Order" window as below,
    "Order Date" ==> Changed Reference from "Date" to "DateTime_From (Date)"
    "Scheduled Date" ==> Changed Reference from "Date" to "DateTime_To (Date)"

Build the Environment

1.Save Error:
Open "Purchase Order" window.
Try to create a record with "Order Date" and "Scheduled Delivery Date" and all other details and save.
Error "Unparseable Date" occurs.

2.Time Stamp:
Open Previously Created Record with date reference [Here SPPO1000005].
Notice in form view for "Order Date" and "Scheduled Delivery Date", date alone is displayed.
Close the form view.
Notice in grid view for "Order Date" and "Scheduled Delivery Date", date with timestamp is displayed.

* Alternative 2
1. Install Resource and Reservation Management module (org.openbravo.module.resources)
2. Create a new Resource with Water as Product Category
3. As F&B admin create a Sales Order header, in org F&B España - Región Norte
4. Add a new line with Agua sin gas as product
5. Create a new Reservation for that line



No tags attached.
related to defect 0040735 closed caristu Records can not be exported to CSV 
related to design defect 0040959 acknowledged Triage Platform Base While creating a reservation, it is different the info shown in grid and in form view. 
png SaveError.png (220,128) 2019-05-09 16:37
https://issues.openbravo.com/file_download.php?file_id=12932&type=bug
png

png FormView.png (217,308) 2019-05-09 16:37
https://issues.openbravo.com/file_download.php?file_id=12933&type=bug
png

png GridView.png (167,157) 2019-05-09 16:38
https://issues.openbravo.com/file_download.php?file_id=12934&type=bug
png
Issue History
2019-05-09 16:37prakashmurugesan88New Issue
2019-05-09 16:37prakashmurugesan88Assigned To => platform
2019-05-09 16:37prakashmurugesan88File Added: SaveError.png
2019-05-09 16:37prakashmurugesan88Modules => Core
2019-05-09 16:37prakashmurugesan88Triggers an Emergency Pack => No
2019-05-09 16:37prakashmurugesan88File Added: FormView.png
2019-05-09 16:38prakashmurugesan88File Added: GridView.png
2019-05-09 16:42guillermogilResolution time => 1559167200
2019-05-10 09:26alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=18746#r18746
2019-05-10 09:39alostaleRelationship addedrelated to 0040735
2019-05-10 10:41caristuAssigned Toplatform => caristu
2019-05-13 10:58alostalePriorityhigh => immediate
2019-05-15 11:06caristuStatusnew => scheduled
2019-05-16 16:03hgbotCheckin
2019-05-16 16:03hgbotNote Added: 0111723
2019-05-16 16:03hgbotStatusscheduled => resolved
2019-05-16 16:03hgbotResolutionopen => fixed
2019-05-16 16:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/59d8a1189664901f74cc2af8a2c8d07e34d5618d [^]
2019-05-16 16:04caristuReview Assigned To => alostale
2019-05-16 16:10hgbotCheckin
2019-05-16 16:10hgbotNote Added: 0111724
2019-05-17 08:21alostaleNote Added: 0111756
2019-05-17 08:21alostaleStatusresolved => closed
2019-05-17 08:21alostaleFixed in Version => 3.0PR19Q3
2019-05-21 15:17hudsonbotCheckin
2019-05-21 15:17hudsonbotNote Added: 0112033
2019-05-21 15:17hudsonbotCheckin
2019-05-21 15:17hudsonbotNote Added: 0112034
2019-05-28 12:36caristuRelationship addedrelated to 0040959

Notes
(0111723)
hgbot   
2019-05-16 16:03   
Repository: erp/devel/pi
Changeset: 59d8a1189664901f74cc2af8a2c8d07e34d5618d
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu May 16 14:01:42 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/59d8a1189664901f74cc2af8a2c8d07e34d5618d [^]

fixes bug 40829: Can't save date taken from picker of DateTime_From/To fields

   It was not possible to save a date taken from the date picker of those fields using DateTime_From/To references. This is because the JsonToDataConverter expects a date time value to parse, but instead a plain date is received.

  The reason why a date was being received is because as this references are configured to not show the time (showTime: false), its date picker builds a logical date rather than a specific datetime value.

  To fix the problem we are setting the date received from the picker to be not logical, this way dates will be serialized to the expected DateTime value when sending the data to the Datasource in order to save/update the record.

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-datetime.js
---
(0111724)
hgbot   
2019-05-16 16:10   
Repository: erp/devel/pi
Changeset: b82519cbc5e9cd9639123b624d7871dea53f277e
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu May 16 16:10:20 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b82519cbc5e9cd9639123b624d7871dea53f277e [^]

related to issue 40829: fix comments

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-datetime.js
---
(0111756)
alostale   
2019-05-17 08:21   
reviewed + tested
(0112033)
hudsonbot   
2019-05-21 15:17   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9b8f37d9d85e [^]
Maturity status: Test
(0112034)
hudsonbot   
2019-05-21 15:17   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9b8f37d9d85e [^]
Maturity status: Test