Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008645 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2009-04-20 15:15 | 2009-05-05 00:00 | |||
| Reporter | vmromanos | View Status | public | |||||
| Assigned To | vinothbabu | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | c0f4dcb7442a | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 8.04 | Database version | 8.3.3 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008645: Bank Account selector in Bank report window doesn't work in PostgreSQL | |||||||
| Description | The 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 Reproduce | 1- 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 Solution | Inside 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 | |||||||
| Tags | 250MP1 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0015759) hgbot (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-20 15:15 | vmromanos | New Issue | |
| 2009-04-20 15:15 | vmromanos | Assigned To | => rafaroda |
| 2009-04-20 15:15 | vmromanos | OBNetwork customer | => No |
| 2009-04-20 15:15 | vmromanos | Regression testing | => No |
| 2009-04-22 20:22 | psarobe | Priority | normal => urgent |
| 2009-04-22 20:22 | psarobe | Status | new => scheduled |
| 2009-04-23 09:42 | rafaroda | Assigned To | rafaroda => sathiyan |
| 2009-04-23 16:04 | psarobe | Tag Attached: 250MP1 | |
| 2009-04-24 11:44 | sathiyan | Assigned To | sathiyan => vinothbabu |
| 2009-04-27 11:26 | hgbot | Checkin | |
| 2009-04-27 11:26 | hgbot | Note Added: 0015759 | |
| 2009-04-27 11:26 | hgbot | Status | scheduled => resolved |
| 2009-04-27 11:26 | hgbot | Resolution | open => fixed |
| 2009-04-27 11:26 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c0f4dcb7442a2a2f1de048cb5b53480c075fa0a9 [^] |
| 2009-05-04 19:30 | psarobe | Status | resolved => closed |
| 2009-05-05 00:00 | anonymous | sf_bug_id | 0 => 2786907 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |