Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012152Openbravo ERP09. Financial managementpublic2010-02-05 10:152010-03-10 18:29
networkb 
dalsasua 
highminoralways
closedno change required 
5
2.50MP11 
 
OBPS
Core
No
0012152: Uncorrect asset amortization when "Monthly" is used
An asset amortization is calculated, for an asset. "Time" and "Monthly", calculation type is used.

IE, if 12 Uselife months are set, 13 lines are created.
Go to Financial Management || Assets || Assets. Create a new register.
Enter a name, search key.
Check Depreciate.
Select "Linear" as Depreciation type.
Select "Time" as Calculate type.
Select "Monthly" as Amortize.
Enter, "12" as Usable Life - Months.
Enter "20-01-2004", as Purchase Date and Depreciation Start Date.
Enter, "1000" as Asset Value and Depreciation Amt.
Enter, "550" as Previously Depreciated Amt.
Press "Calculate amortization".
Go to Asset amortization tab.
No tags attached.
related to defect 0012184 closed adrianromero Line No not auto-incremented when Create Amortization. 
png AmortHeader.png (78,958) 2010-02-08 09:48
https://issues.openbravo.com/file_download.php?file_id=2180&type=bug
png

png Amort.png (69,835) 2010-02-08 09:48
https://issues.openbravo.com/file_download.php?file_id=2181&type=bug
png

png NewAmort.png (72,865) 2010-02-08 10:55
https://issues.openbravo.com/file_download.php?file_id=2182&type=bug
png
Issue History
2010-02-05 10:15networkbNew Issue
2010-02-05 10:15networkbAssigned To => rafaroda
2010-02-05 10:15networkbOBNetwork customer => Yes
2010-02-08 09:46rafarodaNote Added: 0023998
2010-02-08 09:46rafarodaStatusnew => feedback
2010-02-08 09:48rafarodaFile Added: AmortHeader.png
2010-02-08 09:48rafarodaFile Added: Amort.png
2010-02-08 10:45networkbTarget Version2.50MP13 =>
2010-02-08 10:45networkbSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4#r4
2010-02-08 10:45networkbStatusfeedback => new
2010-02-08 10:45networkbNote Added: 0024001
2010-02-08 10:54rafarodaNote Added: 0024003
2010-02-08 10:54rafarodaStatusnew => acknowledged
2010-02-08 10:55rafarodaFile Added: NewAmort.png
2010-02-08 12:54dalsasuaNote Added: 0024012
2010-02-09 11:02rafarodaAssigned Torafaroda => dalsasua
2010-02-09 11:02rafarodaStatusacknowledged => scheduled
2010-02-09 11:03rafarodaNote Added: 0024045
2010-02-09 11:03rafarodaStatusscheduled => closed
2010-02-09 11:03rafarodaResolutionopen => no change required
2010-02-09 11:05rafarodaRelationship addedrelated to 0012184
2010-02-10 12:43anonymoussf_bug_id0 =>
2010-03-10 18:29anonymoussf_bug_id => 2968017

Notes
(0023998)
rafaroda   
2010-02-08 09:46   
Please provide more information since the issue has not been able to be reproduced (see 2 screenshots attached).
(0024001)
networkb   
2010-02-08 10:45   
Uncorrect Date
(0024003)
rafaroda   
2010-02-08 10:54   
Can be reproduced with the new steps provided (see image NewAmort.png)
(0024012)
dalsasua   
2010-02-08 12:54   
Have you used as purchase and depr.start dates 20-01-2004 (as in steps to reproduce), or 01-01-2004 (as in the screenshots)?

If I set date=01-01-2004 I obtain 12 rows of 37.5 = 450 € (what is correct: 1000-550)
If I set date=20-01-2004 I obtaain 13 rows: 11*37.50+1*24.19+1*13.31 = 450 € (what is correct)

Please notice that, although the number of rows is 13, the number of months where this asset is being depreciated is 12:

row01_20-01-2004_31-01-2004_12 days
row02_01-02-2004_29-02-2004_1 month
row03_01-03-2004_31-03-2004_1 month
...
row12_01-12-2004_31-12-2004_1 month
row13_01-01-2005_19-01-2005_19 days

TOTAL: 12 days + 11 months + 19 days = 12 months.

Please notice that depreciations do always take place at the end of the period. In this case, last day of the month.

Regards.
(0024045)
rafaroda   
2010-02-09 11:03   
The behaviour described, creating 13 records (but 12 months) if the initial date is 20-01-2004 is correct so no change is required.