Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007542Openbravo ERP07. Sales managementpublic2009-02-12 18:252009-03-06 11:07
ReporterDowid 
Assigned ToDowid 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS10OS VersionSP2
Product Version2.40 
Target Version2.40Fixed in Version2.40MP3 
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
Summary0007542: Commisions with quarterly frecuency type fails in PostgreSQL
DescriptionIf a commision is created with frequency type set to quarterly in Postgre, it fails. The error is:

"timestamp with time zone units "q" not recognized"

This does not happen in Oracle.
Steps To ReproduceSales Management || Setup || Commission
- Create a record for a certain BP
- Frecuency type = quarterly
- Click 'Generate Commission' button
- Set a starting date

Error is displayed.
Proposed SolutionCheck lines 103-105 (r2.40) in c_commision_process function
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0007293 closed Dowid Commisions with quarterly frecuency type fails in PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-12 18:25DowidNew Issue
2009-02-12 18:25DowidAssigned To => Dowid
2009-02-12 18:25DowidOBNetwork customer => No
2009-02-12 18:25DowidRegression testing => No
2009-02-12 18:25DowidIssue generated from0007293
2009-02-12 18:25DowidRelationship addedblocks 0007293
2009-02-12 18:26DowidStatusnew => scheduled
2009-02-12 18:26Dowidfix_in_branch => trunk
2009-02-12 19:03Dowidversiontrunk => 2.40
2009-02-12 19:03DowidFixed in Version => 2.40
2009-02-12 19:03Dowidfix_in_branchtrunk => 2.40
2009-02-12 19:06svnbotCheckin
2009-02-12 19:06svnbotNote Added: 0013437
2009-02-12 19:06svnbotStatusscheduled => resolved
2009-02-12 19:06svnbotResolutionopen => fixed
2009-02-12 19:06svnbotsvn_revision => 13111
2009-03-03 17:31psarobeFixed in Version2.40 => 2.40MP3
2009-03-06 11:07psarobeStatusresolved => closed

Notes
(0013437)
svnbot   
2009-02-12 19:06   
Repository: openbravo
Revision: 13111
Author: dowid
Date: 2009-02-12 19:06:42 +0100 (Thu, 12 Feb 2009)

Bug fixed 0007542: Commissions with quarterly frecuency type fails in PostgreSQL

---
U branches/r2.40/src-db/database/model/prescript-PostgreSql.sql
---

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