Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0018707

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

minor

always

2011-10-05 16:19

2011-12-01 18:42

Reporter

mirurita

View Status

public

Assigned To

ioritzCia

Priority

normal

Resolution

fixed

Fixed in Version

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

3.0MP6

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

pi

SCM revision

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

12826

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0018707: Assets - create amortization process failing when Start Date is the last day of the month (Monthly depreciation type)

Description

If you configure a monthly amortization starting in the last day of a month it will fail:

Error:
An amortization plan cannot be created for so low amount and / or so big amount of time

Steps To Reproduce

1) Go to Financial Management || Assets || Assets || Assets
2) Create a new Asset
- Search Key: Test
- Name: Test
- Calculate Type: Time
- Amortize: Monthly
- Usable Life - Months: 2
- Purchase Date: 31-03-2011
- Depreciation Start Date: 31-03-2011
- Asset Value: 100
- Depreciation Amt: 100
3) Click on Calculate Amortization button

The process fails, showing the following error:
An amortization plan cannot be created for so low amount and / or so big amount of time

Tags

No tags attached.

Asset_Amortization.png [^] (53,291 bytes) 2011-10-05 16:19

a_asset_post.txt [^] (1,002 bytes) 2011-11-22 10:47 [Show Content] [Hide Content]

diff -r c5f59683d7af src-db/database/model/functions/A_ASSET_POST.xml
--- a/src-db/database/model/functions/A_ASSET_POST.xml	Wed Oct 05 17:04:41 2011 +0200
+++ b/src-db/database/model/functions/A_ASSET_POST.xml	Thu Oct 06 12:11:42 2011 +0200
@@ -329,7 +329,7 @@
             while not finish
             loop
               IF(v_COUNT=1 AND to_number(v_BEGINING_DATE-v_FIRST_DAY_DATE)<>0) THEN
-                v_Percentage:=to_number(to_number(last_day(v_BEGINING_DATE) -v_BEGINING_DATE)) / (trunc((last_day(v_BEGINING_DATE) -(TO_DATE('01-'||to_char(TO_DATE(v_BEGINING_DATE), 'MM-YYYY'), 'DD-MM-YYYY')))) +1) * v_PercentageGeneral;
+                v_Percentage:=(to_number(to_number(last_day(v_BEGINING_DATE) -v_BEGINING_DATE))+1) / (trunc((last_day(v_BEGINING_DATE) -(TO_DATE('01-'||to_char(TO_DATE(v_BEGINING_DATE), 'MM-YYYY'), 'DD-MM-YYYY')))) +1) * v_PercentageGeneral;
                 v_USELIFEMONTHS:=v_USELIFEMONTHS+1;
               ELSE
                 v_Percentage:=v_PercentageGeneral;

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

backport

2.50MP37

closed

Assets - create amortization process failing when Start Date is the last day of the month (Monthly depreciation type)

Notes
(0043592) hgbot (developer) 2011-11-30 16:22	Repository: erp/devel/pi Changeset: c6091e1c1bf1db5c80b6309e92052a74cf9acb52 Author: Ioritz Cia <ioritz.cia <at> openbravo.com> Date: Fri Nov 25 09:24:08 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/c6091e1c1bf1db5c80b6309e92052a74cf9acb52 [^] Fixes issue 18707: Assets - create amortization process failing when Start Date is the last day of the month (Monthly depreciation type). --- M src-db/database/model/functions/A_ASSET_POST.xml ---

(0043658) mirurita (viewer) 2011-12-01 17:54	Verified in http://live.builds.openbravo.com/int-full-pgsql [^] on 01/12/2011.

(0043664) hudsonbot (viewer) 2011-12-01 18:42	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/d188a2d275a9 [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2011-10-05 16:19	mirurita	New Issue
2011-10-05 16:19	mirurita	Assigned To	=> jonalegriaesarte
2011-10-05 16:19	mirurita	File Added: Asset_Amortization.png
2011-10-05 16:19	mirurita	Modules	=> Core
2011-10-05 16:19	mirurita	OBNetwork customer	=> No
2011-10-10 12:55	mirurita	Support ticket	=> 12826
2011-10-10 12:55	mirurita	Resolution time	=> 1324335600
2011-10-10 12:55	mirurita	Severity	major => minor
2011-11-21 16:35	mirurita	File Added: a_asset_post
2011-11-22 10:46	mirurita	OBNetwork customer	No => Yes
2011-11-22 10:47	mirurita	File Deleted: a_asset_post
2011-11-22 10:47	mirurita	File Added: a_asset_post.txt
2011-11-22 10:50	ioritzCia	Target Version	=> 3.0MP6
2011-11-22 13:00	ioritzCia	Status	new => scheduled
2011-11-22 13:00	ioritzCia	fix_in_branch	=> pi
2011-11-24 16:55	jonalegriaesarte	Assigned To	jonalegriaesarte => ioritzCia
2011-11-30 16:22	hgbot	Checkin
2011-11-30 16:22	hgbot	Note Added: 0043592
2011-11-30 16:22	hgbot	Status	scheduled => resolved
2011-11-30 16:22	hgbot	Resolution	open => fixed
2011-11-30 16:22	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/c6091e1c1bf1db5c80b6309e92052a74cf9acb52 [^]
2011-12-01 17:54	mirurita	Note Added: 0043658
2011-12-01 17:54	mirurita	Status	resolved => closed
2011-12-01 18:42	hudsonbot	Checkin
2011-12-01 18:42	hudsonbot	Note Added: 0043664

Copyright © 2000 - 2009 MantisBT Group