Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017794Openbravo ERP00. Application dictionarypublic2011-06-27 16:562011-08-16 13:24
Reporterjaime_chamorro 
Assigned Tomirurita 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed 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
Summary0017794: Option values duplicates at combo table in GL Posting by DB and Reset Accounting transactions
DescriptionThere are two transactions with a wrong text in the combo that generates mistakes to the users. The transactions are:
1. Financial Management || Accounting || Transactions || GL Posting by DB Tables || GL Posting by DB Tables
The table combo show the following option values into the source code frame:

<option value="392"><span>Bank Statement</span></option>
<option value="407"><span>Cash Journal</span></option>
<option value="B1B7075C46934F0A9FD4C4D0F1457B42"><span>Financial Account</span></option>
<option value="D4C23A17190649E7B78F55A05AF3438C"><span>Financial Account</span></option>
<option value="224"><span>G/L Journal</span></option>
<option value="319"><span>Goods Receipt - Goods Shipment</span></option>
<option value="800019"><span>Manual Settlement - Settlement</span></option>
<option value="472"><span>Matched Invoices</span></option>
<option value="800176"><span>Payment Status Management</span></option>
<option value="318"><span>Purchase Invoice - Sales Invoice</span></option>
<option value="379F8A7C50E3405E838CE94153025761"><span>Remittance</span></option>
<option value="4E2A33FA8835466BAAA596A17D680E19"><span>Remittance</span></option>
<option value="FF8080812E6C2859012E6D0271E1009D"><span>Remittance</span></option></div></DIV>

As you can check above the financial account description is 2 times and 3 times the Remittance description. However each of these descriptions regards different table.
2. Financial Management || Accounting || Transactions || GL Posting by DB Tables || Reset Accounting
The table combo show the following option values into the source code frame:
<option value="392"><span>Bank Statement</span></option>
<option value="407"><span>Cash Journal</span></option>
<option value="4D8C3B3C31D1410DA046140C9F024D17"><span>Financial Account</span></option>
<option value="D4C23A17190649E7B78F55A05AF3438C"><span>Financial Account</span></option>
<option value="B1B7075C46934F0A9FD4C4D0F1457B42"><span>Financial Account</span></option>
<option value="0DFF5BACFB964FDABAA5042C8809C813"><span>Financial Account</span></option>
<option value="224"><span>G/L Journal</span></option>
<option value="323"><span>Goods Movements</span></option>
<option value="319"><span>Goods Receipt - Goods Shipment</span></option>
<option value="800168"><span>Internal Consumption</span></option>
<option value="B94B519766D2411C8A0784DEE812505C"><span>Invoice List Report</span></option>
<option value="800019"><span>Manual Settlement - Settlement</span></option>
<option value="472"><span>Matched Invoices</span></option>
<option value="473"><span>Matched Purchase Orders</span></option>
<option value="D1A97202E832470285C9B1EB026D54E2"><span>Payment Out - Payment In</span></option>
<option value="800176"><span>Payment Status Management</span></option>
<option value="321"><span>Physical Inventory</span></option>
<option value="318"><span>Purchase Invoice - Sales Invoice</span></option>
<option value="259"><span>Purchase Order - Sales Order</span></option>
<option value="FF8080812E6C2859012E6D0271E1009D"><span>Remittance</span></option>
<option value="379F8A7C50E3405E838CE94153025761"><span>Remittance</span></option>
<option value="4E2A33FA8835466BAAA596A17D680E19"><span>Remittance</span></option>
<option value="623"><span>Service Project (deprecated)</span></option>
<option value="325"><span>Work Effort - Bill of Materials Production</span></option>
<option value="471"><span></span></option></div></DIV>

As you can check above the financial account description is 4 times and 3 times the Remittance description. However each of these descriptions regards different table.
Steps To ReproduceGo to the transactions and check the combo "Table":

1. Financial Management || Accounting || Transactions || GL Posting by DB Tables || GL Posting by DB Tables
2. Financial Management || Accounting || Transactions || GL Posting by DB Tables || Reset Accounting
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0018248 closed mirurita Option values duplicates at combo table in GL Posting by DB and Reset Accounting transactions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-06-27 16:56jaime_chamorroNew Issue
2011-06-27 16:56jaime_chamorroAssigned To => eduardo_Argal
2011-07-04 19:12maiteProjectModules => Openbravo ERP
2011-07-04 19:12maiteModules => Core
2011-07-04 19:12maiteResolution time => 1316383200
2011-07-04 19:12maitePrioritynormal => high
2011-07-04 19:12maiteCategoryAdvance Payables and Receivables - es_ES => 00. Application dictionary
2011-07-04 19:13maitePriorityhigh => urgent
2011-07-04 19:13maiteSeverityminor => major
2011-07-04 19:13maiteResolution time1316383200 => 1312754400
2011-08-09 12:14miruritaAssigned Toeduardo_Argal => mirurita
2011-08-11 08:41miruritaStatusnew => scheduled
2011-08-11 08:41miruritafix_in_branch => pi
2011-08-11 12:07hgbotCheckin
2011-08-11 12:07hgbotNote Added: 0040114
2011-08-11 12:07hgbotStatusscheduled => resolved
2011-08-11 12:07hgbotResolutionopen => fixed
2011-08-11 12:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5e39165ecadfb86081a08cad96ee62e3bb7f1df5 [^]
2011-08-12 09:29maiteNote Added: 0040138
2011-08-12 09:29maiteStatusresolved => closed
2011-08-16 13:24hudsonbotCheckin
2011-08-16 13:24hudsonbotNote Added: 0040222

Notes
(0040114)
hgbot   
2011-08-11 12:07   
Repository: erp/devel/pi
Changeset: 5e39165ecadfb86081a08cad96ee62e3bb7f1df5
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Aug 11 11:57:51 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5e39165ecadfb86081a08cad96ee62e3bb7f1df5 [^]

Fixes issue 17794: combobox values duplicates in GL Posting by DB and Reset Accounting.
Table combo now will show the table name concatenated with (between parentheses) the window (sales/purchase) associated.
If it does not have a window associated it will show ( - )

---
M src-db/database/model/views/AD_TABLE_POST_V.xml
M src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
M src/org/openbravo/erpCommon/ad_forms/CallAcctServer.java
---
(0040138)
maite   
2011-08-12 09:29   
verified
(0040222)
hudsonbot   
2011-08-16 13:24   
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/c1dc221b8cb3 [^]

Maturity status: Test