Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007293Openbravo ERP07. Sales managementpublic2009-01-30 19:032009-04-21 10:54
ReporterAinhoaPagola 
Assigned ToDowid 
PrioritylowSeveritytrivialReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.4
Product Versionpi 
Target VersionFixed in Version2.50beta 
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
Summary0007293: 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
Tagscommsup_sprint6
Relationships
depends on backport 00075422.40 closed Dowid Commisions with quarterly frecuency type fails in PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-30 19:03AinhoaPagolaNew Issue
2009-01-30 19:03AinhoaPagolaAssigned To => rafaroda
2009-01-30 19:03AinhoaPagolasf_bug_id0 => 2549822
2009-01-30 19:03AinhoaPagolaOBNetwork customer => No
2009-01-30 19:03AinhoaPagolaRegression testing => No
2009-02-03 10:49psarobeStatusnew => scheduled
2009-02-03 10:49psarobefix_in_branch => trunk
2009-02-03 11:17rafarodaAssigned Torafaroda => AinhoaPagola
2009-02-03 12:07AinhoaPagolaAssigned ToAinhoaPagola => Dowid
2009-02-12 18:25DowidIssue cloned0007542
2009-02-12 18:25DowidRelationship addeddepends on 0007542
2009-02-12 19:09svnbotCheckin
2009-02-12 19:09svnbotNote Added: 0013438
2009-02-12 19:09svnbotStatusscheduled => resolved
2009-02-12 19:09svnbotResolutionopen => fixed
2009-02-12 19:09svnbotsvn_revision => 13112
2009-02-20 09:25PavelPonomarevTag Attached: commsup_sprint6
2009-04-21 10:54psarobeStatusresolved => closed

Notes
(0013438)
svnbot   
2009-02-12 19:09   
Repository: openbravo
Revision: 13112
Author: dowid
Date: 2009-02-12 19:09:05 +0100 (Thu, 12 Feb 2009)

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

---
U trunk/src-db/database/model/prescript-PostgreSql.sql
---

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