Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008758Openbravo ERP03. Procurement managementpublic2009-04-24 12:132009-05-14 17:58
ReporterAinhoaPagola 
Assigned Toareefbasha 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.4
Product Versionpi 
Target VersionFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008758: Unable to complete Purchase Invoices with form of payment cash - UUID
DescriptionClicking the complete button in a purchase invoice with form of payment fields set to cash throws the following error:
Error:
column "line" is of type numeric but expression is of type character varying
Steps To ReproduceGo to Procurement Management> Transactions > Purchase Invoice
Create a new record.
Important: Select Cash as form of payment.
Create a line.
Go back to the header an press complete button.
Error pops-up.
Proposed SolutionCheck the PL as there must be some Id not properly changed in the uuid project.
Additional Information
Tags250MP1
Relationships
related to defect 0008675 closed rajagopal pl-function ./C_INVOICE_POST.xml: has uuid bugs 
has duplicate defect 0009192 closed rafaroda When completing a purchase invoice I get an error 
Attached Filesjpg PurchaseInvoicecash.jpg (83,452) 2009-04-24 12:13
https://issues.openbravo.com/file_download.php?file_id=1220&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-04-24 12:13AinhoaPagolaNew Issue
2009-04-24 12:13AinhoaPagolaAssigned To => rafaroda
2009-04-24 12:13AinhoaPagolaFile Added: PurchaseInvoicecash.jpg
2009-04-24 12:13AinhoaPagolaRegression testing => No
2009-04-24 12:30psarobeStatusnew => scheduled
2009-04-24 12:30psarobefix_in_branch => pi
2009-04-24 12:38AinhoaPagolaAssigned Torafaroda => sathiyan
2009-04-24 12:40sathiyanAssigned Tosathiyan => areefbasha
2009-04-24 12:45psarobeTag Attached: 250MP1
2009-04-25 07:39hgbotCheckin
2009-04-25 07:39hgbotNote Added: 0015727
2009-04-25 07:39hgbotStatusscheduled => resolved
2009-04-25 07:39hgbotResolutionopen => fixed
2009-04-25 07:39hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7912e1e00ff6bc545922f00f863431fa4b5da6b5 [^]
2009-05-04 19:27psarobeStatusresolved => closed
2009-05-05 00:00anonymoussf_bug_id0 => 2786921
2009-05-14 12:47networkbNote Added: 0016351
2009-05-14 12:57rafarodaNote Added: 0016352
2009-05-14 17:58rafarodaNote Added: 0016360
2009-05-14 17:58rafarodaRelationship addedrelated to 0008675
2009-05-28 12:14psarobeRelationship addedhas duplicate 0009192

Notes
(0015727)
hgbot   
2009-04-25 07:39   
Repository: erp/devel/pi
Changeset: 7912e1e00ff6bc545922f00f863431fa4b5da6b5
Author: Areef Basha <areef.basha <at> openbravo.com>
Date: Sat Apr 25 11:07:20 2009 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/7912e1e00ff6bc545922f00f863431fa4b5da6b5 [^]

Fixes bug 8758: Unable to complete Purchase Invoices with form of payment cash - UUID.

Now the VARCHAR2 data type has been changed to NUMBER data type.

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0016351)
networkb   
2009-05-14 12:47   
Also, this change is required: v_CB_Curr VARCHAR(32);
(0016352)
rafaroda   
2009-05-14 12:57   
Please notice that v_CB_Curr VARCHAR2(32) stores C_Currency_ID (UUID) so it is correct: so no change is required in https://code.openbravo.com/erp/devel/pi/file/9859ac217a3f/src-db/database/model/functions/C_INVOICE_POST.xml [^] and fix is OK

SELECT C_CURRENCY_ID
INTO v_CB_Curr
FROM C_CASHBOOK
WHERE C_CASHBOOK_ID = v_cashBook;
(0016360)
rafaroda   
2009-05-14 17:58   
The change of v_CB_Curr NUMBER by v_CB_Curr VARCHAR(32) to work properly with UUIDs was done in issue 0008675 https://code.openbravo.com/erp/devel/pi/rev/cc77134fb92b9804b855f7e09a9fdd886c630cc1 [^]