Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0016952Openbravo ERP07. Sales managementpublic2011-05-02 10:152011-06-13 10:47
adrianromero 
dalsasua 
immediatemajoralways
closedfixed 
5
pi 
3.0MP0 
Core
No
0016952: The date of documents created by a process includes the time, but when creating manually they don't include time
The date of documents created by a process includes the time, but when creating manually they don't include time.
This is a problem in some triggers because when updating a trigger, although the data is not modified, the triggers identify the data as modified.

This is beceuse the new.date is taken without time, and the old.date with time,
so if you compare them they looks different.

-Create an standar sales order with a line.
-complete it
-Go to generate shipment from orders, and select the created order.
-The invoice for the order is created, completed and processed.
-Go to the new invoice.
-Try to modify the description , only the description.
-You get a message saying the the process is completed/posted.
*This message should not appear because the trigger allows modifying the description, but in this case, the triggers identifies that the date has changed, becuase is comparing a date with time , with a date wihout time.
The processes that creates documents, such as m_inout_create or c_invoice_create
should insert the date formated to not use time.
No tags attached.
blocks backport 00159432.50MP28 closed adrianromero The date of documents created by a process includes the time, but when creating manually they don't include time 
Issue History
2011-05-02 10:15adrianromeroNew Issue
2011-05-02 10:15adrianromeroAssigned To => adrianromero
2011-05-02 10:15adrianromeroModules => Core
2011-05-02 10:15adrianromeroIssue generated from0015943
2011-05-02 10:15adrianromeroRelationship addedblocks 0015943
2011-05-02 10:27hgbotCheckin
2011-05-02 10:27hgbotNote Added: 0036240
2011-05-02 10:27hgbotStatusnew => resolved
2011-05-02 10:27hgbotResolutionopen => fixed
2011-05-02 10:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b04aa00321faa851448e666c49aba19faaa11d62 [^]
2011-05-02 10:27adrianromeroNote Added: 0036241
2011-05-12 13:28hudsonbotCheckin
2011-05-12 13:28hudsonbotNote Added: 0036791
2011-06-03 10:58dalsasuaAssigned Toadrianromero => dalsasua
2011-06-13 10:47jonalegriaesarteNote Added: 0038283
2011-06-13 10:47jonalegriaesarteStatusresolved => closed
2011-06-13 10:47jonalegriaesarteFixed in Version => 3.0MP0

Notes
(0036240)
hgbot   
2011-05-02 10:27   
Repository: erp/devel/pi
Changeset: b04aa00321faa851448e666c49aba19faaa11d62
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon May 02 10:25:37 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b04aa00321faa851448e666c49aba19faaa11d62 [^]

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

---
M src-db/database/model/functions/M_INOUT_CREATE.xml
---
(0036241)
adrianromero   
2011-05-02 10:27   
* Testing the issue

Follow the steps to test and verify that now the description can be modified

* Other areas affected

No other areas affected.
(0036791)
hudsonbot   
2011-05-12 13:28   
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/c40e579fcd38 [^]

Maturity status: Test
(0038283)
jonalegriaesarte   
2011-06-13 10:47   
Verified