Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0031551 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | always | 2015-11-20 14:49 | 2016-01-08 14:23 | |||
| Reporter | ngarcia | View Status | public | |||||
| Assigned To | markmm82 | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 49418524d9af | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | dmiguelez | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0031551: Cannot create a product if the same general ledger is assigned to different organizations by different users | |||||||
| Description | Cannot 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 Reproduce | 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 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." | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0082303) psanjuan (manager) 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 (developer) 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 (developer) 2015-11-25 16:14 |
Code Review + Testing Ok |
|
(0082355) hudsonbot (developer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-11-20 14:49 | ngarcia | New Issue | |
| 2015-11-20 14:49 | ngarcia | Assigned To | => Triage Finance |
| 2015-11-20 14:49 | ngarcia | Modules | => Core |
| 2015-11-20 14:49 | ngarcia | Triggers an Emergency Pack | => No |
| 2015-11-20 14:51 | ngarcia | Resolution time | => 1451602800 |
| 2015-11-20 14:51 | ngarcia | Issue Monitored: networkb | |
| 2015-11-24 17:21 | psanjuan | Note Added: 0082303 | |
| 2015-11-25 11:50 | dmiguelez | Status | new => scheduled |
| 2015-11-25 16:12 | hgbot | Checkin | |
| 2015-11-25 16:12 | hgbot | Note Added: 0082341 | |
| 2015-11-25 16:12 | hgbot | Status | scheduled => resolved |
| 2015-11-25 16:12 | hgbot | Resolution | open => fixed |
| 2015-11-25 16:12 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/49418524d9af266daa9fa6e4da69ed10c8959a9d [^] |
| 2015-11-25 16:14 | dmiguelez | Review Assigned To | => dmiguelez |
| 2015-11-25 16:14 | dmiguelez | Note Added: 0082344 | |
| 2015-11-25 16:14 | dmiguelez | Status | resolved => closed |
| 2015-11-26 00:59 | hudsonbot | Checkin | |
| 2015-11-26 00:59 | hudsonbot | Note Added: 0082355 | |
| 2016-01-08 14:23 | aferraz | Assigned To | Triage Finance => markmm82 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |