Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012895Openbravo ERP07. Sales managementpublic2010-04-07 13:342010-04-16 17:03
Reporteradrianromero 
Assigned Toharikrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP11 
Target Version2.50MP13Fixed in Version2.50MP15 
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
Summary0012895: When you complete a sales invoice the database is not updated properly
DescriptionAs Openbravo you create a sales invoice. If you complete it as other user, the field 'Updatedby' on DB is not updated.
Steps To Reproduce-As Openbravo Admin go to General Setup || Security || User
-Create a new record:
    -name: User
    -username: User
    -password: user
-Save, go to User Roles and create a new record:
    -Role: Openbravo Admin.
-Save

-Go to Sales Management || Transactions || Sales Invoice
-Create a new invoice with a line.
-Save

-Logout and login with the new user.
-Go to the invoice created and complete it.

-On DB:

select updatedby, updated, createdby, created from c_invoice order by updated desc

-Realize that '100' (Openbravo user) appears on UpdatedBy
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to backport 0012799 closed harikrishnan Generate Invoice process generates multiple invoices 
blocks defect 00125202.40MP13 closed harikrishnan When you complete a sales invoice the database is not updated properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-07 13:34adrianromeroNew Issue
2010-04-07 13:34adrianromeroAssigned To => harikrishnan
2010-04-07 13:34adrianromeroOBNetwork customer => No
2010-04-07 13:34adrianromeroIssue generated from0012520
2010-04-07 13:35adrianromeroTypedefect => backport
2010-04-07 13:35adrianromeroRelationship addedblocks 0012520
2010-04-07 13:40adrianromeroNote Added: 0025935
2010-04-07 13:40adrianromeroNote Added: 0025936
2010-04-07 13:40adrianromeroNote Added: 0025937
2010-04-07 13:40adrianromeroStatusnew => scheduled
2010-04-07 13:40adrianromerofix_in_branch => pi
2010-04-07 13:41adrianromeroStatusscheduled => resolved
2010-04-07 13:41adrianromeroFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/fbc442ff37fdee770faaf2899fc24ef7dae2a4cb [^]
2010-04-07 13:41adrianromeroResolutionopen => fixed
2010-04-07 13:41adrianromeroRelationship addedrelated to 0012799
2010-04-07 13:43adrianromeroNote Added: 0025939
2010-04-16 17:03sureshbabuNote Added: 0026322
2010-04-16 17:03sureshbabuStatusresolved => closed
2010-04-16 17:03sureshbabuFixed in Version => 2.50MP15

Notes
(0025935)
adrianromero   
2010-04-07 13:40   
Repository: erp/stable/2.40
Changeset: fbc442ff37fdee770faaf2899fc24ef7dae2a4cb
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu Mar 18 18:21:07 2010 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/fbc442ff37fdee770faaf2899fc24ef7dae2a4cb [^] [^]

Fixes Issue 12520: When you complete a sales invoice the database is not updated properly

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0025936)
adrianromero   
2010-04-07 13:40   
Repository: erp/stable/2.40
Changeset: 1d4915eb342ea81b1cce168b832112f0e9f0187e
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Mar 23 15:37:26 2010 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/1d4915eb342ea81b1cce168b832112f0e9f0187e [^] [^]

Fixes issue 0012753: Generate Invoice process gives Notnull error
Related to issue 12520 When you complete a sales invoice the database is not updated properly

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0025937)
adrianromero   
2010-04-07 13:40   
Repository: erp/stable/2.40
Changeset: abde598fb3f1eb69d8c226f4f31c3cecc8450965
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Mon Mar 29 15:32:01 2010 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/abde598fb3f1eb69d8c226f4f31c3cecc8450965 [^] [^]

Fixes Issue 12799: Generate Invoice process generates multiple invoices.

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0025939)
adrianromero   
2010-04-07 13:43   
Steps to test

*Login as
Username: Openbravo
Password:openbravo
*Create a new sales invoice but do not complete the invoice.
*Create a new new user and assign openbravoadmin role.
*Logout and Login as new user credentials.
*Complete the above invoice created.
Now if you query the database for the above created invoice, the UpdatedBy field is updated to the new user id.
(0026322)
sureshbabu   
2010-04-16 17:03   
tested working fine