Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013024Openbravo ERP02. Master data managementpublic2010-04-16 15:362010-05-25 08:53
Reporteradrianromero 
Assigned Toharikrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP12 
Target Version2.40MP13Fixed 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
Summary0013024: When completing or processing documents the updatedby column is not updated properly
Description When you completing or processing documents the updatedby columns is not updated properly.

We have identify this problem on the following documents:

-Requisition
-Manage requisition
-Goods receipt/shipment
-Goods movement
-manual settlement
-Cash journal (bug reported: 0013021)
-Invoice (bug fixed: 0012520)
-Bank statement


Steps To Reproduce-Create a document with one user
-Process or complete with other user
See that the updatedby is not properly updated.
Proposed SolutionAll the documents should be reviewed because the could be an horizontal problem
that affect other documents.
Additional Information
TagsNo tags attached.
Relationships
has duplicate backport 00130222.40MP13 closed dalsasua When you process a cash journal the database is not updated properly 
has duplicate backport 00130542.40MP13 closed adrianromero The create shipment from order process does not fill well the audit fields. 
blocks defect 00130232.40MP13 closed harikrishnan When completing or processing documents the updatedby column is not updated properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-16 15:36adrianromeroNew Issue
2010-04-16 15:36adrianromeroAssigned To => adrianromero
2010-04-16 15:36adrianromeroOBNetwork customer => No
2010-04-16 15:36adrianromeroIssue generated from0013023
2010-04-16 15:36adrianromeroRelationship addedblocks 0013023
2010-04-16 15:37adrianromeroStatusnew => scheduled
2010-04-16 15:37adrianromerofix_in_branch => pi
2010-04-16 15:38adrianromeroRelationship addedhas duplicate 0013022
2010-04-19 12:55networkbRelationship addedrelated to 0013031
2010-04-20 09:57adrianromeroRelationship deletedrelated to 0013031
2010-05-04 11:31harikrishnanAssigned Toadrianromero => harikrishnan
2010-05-04 11:42hgbotCheckin
2010-05-04 11:42hgbotNote Added: 0026903
2010-05-04 11:42hgbotStatusscheduled => resolved
2010-05-04 11:42hgbotResolutionopen => fixed
2010-05-04 11:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/caba3026a4c25bd2068d517266ec514098c6a5b8 [^]
2010-05-04 11:44harikrishnanNote Added: 0026906
2010-05-04 12:40adrianromeroRelationship addedhas duplicate 0013054
2010-05-25 08:53arunkumarNote Added: 0027695
2010-05-25 08:53arunkumarStatusresolved => closed

Notes
(0026903)
hgbot   
2010-05-04 11:42   
Repository: erp/stable/2.40
Changeset: caba3026a4c25bd2068d517266ec514098c6a5b8
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue May 04 15:11:08 2010 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/caba3026a4c25bd2068d517266ec514098c6a5b8 [^]

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

---
M src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
M src-db/database/model/functions/C_CASH_POST.xml
M src-db/database/model/functions/C_SETTLEMENT_POST.xml
M src-db/database/model/functions/M_INOUT_CREATE.xml
M src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml
M src-db/database/model/functions/M_INOUT_POST.xml
M src-db/database/model/functions/M_REQUISITIONLINE_STATUS.xml
M src-db/database/model/functions/M_REQUISITION_CREATEPO.xml
M src-db/database/model/functions/M_REQUISITION_POST.xml
---
(0026906)
harikrishnan   
2010-05-04 11:44   
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.
    1.C_INVOICE_POST.xml
    2.C_DEBT_PAYMENT_CREATE.xml
    3.C_DP_MANAGEMENT_POST.xml
    4.C_PAYINADVANCE_CREATE.xml
    5.C_REMITTANCE_POST.xml
    6.C_TAXPAYMENT_POST.xml
    7.C_INVOICE_CREATERECEIPT.xml
    8.C_ORDER_POST1.xml
    9.M_INOUT_CREATE.xml
    10.M_INOUT_CREATEINVOICE.xml
    11.M_REQUISITION_CREATEPO.xml
    12.M_REQUISITION_POST
    13.M_REQUISITIONLINE_STATUS.xml
(0027695)
arunkumar   
2010-05-25 08:53   
Tested working fine