Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0013228Openbravo ERP09. Financial managementpublic2010-05-05 10:592010-05-18 21:44
harikrishnan 
adrianromero 
normalmajorhave not tried
closedfixed 
5
pi 
pi 
Core
No
0013228: When completing or processing documents the updatedby column is not updated properly
These are the places where the audit fields are not properly updated.

1.Payment Status Management
2.Open/Close Period Control
3.Amortization
-Create a document with one user
Process or complete with other user
See that the updatedby is not properly updated.
No tags attached.
depends on backport 0013254pi closed harikrishnan When completing or processing documents the updatedby column is not updated properly 
Issue History
2010-05-05 10:59harikrishnanNew Issue
2010-05-05 10:59harikrishnanAssigned To => dalsasua
2010-05-07 08:45harikrishnanStatusnew => scheduled
2010-05-07 08:45harikrishnanAssigned Todalsasua => adrianromero
2010-05-07 08:45harikrishnanfix_in_branch => pi
2010-05-07 08:55hgbotCheckin
2010-05-07 08:55hgbotNote Added: 0027025
2010-05-07 08:55hgbotStatusscheduled => resolved
2010-05-07 08:55hgbotResolutionopen => fixed
2010-05-07 08:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/af3a9aa426e2d78bf5883ceda3f4340aae27807c [^]
2010-05-07 08:56harikrishnanNote Added: 0027026
2010-05-14 12:01arunkumarNote Added: 0027232
2010-05-14 12:01arunkumarStatusresolved => closed
2010-05-17 00:00anonymoussf_bug_id0 => 3002511
2010-05-18 21:44hudsonbotCheckin
2010-05-18 21:44hudsonbotNote Added: 0027494

Notes
(0027025)
hgbot   
2010-05-07 08:55   
Repository: erp/devel/pi
Changeset: af3a9aa426e2d78bf5883ceda3f4340aae27807c
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri May 07 12:24:44 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/af3a9aa426e2d78bf5883ceda3f4340aae27807c [^]

Fixes Issue 13228: When completing or processing documents the updatedby column is not updated properly.

---
M src-db/database/model/functions/A_AMORTIZATION_PROCESS.xml
M src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml
---
(0027026)
harikrishnan   
2010-05-07 08:56   
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:
The impact other then these files are.
C_BANKSTATEMENT_POST.xml
C_REMITTANCE_POST.xml
(0027232)
arunkumar   
2010-05-14 12:01   
The issue is working fine except one thing.

In Open/Close period control Createdby field is blank. It does not display the user name who created the document. I discussed with the developer. He told that the fix is not done since it breaks API.

The support team is already aware of this.

So I close this issue.
(0027494)
hudsonbot   
2010-05-18 21:44   
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/af3a9aa426e2 [^]
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 [^]