Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008758
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2009-04-24 12:132009-05-14 17:58
ReporterAinhoaPagolaView Statuspublic 
Assigned Toareefbasha 
PriorityurgentResolutionfixedFixed in Version2.50MP1
StatusclosedFix in branchpiFixed in SCM revision7912e1e00ff6
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 8.4Database version8.3Ant version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008758: 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.
Tags250MP1
Attached Filesjpg file icon PurchaseInvoicecash.jpg [^] (83,452 bytes) 2009-04-24 12:13

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0008675 closedrajagopal pl-function ./C_INVOICE_POST.xml: has uuid bugs 
has duplicate defect 0009192 closedrafaroda When completing a purchase invoice I get an error 

-  Notes
(0015727)
hgbot (developer)
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 (developer)
2009-05-14 12:47

Also, this change is required: v_CB_Curr VARCHAR(32);
(0016352)
rafaroda (developer)
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 (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2009-04-24 12:13 AinhoaPagola New Issue
2009-04-24 12:13 AinhoaPagola Assigned To => rafaroda
2009-04-24 12:13 AinhoaPagola File Added: PurchaseInvoicecash.jpg
2009-04-24 12:13 AinhoaPagola Regression testing => No
2009-04-24 12:30 psarobe Status new => scheduled
2009-04-24 12:30 psarobe fix_in_branch => pi
2009-04-24 12:38 AinhoaPagola Assigned To rafaroda => sathiyan
2009-04-24 12:40 sathiyan Assigned To sathiyan => areefbasha
2009-04-24 12:45 psarobe Tag Attached: 250MP1
2009-04-25 07:39 hgbot Checkin
2009-04-25 07:39 hgbot Note Added: 0015727
2009-04-25 07:39 hgbot Status scheduled => resolved
2009-04-25 07:39 hgbot Resolution open => fixed
2009-04-25 07:39 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7912e1e00ff6bc545922f00f863431fa4b5da6b5 [^]
2009-05-04 19:27 psarobe Status resolved => closed
2009-05-05 00:00 anonymous sf_bug_id 0 => 2786921
2009-05-14 12:47 networkb Note Added: 0016351
2009-05-14 12:57 rafaroda Note Added: 0016352
2009-05-14 17:58 rafaroda Note Added: 0016360
2009-05-14 17:58 rafaroda Relationship added related to 0008675
2009-05-28 12:14 psarobe Relationship added has duplicate 0009192


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker