Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0002930 | Openbravo ERP | 09. Financial management | public | 2008-04-23 10:44 | 2008-06-18 19:28 |
| Reporter | user71 | ||||
| Assigned To | dalsasua | ||||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | 2.40 | Fixed in Version | 2.40 | ||
| 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 | 0002930: GeneralAccountingReport -> Revenues - Expenses mismatch | ||||
| Description | The GeneralAccountingReport shows a mismatch in the Revenues-Expenses amount due to a bug in the selectPyG statement. The statement has a subselect that returns repeated values: SELECT ACCOUNT_ID FROM C_ELEMENTVALUE, C_VALIDCOMBINATION WHERE C_VALIDCOMBINATION.ACCOUNT_ID = C_ELEMENTVALUE.C_ELEMENTVALUE_ID AND C_ELEMENTVALUE.ACCOUNTTYPE = ?) This makes the overall of the whole amount different that it should be. I thin the statement should be like it follows: SELECT DISTINCT ACCOUNT_ID FROM C_ELEMENTVALUE, C_VALIDCOMBINATION WHERE C_VALIDCOMBINATION.ACCOUNT_ID = C_ELEMENTVALUE.C_ELEMENTVALUE_ID AND C_ELEMENTVALUE.ACCOUNTTYPE = ?) Cheers | ||||
| Steps To Reproduce | |||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2008-06-13 18:33 | psarobe | Priority | normal => high | ||
| 2008-06-13 18:33 | psarobe | Severity | minor => major | ||
| 2008-06-13 18:33 | psarobe | Description Updated | |||
| 2008-06-13 18:34 | psarobe | Status | new => scheduled | ||
| 2008-06-13 19:59 | cromero | Target Version | => 2.40 | ||
| 2008-06-18 19:28 | eduardo_Argal | Status | scheduled => closed | ||
| 2008-06-18 19:28 | eduardo_Argal | Note Added: 0007845 | |||
| 2008-06-18 19:28 | eduardo_Argal | Resolution | open => fixed | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||