Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022004Openbravo ERP09. Financial managementpublic2012-10-19 09:092012-11-21 06:06
ReporterVictorVillar 
Assigned Topramakrishnan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tonaiaramartinez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022004: If the Previously Depreciated Amt. is filled, the amortization percentage is wrong for the completes periods
DescriptionIf the Previously Depreciated Amt. is filled, the amortization percentage is wrong for the completes periods
Steps To ReproduceGo to the Asset Group screen
Create a new record

Organization = F&B US, Inc.,
Name = Computer Hardware,
Save the record

Go to the Assets screen
Create a new record

Organization = F&B US West Coast,
Search Key = Laptop,
Name = Laptop,
Asset Category = Computer Hardware,
Currency = USD,
Product =Cola,
Depreciate checkbox = selected,
Depreciation Type = Linear,
Calculate Type = Time,
Amortize = Yearly,
Usable Life - Years = 3,
Purchase Date = today's date,
Cancellation Date = blank,
Depreciation Start Date = today's date,
Depreciation End Date = blank,
Asset Value = 1500,
Residual Asset Value = 0,
Depreciation Amount = 1500,
Previously Depreciated Amt = 500,
Save the record

To create the amortization periods:

Click the Create amortization button

Click the OK button

Realise that the amortization percentage of one of the periods (01-31-2015 - 12-01-2015 - 12-31-2015) is 51.13 and this is not correct.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-19 09:09VictorVillarNew Issue
2012-10-19 09:09VictorVillarAssigned To => dmiguelez
2012-10-19 09:09VictorVillarModules => Core
2012-10-19 09:09VictorVillarIssue Monitored: networkb
2012-10-25 11:18pramakrishnanAssigned Todmiguelez => pramakrishnan
2012-10-25 11:18pramakrishnanStatusnew => scheduled
2012-10-25 11:18pramakrishnanfix_in_branch => pi
2012-11-07 11:22pramakrishnanNote Added: 0054065
2012-11-13 09:01hgbotCheckin
2012-11-13 09:01hgbotNote Added: 0054180
2012-11-13 09:01hgbotStatusscheduled => resolved
2012-11-13 09:01hgbotResolutionopen => fixed
2012-11-13 09:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a08511286b678b36af7be3f01ef15541990b04ca [^]
2012-11-13 09:18naiaramartinezReview Assigned To => naiaramartinez
2012-11-13 09:18naiaramartinezNote Added: 0054188
2012-11-13 09:18naiaramartinezStatusresolved => closed
2012-11-21 06:06hudsonbotCheckin
2012-11-21 06:06hudsonbotNote Added: 0054368

Notes
(0054065)
pramakrishnan   
2012-11-07 11:22   
Test Plan 1:

Login as Openbravo/openbravo
Create a new asset group

Organization = F&B US, Inc.,
Name = Computer Hardware,
Save the record

Create a new asset

Organization = F&B US West Coast,
Search Key = Laptop,
Name = Laptop,
Asset Category = Computer Hardware,
Currency = USD,
Product =Cola,
Depreciate checkbox = selected,
Depreciation Type = Linear,
Calculate Type = Time,
Amortize = Yearly,
Usable Life - Years = 5,
Purchase Date = today's date,
Cancellation Date = blank,
Depreciation Start Date = today's date,
Depreciation End Date = blank,
Asset Value = 2000,
Residual Asset Value = 0,
Depreciation Amount = 2000,
Previously Depreciated Amt = 100,
Save the record

Click the Create amortization button
Click the OK button

Notice that the Asset Amortization is created as follows
31-12-2012 - 01-12-2012 - 31-12-2012 3.66 69.56 EUR
31-12-2013 - 01-12-2013 - 31-12-2013 20.00 380.00 EUR
31-12-2014 - 01-12-2014 - 31-12-2014 20.00 380.00 EUR
31-12-2015 - 01-12-2015 - 31-12-2015 20.00 380.00 EUR
31-12-2016 - 01-12-2016 - 31-12-2016 20.00 380.00 EUR
31-12-2017 - 01-12-2017 - 31-12-2017 16.34 310.44 EUR

Test Plan 2:

Login as Openbravo/openbravo
Create a new asset group

Organization = F&B US, Inc.,
Name = Computer Hardware,
Save the record

Create a new asset

Organization = F&B US West Coast,
Search Key = Laptop,
Name = Laptop,
Asset Category = Computer Hardware,
Currency = USD,
Product =Cola,
Depreciate checkbox = selected,
Depreciation Type = Linear,
Calculate Type = Time,
Amortize = Yearly,
Usable Life - Years = 5,
Purchase Date = today's date,
Cancellation Date = blank,
Depreciation Start Date = today's date,
Depreciation End Date = blank,
Asset Value = 1900,
Residual Asset Value = 0,
Depreciation Amount = 1900,
Previously Depreciated Amt = 0,
Save the record

Click the Create amortization button
Click the OK button

Notice that the Asset Amortization is created as follows
31-12-2012 - 01-12-2012 - 31-12-2012 3.66 69.56 EUR
31-12-2013 - 01-12-2013 - 31-12-2013 20.00 380.00 EUR
31-12-2014 - 01-12-2014 - 31-12-2014 20.00 380.00 EUR
31-12-2015 - 01-12-2015 - 31-12-2015 20.00 380.00 EUR
31-12-2016 - 01-12-2016 - 31-12-2016 20.00 380.00 EUR
31-12-2017 - 01-12-2017 - 31-12-2017 16.34 310.44 EUR
(0054180)
hgbot   
2012-11-13 09:01   
Repository: erp/devel/pi
Changeset: a08511286b678b36af7be3f01ef15541990b04ca
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Thu Nov 08 12:29:22 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a08511286b678b36af7be3f01ef15541990b04ca [^]

Fixes Issue 22004: Wrong Amortization Percent

---
M src-db/database/model/functions/A_ASSET_POST.xml
---
(0054188)
naiaramartinez   
2012-11-13 09:18   
Code Review + Testing OK
(0054368)
hudsonbot   
2012-11-21 06:06   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c3c5e61b0164 [^]

Maturity status: Test