Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022550Openbravo ERP09. Financial managementpublic2012-12-13 05:222013-02-27 03:10
Reporterpjuvara 
Assigned Topramakrishnan 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version3.0MP17 
Target VersionFixed in Version 
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
Summary0022550: Cannot modify product on g/l item transaction in financial account
DescriptionThe Modify button on the Financial Account screen allows you to modify the accounting dimensions of a non posted transaction.

It works for all dimensions except for product.
Steps To Reproduce1) Navigate to Financial Account window
2) Choose an account and press Add Transaction
3) Choose a G/L item transaction and add it.
4) Press Modify
5) In the pop up window, choose a product and save.
You get an error.
Proposed Solutiondiff -r 6643d4586bf2 -r d03355d4b833 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml Thu Jan 10 20:30:34 2013 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml Fri Jan 11 16:11:36 2013 +0530
@@ -123,7 +123,7 @@
 <!--8BEBA07E78124B2B92B764D9B452B209--> <FIELDLENGTH><![CDATA[100]]></FIELDLENGTH>
 <!--8BEBA07E78124B2B92B764D9B452B209--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--8BEBA07E78124B2B92B764D9B452B209--> <ISRANGE><![CDATA[N]]></ISRANGE>
-<!--8BEBA07E78124B2B92B764D9B452B209--> <DEFAULTVALUE><![CDATA[@SQL=SELECT name FROM C_GLItem WHERE C_GLItem_ID=@C_GLItem_ID@]]></DEFAULTVALUE>
+<!--8BEBA07E78124B2B92B764D9B452B209--> <DEFAULTVALUE><![CDATA[@C_GLItem_ID@]]></DEFAULTVALUE>
 <!--8BEBA07E78124B2B92B764D9B452B209--> <AD_ELEMENT_ID><![CDATA[800080]]></AD_ELEMENT_ID>
 <!--8BEBA07E78124B2B92B764D9B452B209--></AD_PROCESS_PARA>
Additional Information
TagsNo tags attached.
Relationships
depends on defect 00228013.0MP20 closed AugustoMauch ID shown when writing the whole name in Product selector 
depends on defect 00227023.0MP22 closed dmiguelez Error when trying to Modify transaction 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-12-13 05:22pjuvaraNew Issue
2012-12-13 05:22pjuvaraAssigned To => dmiguelez
2012-12-13 05:22pjuvaraModules => Core
2012-12-13 05:22pjuvaraOBNetwork customer => No
2012-12-13 05:22pjuvaraTriggers an Emergency Pack => No
2012-12-23 01:13pjuvaraNote Added: 0055160
2013-01-04 10:04pramakrishnanAssigned Todmiguelez => pramakrishnan
2013-01-10 07:26pramakrishnanNote Added: 0055442
2013-01-10 07:27pramakrishnanStatusnew => scheduled
2013-01-10 07:27pramakrishnanfix_in_branch => pi
2013-01-15 13:19dmiguelezfix_in_branchpi =>
2013-01-15 13:19dmiguelezProposed Solution updated
2013-01-15 13:20dmiguelezNote Added: 0055517
2013-01-15 13:20dmiguelezRelationship addeddepends on 0022801
2013-02-24 00:58pjuvaraNote Added: 0056736
2013-02-26 11:27eduardo_ArgalRelationship addeddepends on 0022702
2013-02-26 11:44dmiguelezNote Added: 0056764
2013-02-26 11:44dmiguelezStatusscheduled => closed
2013-02-26 11:44dmiguelezResolutionopen => no change required
2013-02-27 03:10pjuvaraNote Added: 0056796

Notes
(0055160)
pjuvara   
2012-12-23 01:13   
The issue is not related only to product but to all dimensions.
(0055442)
pramakrishnan   
2013-01-10 07:26   
Test Plan:
Login as Openbravo/openbravo
Navigate to Financial Account window
Choose an account and press Add Transaction
Choose a G/L item transaction and add it.
Press Modify
In the pop up window, modify any dimension and click ok
Notice that the transaction is modified without any errors
(0055517)
dmiguelez   
2013-01-15 13:20   
There is an Issue that is preventing the proposed solution to work as expected.
With the proposed fix, it is showing the record Id instead of it's identifier.
When the related Issue is fixed, the proposed solution would work correctly.

https://issues.openbravo.com/view.php?id=22801 [^]
(0056736)
pjuvara   
2013-02-24 00:58   
Underlying issue is now fixed. Can this defect be progressed?
(0056764)
dmiguelez   
2013-02-26 11:44   
There is an underlying Issue with the selectors. When this Issue is fixed, it will work properly.

There is a workaround to avoid that Issue. Select a different GL Item first, and then select the previous one again. The Issue is related with the first data load of the pop up and this way it can be avoided.

After that, a Product can be selected and it won't rise an error.
(0056796)
pjuvara   
2013-02-27 03:10   
Thanks for the workaround