Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018248Openbravo ERP00. Application dictionarypublic2011-06-27 16:562011-08-12 13:47
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
Summary0018248: 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
blocks defect 0017794 closed mirurita Option values duplicates at combo table in GL Posting by DB and Reset Accounting transactions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-08-11 08:41miruritaTypedefect => backport
2011-08-11 08:41miruritafix_in_branch => 2.50
2011-08-11 13:00hgbotCheckin
2011-08-11 13:00hgbotNote Added: 0040117
2011-08-11 13:00hgbotStatusscheduled => resolved
2011-08-11 13:00hgbotResolutionopen => fixed
2011-08-11 13:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/12dc3bbd652a136cfaf24fd363194716d9d5c676 [^]
2011-08-12 13:47maiteNote Added: 0040166
2011-08-12 13:47maiteStatusresolved => closed

Notes
(0040117)
hgbot   
2011-08-11 13:00   
Repository: erp/stable/2.50
Changeset: 12dc3bbd652a136cfaf24fd363194716d9d5c676
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Aug 11 12:59:13 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/12dc3bbd652a136cfaf24fd363194716d9d5c676 [^]

Fixes issue 18248: 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
---
(0040166)
maite   
2011-08-12 13:47   
verified