Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010810 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2009-09-29 12:17 | 2009-11-19 00:00 | |||
| Reporter | gorkaion | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 50d12d21ba09 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP9 | |||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.5.0_15 | |||
| OS Version | Gentoo | Database version | 11g | Ant version | 1.7.0 | |||
| Product Version | 2.50MP1 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010810: Duplicate lines in remittance file when a partner has deactivated accounts | |||||||
| Description | When a business partner has one active bank account and several deactivated accounts the BANK.DAT file is generated with duplicate lines. There is a check that covers the existence of more than one active bank account for a business partner. But the query that retrieves the lines doesn't filter by the active flag. | |||||||
| Steps To Reproduce | In Master Data Management || Business Partner || Business Partner >> Bank Account Take a business partner and set 2 bank accounts, one active and one not active. Create a remittance containing a payment of that Business Partner (the payment can be generated through an invoice). Create the file. Notice that the payment appears twice once per each bank account. Go back to the partner and activate both accounts. Try to create the file again, a message indicating that the partner has 2 accounts appear. | |||||||
| Proposed Solution | Modify the selectLineas method of CreateFile34_data.xsql file so the c_bp_bankaccount table is filtered by isActive='Y' | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0020453) rafaroda (viewer) 2009-09-29 13:56 |
Please specify a product verion. Thanks. |
|
(0021624) dmitry_mezentsev (viewer) 2009-11-06 10:13 |
Eduardo, This is the issue we discussed (expiring in 5 days). |
|
(0021675) hgbot (developer) 2009-11-10 10:57 |
Repository: erp/devel/pi Changeset: 6cdff471ba6421f093deb74c933186238d325c59 Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Fri Nov 06 13:05:22 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/6cdff471ba6421f093deb74c933186238d325c59 [^] Fixes bug 0010810: Duplicate lines in remittance... --- M src/org/openbravo/erpCommon/ad_actionButton/CreateFile34_data.xsql M src/org/openbravo/erpCommon/ad_actionButton/CreateFile_data.xsql --- |
|
(0021678) hgbot (developer) 2009-11-10 11:43 |
Repository: erp/devel/pi Changeset: 50d12d21ba0978f11600783a11b9cdfb04dea5ec Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Tue Nov 10 11:41:25 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/50d12d21ba0978f11600783a11b9cdfb04dea5ec [^] Fixes bug 0010810: Duplicate lines in remittance... --- M src/org/openbravo/erpCommon/ad_actionButton/CreateFile34_data.xsql --- |
|
(0021712) sureshbabu (viewer) 2009-11-11 10:45 |
Hi Edu, I retested the issue as per the description, As per the proposed solution, the Active flag filter is rightly applied while generating the file, but when i tried to create a file with two or more active bank accounts for a business partner, the error message appears in the dialog box and then the dialog box with error message disappears(closed) automatically with out any button click. |
|
(0021861) dmitry_mezentsev (viewer) 2009-11-16 15:35 |
Hi Eduardo, Could you please clean this one to finally close it? Thanks. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-09-29 12:17 | gorkaion | New Issue | |
| 2009-09-29 12:17 | gorkaion | Assigned To | => rafaroda |
| 2009-09-29 12:17 | gorkaion | OBNetwork customer | => Yes |
| 2009-09-29 13:56 | rafaroda | Note Added: 0020453 | |
| 2009-09-29 13:56 | rafaroda | Status | new => feedback |
| 2009-09-29 14:05 | gorkaion | Status | feedback => new |
| 2009-09-29 14:05 | gorkaion | version | => 2.50MP1 |
| 2009-09-29 14:06 | rafaroda | Assigned To | rafaroda => dalsasua |
| 2009-09-29 14:06 | rafaroda | Priority | immediate => urgent |
| 2009-09-29 14:06 | rafaroda | Status | new => scheduled |
| 2009-10-27 12:21 | networkb | Target Version | 2.50MP8 => 2.50MP9 |
| 2009-11-06 10:13 | dmitry_mezentsev | Note Added: 0021624 | |
| 2009-11-06 10:14 | dmitry_mezentsev | Assigned To | dalsasua => eduardo_Argal |
| 2009-11-10 10:57 | hgbot | Checkin | |
| 2009-11-10 10:57 | hgbot | Note Added: 0021675 | |
| 2009-11-10 10:57 | hgbot | Status | scheduled => resolved |
| 2009-11-10 10:57 | hgbot | Resolution | open => fixed |
| 2009-11-10 10:57 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/6cdff471ba6421f093deb74c933186238d325c59 [^] |
| 2009-11-10 11:43 | hgbot | Checkin | |
| 2009-11-10 11:43 | hgbot | Note Added: 0021678 | |
| 2009-11-10 11:43 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/6cdff471ba6421f093deb74c933186238d325c59 [^] => http://code.openbravo.com/erp/devel/pi/rev/50d12d21ba0978f11600783a11b9cdfb04dea5ec [^] |
| 2009-11-11 10:45 | sureshbabu | Status | resolved => new |
| 2009-11-11 10:45 | sureshbabu | Resolution | fixed => open |
| 2009-11-11 10:45 | sureshbabu | Note Added: 0021712 | |
| 2009-11-16 11:27 | rafaroda | Status | new => scheduled |
| 2009-11-16 11:27 | rafaroda | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/50d12d21ba0978f11600783a11b9cdfb04dea5ec [^] => |
| 2009-11-16 15:35 | dmitry_mezentsev | Note Added: 0021861 | |
| 2009-11-18 09:56 | eduardo_Argal | Status | scheduled => resolved |
| 2009-11-18 09:56 | eduardo_Argal | Fixed in SCM revision | => 50d12d21ba09 |
| 2009-11-18 09:56 | eduardo_Argal | Resolution | open => fixed |
| 2009-11-18 09:57 | eduardo_Argal | Status | resolved => closed |
| 2009-11-19 00:00 | anonymous | sf_bug_id | 0 => 2900147 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |