Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013225Openbravo ERP04. Warehouse managementpublic2010-05-05 10:492010-05-18 21:43
Reporterharikrishnan 
Assigned Toharikrishnan 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013225: 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.Physical Inventory
2.Goods Movements
3.Bill of Materials Production
4.Generate Average Costs
5.Goods Transaction

Steps To Reproduce-Create a document with one user
Process or complete with other user
See that the updatedby is not properly updated.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks backport 0013243 closed harikrishnan When completing or processing documents the updatedby column is not updated properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-05-05 10:49harikrishnanNew Issue
2010-05-05 10:49harikrishnanAssigned To => adrianromero
2010-05-05 10:49harikrishnanOBNetwork customer => No
2010-05-06 12:57harikrishnanStatusnew => scheduled
2010-05-06 12:57harikrishnanfix_in_branch => pi
2010-05-06 12:59harikrishnanAssigned Toadrianromero => harikrishnan
2010-05-06 13:02harikrishnanIssue cloned0013243
2010-05-06 13:02harikrishnanRelationship addedblocks 0013243
2010-05-06 14:37hgbotCheckin
2010-05-06 14:37hgbotNote Added: 0026986
2010-05-06 14:37hgbotStatusscheduled => resolved
2010-05-06 14:37hgbotResolutionopen => fixed
2010-05-06 14:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/011eb1eea4ca25a11d81a356f294a43581309424 [^]
2010-05-06 14:37harikrishnanNote Added: 0026988
2010-05-14 12:42arunkumarNote Added: 0027241
2010-05-14 12:42arunkumarStatusresolved => closed
2010-05-15 00:00anonymoussf_bug_id0 => 3001861
2010-05-18 21:43hudsonbotCheckin
2010-05-18 21:43hudsonbotNote Added: 0027486

Notes
(0026986)
hgbot   
2010-05-06 14:37   
Repository: erp/devel/pi
Changeset: 011eb1eea4ca25a11d81a356f294a43581309424
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu May 06 18:06:33 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/011eb1eea4ca25a11d81a356f294a43581309424 [^]

Fixes issue 13225: When completing or processing documents the updatedby column is not updated properly.

---
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
M src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml
M src-db/database/model/functions/M_INVENTORY_LISTUPDATE.xml
M src-db/database/model/functions/M_INVENTORY_POST.xml
M src-db/database/model/functions/M_MOVEMENT_POST.xml
M src-db/database/model/functions/M_PRODUCTION_RUN.xml
---
(0026988)
harikrishnan   
2010-05-06 14:37   
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:
Their is no impact other then these files.
(0027241)
arunkumar   
2010-05-14 12:42   
Tested Working fine
(0027486)
hudsonbot   
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/011eb1eea4ca [^]
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 [^]