0033130: em_obpos_createdabsolute is not using Absolute DateTime reference

diff --git a/src/org/openbravo/mobile/core/process/JSONPropertyToEntity.java b/src/org/openbravo/mobile/core/process/JSONPropertyToEntity.java
--- a/src/org/openbravo/mobile/core/process/JSONPropertyToEntity.java
+++ b/src/org/openbravo/mobile/core/process/JSONPropertyToEntity.java
@@ -94,7 +94,7 @@
           } else {
             bob.set(p.getName(), OBMOBCUtils.calculateServerDate((String) value, dateOffset));
           }
-        } else if (p.isDatetime() || p.isTime()) {
+        } else if (p.isDatetime() || p.isTime() || p.isAbsoluteDateTime()) {
           if (value == null || "".equals(value)) {
             bob.set(p.getName(), null);
           } else {

diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -6018,7 +6018,7 @@
 <!--66406AFAB96F42BDBB4E5ED8C541DD2F-->  <HELP><![CDATA[The Created Absolute field indicates the date and time without the local time zone that this record was created.]]></HELP>
 <!--66406AFAB96F42BDBB4E5ED8C541DD2F-->  <COLUMNNAME><![CDATA[EM_Obpos_Createdabsolute]]></COLUMNNAME>
 <!--66406AFAB96F42BDBB4E5ED8C541DD2F-->  <AD_TABLE_ID><![CDATA[259]]></AD_TABLE_ID>
-<!--66406AFAB96F42BDBB4E5ED8C541DD2F-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--66406AFAB96F42BDBB4E5ED8C541DD2F-->  <AD_REFERENCE_ID><![CDATA[478169542A1747BD942DD70C8B45089C]]></AD_REFERENCE_ID>
 <!--66406AFAB96F42BDBB4E5ED8C541DD2F-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
 <!--66406AFAB96F42BDBB4E5ED8C541DD2F-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--66406AFAB96F42BDBB4E5ED8C541DD2F-->  <ISPARENT><![CDATA[N]]></ISPARENT>

diff --git a/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/AbsoluteDateTime.java b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/AbsoluteDateTime.java
new file mode 100644
--- /dev/null
+++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/AbsoluteDateTime.java
@@ -0,0 +1,96 @@
+/*
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
+ * Version 1.1  with a permitted attribution clause; you may not  use this
+ * file except in compliance with the License. You  may  obtain  a copy of
+ * the License at http://www.openbravo.com/legal/license.html
+ * Software distributed under the License  is  distributed  on  an "AS IS"
+ * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+ * License for the specific  language  governing  rights  and  limitations
+ * under the License.
+ * The Original Code is Openbravo ERP.
+ * The Initial Developer of the Original Code is Openbravo S.L.U.
+ * All portions are Copyright (C) 2016 Openbravo S.L.U.
+ * All Rights Reserved.
+ * Contributor(s):
+ ************************************************************************
+ *
+ * @author GIG
+ *
+ */
+
+package org.openbravo.test.mobile.retail.pack.selenium.tests.receipts;
+
+import static org.hamcrest.MatcherAssert.assertThat;
+import static org.hamcrest.Matchers.equalTo;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+
+import org.json.JSONException;
+import org.json.JSONObject;
+import org.junit.Test;
+import org.openbravo.test.mobile.common.selenium.database.DatabaseHelperSelect;
+import org.openbravo.test.mobile.common.selenium.javascript.BackboneHelper;
+import org.openbravo.test.mobile.common.selenium.javascript.TestId;
+import org.openbravo.test.mobile.common.selenium.terminals.WebPOSTerminalHelper;
+
+public class AbsoluteDateTime extends WebPOSTerminalHelper {
+
+  static String orderId;
+  static String absDateTime;
+
+  @Test
+  public void test() {
+    final String documentNo = BackboneHelper.getDocumentNo();
+    tap(TestId.BUTTON_BROWSE);
+    tap(TestId.BUTTON_CATEGORY_SKI);
+    tap(TestId.BUTTON_PRODUCT_SKI_GLIDEWAX);
+    tap(TestId.BUTTON_EDIT);
+    verify(TestId.LABEL_TOTALTOPAY, "12.50");
+    tap(TestId.BUTTON_PAY);
+    tap(TestId.BUTTON_PAY_EXACT);
+    tap(TestId.BUTTON_PAY_DONE);
+    verify(TestId.LABEL_TOTALTOPAY, "0.00");
+    verifyAbsoluteTimes(documentNo);
+
+  }
+
+  public static void verifyAbsoluteTimes(final String documentNo) {
+    // verify that the order description has been correctly saved in the backend
+    final String sql = "select c_order_id, em_obpos_createdabsolute from C_ORDER "
+        + "WHERE documentno = '" + documentNo + "'";
+
+    new DatabaseHelperSelect() {
+      @Override
+      protected void yieldResultSet(final ResultSet rs) throws SQLException {
+
+        orderId = rs.getString("c_order_id");
+        absDateTime = rs.getString("em_obpos_createdabsolute");
+
+      }
+    }.execute(sql, 1);
+
+    // Look for import entry
+    final String sqlImportEntry = "select jsoninfo from c_import_entry "
+        + "WHERE jsoninfo ILIKE '%" + orderId + "%'";
+
+    new DatabaseHelperSelect() {
+
+      @Override
+      protected void yieldResultSet(final ResultSet rsImportEntry) throws SQLException {
+
+        final String jsonString = rsImportEntry.getString("jsoninfo");
+        try {
+          final JSONObject json = new JSONObject(jsonString);
+          final JSONObject jsonOrder = (JSONObject) json.getJSONArray("data").get(0);
+          assertThat(jsonOrder.getString("obposCreatedabsolute"), equalTo(absDateTime));
+        } catch (JSONException e) {
+          e.printStackTrace();
+        }
+      }
+    }.execute(sqlImportEntry, 1);
+
+  }
+}