Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007509Openbravo ERP09. Financial managementpublic2009-02-11 17:182009-04-22 00:00
Reporternetworkb 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50beta 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007509: Calculate amortization process generates the last line out of balance
DescriptionIf you launch amortization process, the last line created in A_Amortizationline table, is out of balance. It is diferent of the rest.

Please, see steps to reproduce:
Steps To ReproduceCreate a new asset. Use "Calculate type" - Time; "Amortize" - Monthly; "Usable Life - Months" 12; Depreciation Start Date and Purchase date - 01-01-2008; Asset Value & Depreciation Amt. - 1200; Residual Asset Value & Previously Depreciated Amt. - 0.

Launch "Calculate amortization".

If you look at a_Amortizationline for this amortization, you will see 12 lines. The first eleven lines contain : Amortization_percentage: 8.33 AmortizationAmt: 100

But if you look the last one, contains: Amortization_percentage: 8.37 AmortizationAmt: 100.44

This is not correct
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0007560 closed eduardo_Argal Calculate amortization process generates the last line out of balance 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-11 17:18networkbNew Issue
2009-02-11 17:18networkbAssigned To => rafaroda
2009-02-11 17:18networkbOBNetwork customer => Yes
2009-02-11 17:18networkbRegression testing => No
2009-02-12 10:42rafarodaAssigned Torafaroda => eduardo_Argal
2009-02-12 19:33eduardo_ArgalNote Added: 0013441
2009-02-12 19:33eduardo_ArgalStatusnew => feedback
2009-02-13 17:20networkbNote Added: 0013486
2009-02-13 17:21networkbStatusfeedback => scheduled
2009-02-13 17:23rafarodaStatusscheduled => feedback
2009-02-13 17:23rafarodaStatusfeedback => new
2009-02-13 17:29rafarodaStatusnew => scheduled
2009-02-13 17:29rafarodafix_in_branch => trunk
2009-02-13 19:19svnbotCheckin
2009-02-13 19:19svnbotNote Added: 0013493
2009-02-13 19:19svnbotStatusscheduled => resolved
2009-02-13 19:19svnbotResolutionopen => fixed
2009-02-13 19:19svnbotsvn_revision => 13183
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777928

Notes
(0013441)
eduardo_Argal   
2009-02-12 19:33   
This procedure is working as it was designed. 100 % in 12 periods means 8.33% each period, then las period adjusts percentage missing then it results in 8.37.
Thats why
(0013486)
networkb   
2009-02-13 17:20   
The problem is that if you sum all amortization lines, total is 1200.41, not 1200
(0013493)
svnbot   
2009-02-13 19:19   
Repository: openbravo
Revision: 13183
Author: eduardoargal
Date: 2009-02-13 19:19:56 +0100 (Fri, 13 Feb 2009)

Fixes bug 0007509: Calculate amortization process generates the last line out of balance

---
U trunk/src-db/database/model/functions/A_ASSET_POST.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13183&sc=1 [^]