Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012118Openbravo ERP03. Procurement managementpublic2010-02-03 16:192010-03-10 18:29
Reporterplujan 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version2.50MP12Fixed in Versionpi 
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
Summary0012118: In Postgres, I have an error when creating a purchase order line
DescriptionWhen saving a line for a new purchase invoice, I get an error message:
ERROR: function c_orderlinetax_insert(character varying, character varying, character varying, character varying, character varying, numeric, numeric, numeric) does not exist
    
Steps To Reproduce1. In the latest PI revision, log in with Openbravo user
2. Change to openbravo admin role
3. Go to Procurement > Transactions > Purchase Order
4. Create a new purchase order header
5. Go to lines
6. Create a new line and save. Instead of the success message, you got above error.
Proposed SolutionNote that referred function actually exist. The issue is that the call has more parameters than function definition:
XML: c_orderlinetax_insert(char, char, char, char, char, number)
The error message:c_orderlinetax_insert(char, char, char, char, char, number, number, number)
Additional Information
TagsNo tags attached.
Relationships
related to defect 00121142.50MP12 closed eduardo_Argal Error in a trigger when executing the Generate Invoice process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-03 16:19plujanNew Issue
2010-02-03 16:19plujanAssigned To => eduardo_Argal
2010-02-03 16:19plujanOBNetwork customer => No
2010-02-03 16:20plujanStatusnew => scheduled
2010-02-03 16:20plujanfix_in_branch => pi
2010-02-03 16:28plujanRelationship addedrelated to 0012114
2010-02-04 20:09hgbotCheckin
2010-02-04 20:09hgbotNote Added: 0023968
2010-02-04 20:09hgbotStatusscheduled => resolved
2010-02-04 20:09hgbotResolutionopen => fixed
2010-02-04 20:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1f4d1a81a64ae6829c64d2ac109f7a47d774e1e0 [^]
2010-02-05 12:01plujanNote Added: 0023990
2010-02-05 12:01plujanStatusresolved => closed
2010-02-05 12:01plujanFixed in Version => pi
2010-02-10 12:43anonymoussf_bug_id0 =>
2010-02-15 17:36hudsonbotCheckin
2010-02-15 17:36hudsonbotNote Added: 0024294
2010-03-10 18:29anonymoussf_bug_id => 2968009

Notes
(0023968)
hgbot   
2010-02-04 20:09   
Repository: erp/devel/pi
Changeset: 1f4d1a81a64ae6829c64d2ac109f7a47d774e1e0
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Feb 04 20:07:51 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1f4d1a81a64ae6829c64d2ac109f7a47d774e1e0 [^]

Fixes bug 0012118: In Postgres, I have an error when creating a purchase order line

---
M src-db/database/model/functions/C_ORDERLINETAX_INSERT.xml
---
(0023990)
plujan   
2010-02-05 12:01   
Tested in PI
(0024294)
hudsonbot   
2010-02-15 17:36   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/1f4d1a81a64a [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2596487a564c [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16391.obx [^]