Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0003557Openbravo ERPZ. Otherspublic2007-12-18 19:292008-06-12 09:44
Reportercromero 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0003557: Recalculate amortization does not work in postgr
DescriptionOB:2.35
Postgres:8.2

Once you have created an amortization, if you try to recalculate it in
postgres, this error is shown:
months_between(timestamp with time zone,timestamp with time zone) does not
exist.

months_between is an Oracle function that doesnt exist in Postgre. It
should be created.

Carlos Romero
Openbravo Team.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0002363 closed cromero Recalculate amortization does not work in postgres in 2.35 
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0007146)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:44)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1853361 [^]
(0004041)
cromero   
2007-12-18 19:33   
(edited on: 2008-06-12 09:27)
Logged In: YES
user_id=1500614
Originator: YES

Fixed.

Added months_between function and corrected the A_ASSET_POST function for PostgreSQL.

Carlos Romero
Openbravo Team
(0004042)
iperdomo   
2007-12-26 11:13   
(edited on: 2008-06-12 09:27)
Logged In: YES
user_id=1820699
Originator: NO

Verification assigned to: iperdomo
File Added: 1853361.png