Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008645Openbravo ERP09. Financial managementpublic2009-04-20 15:152009-05-05 00:00
Reportervmromanos 
Assigned Tovinothbabu 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04
Product Versionpi 
Target VersionFixed in Version2.50MP1 
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
Summary0008645: Bank Account selector in Bank report window doesn't work in PostgreSQL
DescriptionThe bank account selector inside the Bank report window doesn't display anything on PostgreSQL when the bank/bank account lacks of one of the following fields:
- Bank (CODEBANK, CODEBRANCH, DIGITCONTROL)
- Bank Account (DIGITCONTROL, CODEACCOUNT)
Steps To Reproduce1- Go to Financial Management || Receivables & Payables || Setup || Bank and create a new bank. Just fill: Name (My bank), Location (UK), BP (Mafalda)
2- Go to Bank Account tab create a new record and just fill: Generic Account (00000000) and check Show generic.
3- Go to Financial Management || Receivables & Payables || Analysis Tools || Bank Report and you'll see the bank account selector doesn't show the created bank account.
Proposed SolutionInside src/org/openbravo/erpCommon/ad_combos/AccountNumberCombo_data.xsql

Change:
SELECT C_BANKACCOUNT_ID AS ID, (C_BANK.NAME || '-' || C_BANK.CODEBANK || '/' || C_BANK.CODEBRANCH || C_BANK.DIGITCONTROL || C_BANKACCOUNT.DIGITCONTROL || C_BANKACCOUNT.CODEACCOUNT ) AS name

by:
SELECT C_BANKACCOUNT_ID AS ID, (C_BANK.NAME || '-' || COALESCE(TO_CHAR(C_BANK.CODEBANK),'') || '/' || COALESCE(TO_CHAR(C_BANK.CODEBRANCH),'') || COALESCE(TO_CHAR(C_BANK.DIGITCONTROL),'') || COALESCE(TO_CHAR(C_BANKACCOUNT.DIGITCONTROL),'') || COALESCE(TO_CHAR(C_BANKACCOUNT.CODEACCOUNT),'') ) AS name
Additional Information
Tags250MP1
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-20 15:15vmromanosNew Issue
2009-04-20 15:15vmromanosAssigned To => rafaroda
2009-04-20 15:15vmromanosRegression testing => No
2009-04-22 20:22psarobePrioritynormal => urgent
2009-04-22 20:22psarobeStatusnew => scheduled
2009-04-23 09:42rafarodaAssigned Torafaroda => sathiyan
2009-04-23 16:04psarobeTag Attached: 250MP1
2009-04-24 11:44sathiyanAssigned Tosathiyan => vinothbabu
2009-04-27 11:26hgbotCheckin
2009-04-27 11:26hgbotNote Added: 0015759
2009-04-27 11:26hgbotStatusscheduled => resolved
2009-04-27 11:26hgbotResolutionopen => fixed
2009-04-27 11:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c0f4dcb7442a2a2f1de048cb5b53480c075fa0a9 [^]
2009-05-04 19:30psarobeStatusresolved => closed
2009-05-05 00:00anonymoussf_bug_id0 => 2786907

Notes
(0015759)
hgbot   
2009-04-27 11:26   
Repository: erp/devel/pi
Changeset: c0f4dcb7442a2a2f1de048cb5b53480c075fa0a9
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Mon Apr 27 14:49:50 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c0f4dcb7442a2a2f1de048cb5b53480c075fa0a9 [^]

Fixes bug 8645 See the bank account in the selector when created bank account.

---
M src/org/openbravo/erpCommon/ad_combos/AccountNumberCombo_data.xsql
---