details: /erp/devel/pi/rev/b04aa00321fa
changeset: 11817:b04aa00321fa
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Mon May 02 10:25:37 2011 +0200
summary: Fixes issue 0016952: The date of documents created by a process
includes the time, but when creating manually they don't include time
It has been removed the time in the fields movementdate and dateacct when
creating a new shipment in the function M_INOUT_CREATE
diffstat:
src-db/database/model/functions/M_INOUT_CREATE.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r 616c74d333f1 -r b04aa00321fa
src-db/database/model/functions/M_INOUT_CREATE.xml
--- a/src-db/database/model/functions/M_INOUT_CREATE.xml Sun May 01
18:59:20 2011 +0200
+++ b/src-db/database/model/functions/M_INOUT_CREATE.xml Mon May 02
10:25:37 2011 +0200
@@ -307,7 +307,7 @@
IF Cur_Order.DocSubTypeSO = 'WR' THEN
v_NEWORDERDATE := Cur_Order.DATEORDERED; -- IS A POS ORDER
ELSE
- v_NEWORDERDATE := now();
+ v_NEWORDERDATE := TRUNC(now());
END IF;
--RAISE_APPLICATION_ERROR(-20100,'el numero documento
es:'||COALESCE(v_DocumentNo,0)||' El doctypeId es:
'||COALESCE(v_DocType_ID,0)||' El cOrderId es:
'||COALESCE(Cur_Order.C_Order_ID,'0'));
@@ -332,7 +332,7 @@
Cur_Order.AD_Org_ID, 'Y', now(), v_User_ID,
now(), v_User_ID, v_DocumentNo, v_DocType_ID,
Cur_Order.Description, 'N', 'C-', v_NEWORDERDATE,
- now(), Cur_Order.C_BPartner_ID,
Cur_Order.C_BPartner_Location_ID, Cur_Order.AD_User_ID,
+ TRUNC(now()), Cur_Order.C_BPartner_ID,
Cur_Order.C_BPartner_Location_ID, Cur_Order.AD_User_ID,
Cur_Order.M_Warehouse_ID, Cur_Order.POReference,
Cur_Order.DateOrdered, Cur_Order.DeliveryRule,
Cur_Order.FreightCostRule, Cur_Order.FreightAmt,
Cur_Order.C_Project_ID, Cur_Order.C_Activity_ID,
Cur_Order.C_Campaign_ID, Cur_Order.AD_OrgTrx_ID,
Cur_Order.User1_ID, Cur_Order.User2_ID,
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
