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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013024
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 02. Master data managementmajoralways2010-04-16 15:362010-05-25 08:53
ReporteradrianromeroView Statuspublic 
Assigned Toharikrishnan 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisioncaba3026a4c2
ProjectionnoneETAnoneTarget Version2.40MP13
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP12SCM revision 
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
Summary

0013024: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate backport 00130222.40MP13 closeddalsasua When you process a cash journal the database is not updated properly 
has duplicate backport 00130542.40MP13 closedadrianromero The create shipment from order process does not fill well the audit fields. 
blocks defect 00130232.40MP13 closedharikrishnan When completing or processing documents the updatedby column is not updated properly 

-  Notes
(0026903)
hgbot (developer)
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 (viewer)
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 (viewer)
2010-05-25 08:53

 Tested working fine

- Issue History
Date Modified Username Field Change
2010-04-16 15:36 adrianromero New Issue
2010-04-16 15:36 adrianromero Assigned To => adrianromero
2010-04-16 15:36 adrianromero OBNetwork customer => No
2010-04-16 15:36 adrianromero Issue generated from 0013023
2010-04-16 15:36 adrianromero Relationship added blocks 0013023
2010-04-16 15:37 adrianromero Status new => scheduled
2010-04-16 15:37 adrianromero fix_in_branch => pi
2010-04-16 15:38 adrianromero Relationship added has duplicate 0013022
2010-04-19 12:55 networkb Relationship added related to 0013031
2010-04-20 09:57 adrianromero Relationship deleted related to 0013031
2010-05-04 11:31 harikrishnan Assigned To adrianromero => harikrishnan
2010-05-04 11:42 hgbot Checkin
2010-05-04 11:42 hgbot Note Added: 0026903
2010-05-04 11:42 hgbot Status scheduled => resolved
2010-05-04 11:42 hgbot Resolution open => fixed
2010-05-04 11:42 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/caba3026a4c25bd2068d517266ec514098c6a5b8 [^]
2010-05-04 11:44 harikrishnan Note Added: 0026906
2010-05-04 12:40 adrianromero Relationship added has duplicate 0013054
2010-05-25 08:53 arunkumar Note Added: 0027695
2010-05-25 08:53 arunkumar Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker