Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004686Openbravo ERP03. Procurement managementpublic2008-08-22 18:112008-09-04 10:08
onats 
iperdomo 
normalmajoralways
closedfixed 
10Windows XP Professional SP3
2.40alpha-r3 
2.40 
No
Core
No
0004686: Conversion of Requisition to Purchase Order raises PL/SQL Error.
When an existing Requsition is converted to a PO by clicking "Create Purchase Order", an error is raised below.

Error:
invalid input syntax for type numeric: """
1. Click on "Procurement Management ->Requisition"
2. Create a new Requisition with at least one line entry
3. Click on "Close" Button
4. Click on "Procurement Management -> Manage Requisition" and double click the newly created Requisition record.
5. Click on "Create Purchase Order" button.
No tags attached.
txt create-purchase-order.txt (669) 2008-08-22 18:11
https://issues.openbravo.com/file_download.php?file_id=223&type=bug
Issue History
2008-08-22 18:11onatsNew Issue
2008-08-22 18:11onatsAssigned To => cromero
2008-08-22 18:11onatssf_bug_id0 => 2067770
2008-08-22 18:11onatsFile Added: create-purchase-order.txt
2008-08-22 18:24psarobeOBNetwork customer => No
2008-08-22 18:24psarobeAssigned Tocromero => iperdomo
2008-08-22 18:24psarobeStatusnew => scheduled
2008-08-22 19:06svnbotCheckin
2008-08-22 19:06svnbotNote Added: 0008700
2008-08-22 19:06svnbotsvn_revision => 6510
2008-08-22 19:06iperdomoStatusscheduled => resolved
2008-08-22 19:06iperdomoResolutionopen => fixed
2008-09-04 10:08psarobeRegression testing => No
2008-09-04 10:08psarobeStatusresolved => closed
2008-09-04 10:08psarobeFixed in Version => 2.40

Notes
(0008700)
svnbot   
2008-08-22 19:06   
Repository: openbravo
Revision: 6510
Author: iperdomo
Date: 2008-08-22 19:06:16 +0200 (Fri, 22 Aug 2008)

Fixes bug 4517 and related to bug 4686: The procedure now works on Postgresql and copies the qty and uom of the requisition.

---
U trunk/src-db/database/model/functions/M_REQUISITION_CREATEPO.xml
---

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