Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015943
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementminoralways2011-02-10 17:122011-05-03 11:21
ReporteregoitzView Statuspublic 
Assigned Toadrianromero 
PriorityimmediateResolutionfixedFixed in Version2.50MP29
StatusclosedFix in branchFixed in SCM revisionb89aedcaf3d2
ProjectionnoneETAnoneTarget Version2.50MP28
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.4Ant version
Product Version2.50MP25SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015943: The date of documents created by a process includes the time, but when creating manually they don't include time

DescriptionThe 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.

Steps To Reproduce-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.
Proposed SolutionThe processes that creates documents, such as m_inout_create or c_invoice_create
should insert the date formated to not use time.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0016952 closeddalsasua The date of documents created by a process includes the time, but when creating manually they don't include time 

-  Notes
(0034139)
egoitz (developer)
2011-02-10 17:43

 The database is postgresql 8.4. ticket updated
(0036238)
hgbot (developer)
2011-05-02 10:16

 Repository: erp/stable/2.50
Changeset: b89aedcaf3d264d15ce214507a4ca2e3466b28c1
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon May 02 10:14:57 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/b89aedcaf3d264d15ce214507a4ca2e3466b28c1 [^]

Fixes issue 0015943: 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
---
(0036239)
adrianromero (manager)
2011-05-02 10:23

 * Testing the issue

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

* Other areas affected

No other areas affected.
(0036303)
egoitz (developer)
2011-05-03 11:21

 Verified. The problem has not been reproduced witht the steps.

- Issue History
Date Modified Username Field Change
2011-02-10 17:12 egoitz New Issue
2011-02-10 17:12 egoitz Assigned To => adrianromero
2011-02-10 17:12 egoitz Modules => Core
2011-02-10 17:27 egoitz Issue Monitored: networkb
2011-02-10 17:43 egoitz Note Added: 0034139
2011-04-29 12:18 adrianromero Priority high => immediate
2011-04-29 12:18 adrianromero Status new => scheduled
2011-04-29 12:18 adrianromero Type defect => backport
2011-05-02 10:15 adrianromero Issue cloned 0016952
2011-05-02 10:15 adrianromero Relationship added depends on 0016952
2011-05-02 10:16 hgbot Checkin
2011-05-02 10:16 hgbot Note Added: 0036238
2011-05-02 10:16 hgbot Status scheduled => resolved
2011-05-02 10:16 hgbot Resolution open => fixed
2011-05-02 10:16 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/b89aedcaf3d264d15ce214507a4ca2e3466b28c1 [^]
2011-05-02 10:23 adrianromero Note Added: 0036239
2011-05-03 11:21 egoitz Note Added: 0036303
2011-05-03 11:21 egoitz Status resolved => closed
2011-05-03 11:21 egoitz Fixed in Version => 2.50MP29

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker