Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031551Openbravo ERP01. General setuppublic2015-11-20 14:492016-01-08 14:23
Reporterngarcia 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031551: Cannot create a product if the same general ledger is assigned to different organizations by different users
DescriptionCannot create a product if the same general ledger is assigned to different organizations by different users. The problem is not always reproducible as it depends on the order of the Cur_Defaults query in the m_product_trg trigger
Steps To ReproduceAs group admin role:
   Create a user and assign the F&B International Group Admin role
Log in with that user
   Assign the F&B International Group US/A/US Dollar to F&B US, Inc. organization
Through database check the query in the trigger returns 3 records
Launch the same query without the a.createdby and a.updatedby columns and check only two records are shown
   If the two records with same values in all the columns except in that two columns are not subsequent, the following error is shown when creating a product at * level:

   "There is already a Product Accounting with the same (General Ledger, Product). (General Ledger, Product) must be unique. You must change the values entered."
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-11-20 14:49ngarciaNew Issue
2015-11-20 14:49ngarciaAssigned To => Triage Finance
2015-11-20 14:49ngarciaModules => Core
2015-11-20 14:49ngarciaTriggers an Emergency Pack => No
2015-11-20 14:51ngarciaResolution time => 1451602800
2015-11-20 14:51ngarciaIssue Monitored: networkb
2015-11-24 17:21psanjuanNote Added: 0082303
2015-11-25 11:50dmiguelezStatusnew => scheduled
2015-11-25 16:12hgbotCheckin
2015-11-25 16:12hgbotNote Added: 0082341
2015-11-25 16:12hgbotStatusscheduled => resolved
2015-11-25 16:12hgbotResolutionopen => fixed
2015-11-25 16:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/49418524d9af266daa9fa6e4da69ed10c8959a9d [^]
2015-11-25 16:14dmiguelezReview Assigned To => dmiguelez
2015-11-25 16:14dmiguelezNote Added: 0082344
2015-11-25 16:14dmiguelezStatusresolved => closed
2015-11-26 00:59hudsonbotCheckin
2015-11-26 00:59hudsonbotNote Added: 0082355
2016-01-08 14:23aferrazAssigned ToTriage Finance => markmm82

Notes
(0082303)
psanjuan   
2015-11-24 17:21   
As group admin role:
   Create a user and assign the F&B International Group Admin role
Log in with that user
   Assign the F&B International Group US/A/US Dollar to F&B US, Inc. organization
You can check:
   Through database check the query in the trigger returns the 2 expected records. The a.createdby, a.updatedby columns were removed and duplicated results avoided.
(0082341)
hgbot   
2015-11-25 16:12   
Repository: erp/devel/pi
Changeset: 49418524d9af266daa9fa6e4da69ed10c8959a9d
Author: Mark <markmm82 <at> gmail.com>
Date: Tue Nov 24 18:38:19 2015 +0000
URL: http://code.openbravo.com/erp/devel/pi/rev/49418524d9af266daa9fa6e4da69ed10c8959a9d [^]

Fixes issue 31551:
Removed the a.createdby and
a.updatedby fields from the
Cur_Defaults query in the
m_product_trg trigger.

---
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
---
(0082344)
dmiguelez   
2015-11-25 16:14   
Code Review + Testing Ok
(0082355)
hudsonbot   
2015-11-26 00:59   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/47856dce24b9 [^]
Maturity status: Test