Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008606 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2009-04-16 18:31 | 2009-05-05 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 06150656664d | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP3 | 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 | 0008606: In the cash Journal lines, when you have many lines selected with the mouse over the amount header the status bar shows 0 | |||||||
| Description | In the cash Journal lines, in the grid, when you have many lines selected with the mouse over the amount header the status bar shows 0, when it should show the total amount of the lines selected. This works properly in other windows, if the firefox is correctly configured. In about:config window the "dom.disable_window_status_change" preference has to befalse | |||||||
| Steps To Reproduce | -Go to the cash journal window -go to the lines tab. -Go to relation view. -Select some lines. -Put the mouse over the amount header. -In the status bar the amount showed is 0 and should be the total amount selected. *Notice that | |||||||
| Tags | 250MP1 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0015587) dbaz (viewer) 2009-04-23 00:54 |
It seems to be a problem with the SQL that should return the sum. For example with "pi" current sampledata, if we go to the lines of the Cash Book which name is "2006-03-31 EUR" we see that there is only one line which description is "Edison Energy Company" and amount "-634.81". If the hover over the "Amount" column we obtain the correct result. The SQL that is executed in the server is SELECT SUM(Amount) AS TOTAL FROM C_CashLine left join (SELECT C_Cash_ID, Name FROM C_Cash) td0 on C_CashLine.C_Cash_ID = td0.C_Cash_ID left join (select IsActive, ad_ref_list_id, ad_reference_id, value, name from ad_ref_list) td1 on C_CashLine.CashType = td1.value AND td1.ad_reference_id = '217' left join (SELECT ad_language, name, ad_ref_list_id from ad_ref_list_trl) td_trl1 on td1.ad_ref_list_id = td_trl1.ad_ref_list_id AND td_trl1.ad_language = 'en_US' left join (SELECT C_Glitem_ID, Name FROM C_Glitem) td2 on C_CashLine.C_Glitem_ID = td2.C_Glitem_ID left join (SELECT C_Currency_ID, ISO_Code FROM C_Currency) td3 on C_CashLine.C_Currency_ID = td3.C_Currency_ID left join (SELECT C_Debt_Payment_ID, C_BPartner_ID, PaymentRule, Dateplanned, Amount, IsReceipt FROM C_Debt_Payment) td4 on C_CashLine.C_Debt_Payment_ID = td4.C_Debt_Payment_ID left join (SELECT C_BPartner_ID, Name FROM C_BPartner) td5 on td4.C_BPartner_ID= td5.C_BPartner_ID left join (select IsActive, ad_ref_list_id, ad_reference_id, value, name from ad_ref_list) td6 on td4.PaymentRule = td6.value AND td6.ad_reference_id = '195' left join (SELECT ad_language, name, ad_ref_list_id from ad_ref_list_trl) td_trl6 on td6.ad_ref_list_id = td_trl6.ad_ref_list_id AND td_trl6.ad_language = 'en_US' left join (SELECT C_Order_ID, DocumentNo, DateOrdered, GrandTotal FROM C_Order)td7 on C_CashLine.C_Order_ID = td7.C_Order_ID WHERE (C_CashLine.C_CashLine_ID) IN (SELECT C_CashLine_ID FROM C_CashLine WHERE C_CashLine.AD_Client_ID IN ('0','1000000') AND C_CashLine.AD_Org_ID IN ('0','1000000','1000002','1000003','1000004','1000005','1000006','1000008','1000009','1000007') AND C_CashLine.C_Cash_ID = '1000000' AND C_CashLine.C_CashLine_ID IN ('1000000') ) if we add more lines, the SQL to obtain the sum of "Amount" will be the same but changing the last row AND C_CashLine.C_CashLine_ID IN ('1000000') and instead of 1000000 the UUID generated for the new value. (or an array of IDs if we select various lines in the grid) With this new SQL the DDBB returns a "null" instead of the right sum. So it is a problem with the SQL |
|
(0015596) alostale (viewer) 2009-04-23 10:03 |
Note that in your example it appears 634.81 instead of -634.81. This happens only in Oracle, in PostgreSQL the SQL directly fails. |
|
(0015597) hgbot (developer) 2009-04-23 10:04 |
Repository: erp/devel/pi Changeset: 06150656664d49b1e2b7ac33e940355f8838cf71 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Apr 23 10:03:39 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/06150656664d49b1e2b7ac33e940355f8838cf71 [^] fixed bug 0008606: In the cash Journal lines, when you have many lines selected with the mouse over the amount header the status bar shows 0 --- M src/org/openbravo/erpCommon/utility/DataGrid.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-16 18:31 | networkb | New Issue | |
| 2009-04-16 18:31 | networkb | Assigned To | => rafaroda |
| 2009-04-16 18:31 | networkb | OBNetwork customer | => Yes |
| 2009-04-16 18:31 | networkb | Regression testing | => No |
| 2009-04-22 10:19 | psarobe | Status | new => scheduled |
| 2009-04-22 10:19 | psarobe | Assigned To | rafaroda => dbaz |
| 2009-04-22 10:19 | psarobe | fix_in_branch | => pi |
| 2009-04-23 00:54 | dbaz | Note Added: 0015587 | |
| 2009-04-23 00:56 | dbaz | Assigned To | dbaz => alostale |
| 2009-04-23 10:03 | alostale | Note Added: 0015596 | |
| 2009-04-23 10:04 | hgbot | Checkin | |
| 2009-04-23 10:04 | hgbot | Note Added: 0015597 | |
| 2009-04-23 10:04 | hgbot | Status | scheduled => resolved |
| 2009-04-23 10:04 | hgbot | Resolution | open => fixed |
| 2009-04-23 10:04 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/06150656664d49b1e2b7ac33e940355f8838cf71 [^] |
| 2009-04-23 18:26 | psarobe | Tag Attached: 250MP1 | |
| 2009-05-04 23:44 | psarobe | Status | resolved => closed |
| 2009-05-05 00:00 | anonymous | sf_bug_id | 0 => 2786905 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |