Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0019291 | Openbravo ERP | 08. Project and service management | public | 2011-12-13 13:10 | 2012-09-18 13:59 |
| Reporter | VictorVillar | ||||
| Assigned To | dmiguelez | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | out of date | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | 3.0MP6 | ||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0019291: Collected field on Project Profitability Report is not recording payments made with APR flow | ||||
| Description | Collected field on Project Profitability Report is not recording payments made with APR flow. It sums only from C_DEBT_PAYMENT but not from FIN_PAYMENT table. | ||||
| Steps To Reproduce | We can see in ReportProjectProfitability_data.xsql in the subquery DDD line 177 where calculates the sum of the Collected field. it calls a function C_INVOICE_PERCENTAGE_PAID.xml: SELECT SUM(C_DB_PERCENTAGE_PAID(DB.C_Debt_Payment_ID)* C_Currency_Convert(DB.amount,DB.C_Currency_ID,I.C_Currency_ID, now(), null, I.AD_Client_ID, I.AD_Org_ID))/ (CASE SUM(C_Currency_Convert(DB.amount,DB.C_Currency_ID,I.C_Currency_ID, now(), null, I.AD_Client_ID, I.AD_Org_ID)) WHEN 0 THEN to_number(NULL) ELSE SUM(C_Currency_Convert(DB.amount,DB.C_Currency_ID,I.C_Currency_ID, now(), null, I.AD_Client_ID, I.AD_Org_ID)) END) INTO v_percentaje FROM C_DEBT_PAYMENT DB, C_Invoice I WHERE DB.C_Invoice_ID = I.C_Invoice_ID AND I.C_INVOICE_ID = p_Invoice_ID; RETURN ROUND(v_percentaje,4); END C_INVOICE_PERCENTAGE_PAID We realise that only it takes into account the old flow. | ||||
| Proposed Solution | It is necessary to add the sum from the FIN_PAYMENT table to the current one. The result is the sum from APR flow and the old one | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2011-12-13 13:10 | VictorVillar | New Issue | |||
| 2011-12-13 13:10 | VictorVillar | Assigned To | => jonalegriaesarte | ||
| 2011-12-13 13:10 | VictorVillar | Modules | => Core | ||
| 2011-12-13 13:10 | VictorVillar | Resolution time | => 1328655600 | ||
| 2011-12-13 13:15 | RenateNieuwkoop | Issue Monitored: RenateNieuwkoop | |||
| 2012-01-24 13:42 | jonalegriaesarte | Type | defect => design defect | ||
| 2012-01-30 17:18 | jonalegriaesarte | Target Version | 3.0MP8 => 3.0MP9 | ||
| 2012-03-02 12:56 | jonalegriaesarte | Target Version | 3.0MP9 => 3.0MP10 | ||
| 2012-03-29 16:11 | jonalegriaesarte | Target Version | 3.0MP10 => | ||
| 2012-09-13 10:42 | jonalegriaesarte | Assigned To | jonalegriaesarte => dmiguelez | ||
| 2012-09-18 13:59 | dmiguelez | Note Added: 0052203 | |||
| 2012-09-18 13:59 | dmiguelez | Status | new => closed | ||
| 2012-09-18 13:59 | dmiguelez | Resolution | open => out of date | ||
| Notes | |||||
|
|
|||||
|
|
||||