Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013230Openbravo ERP03. Procurement managementpublic2010-05-05 10:242010-05-25 09:06
Reporterharikrishnan 
Assigned Toharikrishnan 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013230: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0013224pi closed harikrishnan When completing or processing documents the updatedby column is not updated properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-05-05 14:06arunkumarTypedefect => backport
2010-05-05 14:06arunkumarfix_in_branch => 2.40
2010-05-06 10:21harikrishnanAssigned Toadrianromero => harikrishnan
2010-05-06 10:40hgbotCheckin
2010-05-06 10:40hgbotNote Added: 0026974
2010-05-06 10:40hgbotStatusscheduled => resolved
2010-05-06 10:40hgbotResolutionopen => fixed
2010-05-06 10:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/2ee15a4f333e343df4b1aa4da8f0c8faed56138a [^]
2010-05-06 10:41harikrishnanNote Added: 0026975
2010-05-25 09:06arunkumarNote Added: 0027696
2010-05-25 09:06arunkumarStatusresolved => closed

Notes
(0026974)
hgbot   
2010-05-06 10:40   
Repository: erp/stable/2.40
Changeset: 2ee15a4f333e343df4b1aa4da8f0c8faed56138a
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu May 06 14:02:28 2010 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/2ee15a4f333e343df4b1aa4da8f0c8faed56138a [^]

Fixes issue 13230: 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
---
(0026975)
harikrishnan   
2010-05-06 10:41   
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
(0027696)
arunkumar   
2010-05-25 09:06   
Tested working fine