Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008645 | Openbravo ERP | 09. Financial management | public | 2009-04-20 15:15 | 2009-05-05 00:00 |
| Reporter | vmromanos | ||||
| Assigned To | vinothbabu | ||||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | Ubuntu 8.04 | |
| Product Version | pi | ||||
| Target Version | Fixed in Version | 2.50MP1 | |||
| 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 | ||||
| Additional Information | |||||
| Tags | 250MP1 | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| Notes | |||||
|
|
|||||
|
|
||||