Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009867 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2009-07-13 18:23 | 2009-07-23 00:00 | |||
| Reporter | eduardo_Argal | View Status | public | |||||
| Assigned To | jayakumar | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 13e546b079f4 | ||||
| Projection | none | ETA | none | Target Version | pi | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009867: Asset report; SQL wrongly writen | |||||||
| Description | The SQL for this report is selecting the entry to show like this: AND F.AMTACCTDR<>'0' And should obtain the amount from the AcumDepreciation account. More entries could be there because of subsidied for example (se asset subsidy module) and we just want to show the accum ones. | |||||||
| Steps To Reproduce | See code Arun, verify the reports works after the change 1. Go to Financial Management || Assets || Analysis Tools || Depreciation schedule || Depreciation schedule | |||||||
| Proposed Solution | Modify the SQL to obtain just FAct_Acct entryies from the AccumDepreciation account | |||||||
| Tags | 250MP3releasecandidate, arun | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0018220) sathiyan (reporter) 2009-07-14 14:03 |
Edu: could you please confirm on the below action items. Action 1:need to delete the condition as F.AMTACCTDR<>'0' Action 2:a_asset_acct.a_accumdepreciation_acct = c_validcombination.c_validcombination_id and fact_acct.acct_id=c_validcombination.account_id (sort of condition need to be add) to filter AcumDepreciation account. Regards Sathiyan. |
|
(0018224) eduardo_Argal (developer) 2009-07-14 16:51 |
Yes. Thats the change. Do not forget to add c_validcombination as a table in the FROM of the select statement and test it. Thanks |
|
(0018251) jayakumar (reporter) 2009-07-15 08:42 edited on: 2009-07-15 08:46 |
currently we used fact_acct.amtacctdr. It wont return any value for the above newly added condition. if we use the column fact_acct.amtacctcr Instead of using the column fact_acct.amtacctdr, then we will get the expected result. |
|
(0018255) jayakumar (reporter) 2009-07-15 13:12 |
As per Edu suggestion:fact_acct.amtacctcr field used in the select clause instead of fact_acct.amtacctdr. |
|
(0018257) hgbot (developer) 2009-07-15 13:42 |
Repository: erp/devel/pi Changeset: 13e546b079f479ff72ded6fe04cd143c5d83e78d Author: Jayakumar Kasinathan <jayakumar.kasinathan <at> openbravo.com> Date: Wed Jul 15 17:09:32 2009 -0400 URL: http://code.openbravo.com/erp/devel/pi/rev/13e546b079f479ff72ded6fe04cd143c5d83e78d [^] Fixes bug 9867 Asset report: SQL wrongly written --- M src/org/openbravo/erpCommon/ad_reports/ReportAssetDepreciationSchedule_data.xsql --- |
|
(0018519) arunkumar (reporter) 2009-07-22 07:05 |
I went to Financial Management || Assets || Analysis Tools || Depreciation schedule || Asset report for depreciation schedule. I am able to verify the report in both HTML format and PDF format. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-07-13 18:23 | eduardo_Argal | New Issue | |
| 2009-07-13 18:23 | eduardo_Argal | Assigned To | => rajagopal |
| 2009-07-14 09:51 | eduardo_Argal | Status | new => scheduled |
| 2009-07-14 09:51 | eduardo_Argal | fix_in_branch | => pi |
| 2009-07-14 14:03 | sathiyan | Note Added: 0018220 | |
| 2009-07-14 16:51 | eduardo_Argal | Note Added: 0018224 | |
| 2009-07-15 06:44 | jayakumar | Assigned To | rajagopal => jayakumar |
| 2009-07-15 08:42 | jayakumar | Note Added: 0018251 | |
| 2009-07-15 08:43 | jayakumar | Note Edited: 0018251 | |
| 2009-07-15 08:46 | jayakumar | Note Edited: 0018251 | |
| 2009-07-15 13:12 | jayakumar | Note Added: 0018255 | |
| 2009-07-15 13:42 | hgbot | Checkin | |
| 2009-07-15 13:42 | hgbot | Note Added: 0018257 | |
| 2009-07-15 13:42 | hgbot | Status | scheduled => resolved |
| 2009-07-15 13:42 | hgbot | Resolution | open => fixed |
| 2009-07-15 13:42 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/13e546b079f479ff72ded6fe04cd143c5d83e78d [^] |
| 2009-07-21 16:24 | psarobe | Fixed in Version | => 2.50MP3 |
| 2009-07-21 16:26 | psarobe | Tag Attached: 250MP3releasecandidate | |
| 2009-07-21 19:25 | psarobe | Tag Attached: arun | |
| 2009-07-21 20:00 | psarobe | fix_in_branch | pi => |
| 2009-07-21 20:00 | psarobe | Proposed Solution updated | |
| 2009-07-22 07:05 | arunkumar | Status | resolved => closed |
| 2009-07-22 07:05 | arunkumar | Note Added: 0018519 | |
| 2009-07-23 00:00 | anonymous | sf_bug_id | 0 => 2825615 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |