Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008758 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | major | always | 2009-04-24 12:13 | 2009-05-14 17:58 | |||
| Reporter | AinhoaPagola | View Status | public | |||||
| Assigned To | areefbasha | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 7912e1e00ff6 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 8.4 | Database version | 8.3 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008758: Unable to complete Purchase Invoices with form of payment cash - UUID | |||||||
| Description | Clicking 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 Reproduce | Go 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 Solution | Check the PL as there must be some Id not properly changed in the uuid project. | |||||||
| Tags | 250MP1 | |||||||
| Attached Files |  PurchaseInvoicecash.jpg [^] (83,452 bytes) 2009-04-24 12:13
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
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 (viewer) 2009-05-14 12:47 |
Also, this change is required: v_CB_Curr VARCHAR(32); |
|
(0016352) rafaroda (viewer) 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 (viewer) 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 [^] |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |