Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009867
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2009-07-13 18:232009-07-23 00:00
Reportereduardo_ArgalView Statuspublic 
Assigned Tojayakumar 
PriorityhighResolutionfixedFixed in Version2.50MP3
StatusclosedFix in branchFixed in SCM revision13e546b079f4
ProjectionnoneETAnoneTarget Versionpi
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009867: Asset report; SQL wrongly writen

DescriptionThe 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 ReproduceSee code
Arun, verify the reports works after the change

1. Go to Financial Management || Assets || Analysis Tools || Depreciation schedule || Depreciation schedule
Proposed SolutionModify the SQL to obtain just FAct_Acct entryies from the AccumDepreciation account
Tags250MP3releasecandidate, arun
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  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.

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker