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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0013224
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2010-05-05 10:242010-05-18 21:43
ReporterharikrishnanView Statuspublic 
Assigned Toharikrishnan 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisiond2cb95856966
ProjectionnoneETAnoneTarget Versionpi
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013224: When completing or processing documents the updatedby column is not updated properly

DescriptionThese are the places where the audit fields are not properly updated.

1.Matched Purchase Orders
2.Matched Invoices
3.Create Purchase Invoices from Deliveries

Steps To Reproduce-Create a document with one user
Process or complete with other user
See that the updatedby is not properly updated.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0013230pi closedharikrishnan When completing or processing documents the updatedby column is not updated properly 

-  Notes
(0026978)
hgbot (developer)
2010-05-06 11:17

Repository: erp/devel/pi
Changeset: d2cb958569665fa0be92726b68f6dec3bf66906d
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu May 06 14:46:25 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/d2cb958569665fa0be92726b68f6dec3bf66906d [^]

Fixes issue 13224: When completing or processing documents the updated-by column is not updated properly.

---
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
M src-db/database/model/functions/C_ORDER_PO_CREATE.xml
---
(0026979)
harikrishnan (reporter)
2010-05-06 11:21

Steps to test:
*Create two new user.
    1.UserA
    2.userB
*Login as UserA
*Create new record in each above mentioned section(Don't complete it or process it)
*Login as UserB and complete all the record above created.


Root cause & solution:
Audit fields are not properly updated.Hence the user id is taken from the pinstance table and used in update and insert statement.

Impact:
These are the files that are affected by this fix.

C_INVOICE_CANCEL.xml
C_INVOICE_CREATE.xml
C_INVOICE_POST0.xml
C_ORDER_POST.xml
M_REQUISITION_CREATEPO.xml
(0027333)
sureshbabu (reporter)
2010-05-15 18:38

@ Hari,

Sorry the documents you have mentioned above are created by the system automatically after performing respective actions. So please update the steps to reproduce in detail. or contact me so that we can discuss on this.
(0027350)
sureshbabu (reporter)
2010-05-17 08:41

Right now system updates the documents with the user name instead of system id.
(0027485)
hudsonbot (developer)
2010-05-18 21:43

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d2cb95856966 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]

- Issue History
Date Modified Username Field Change
2010-05-05 10:24 harikrishnan New Issue
2010-05-05 10:24 harikrishnan Assigned To => adrianromero
2010-05-05 10:46 harikrishnan Description Updated View Revisions
2010-05-05 14:06 arunkumar Status new => scheduled
2010-05-05 14:06 arunkumar fix_in_branch => pi
2010-05-06 11:14 harikrishnan Assigned To adrianromero => harikrishnan
2010-05-06 11:17 hgbot Checkin
2010-05-06 11:17 hgbot Note Added: 0026978
2010-05-06 11:17 hgbot Status scheduled => resolved
2010-05-06 11:17 hgbot Resolution open => fixed
2010-05-06 11:17 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d2cb958569665fa0be92726b68f6dec3bf66906d [^]
2010-05-06 11:21 harikrishnan Note Added: 0026979
2010-05-15 18:38 sureshbabu Note Added: 0027333
2010-05-17 08:41 sureshbabu Note Added: 0027350
2010-05-17 08:41 sureshbabu Status resolved => closed
2010-05-18 00:01 anonymous sf_bug_id 0 => 3002962
2010-05-18 21:43 hudsonbot Checkin
2010-05-18 21:43 hudsonbot Note Added: 0027485


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker