Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0012879 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 03. Procurement management | major | always | 2010-04-06 11:39 | 2010-05-18 12:12 | |||
Reporter | networkb | View Status | public | |||||
Assigned To | sivaraman | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 783d62a77511 | |||
Projection | none | ETA | none | Target Version | 2.50MP17 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.50MP14 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0012879: The Document Type is wrong when we use Requisition to Order | |||||||
Description | We have a two Document Type for purchase order. One Default. When we create a Purchase Order using 'Requisition to Order', the Purchase Order has the Document Type set as NO default. | |||||||
Steps To Reproduce | -As Openbravo Admin go to Financial Management || Accounting || Setup || Document Type -Create a new record. - Name: Document Type New - G/L Category: Standard. - Document Category: Purchase Order - Table: C_Order - Set Default. -Go to rocurement Management || Transactions || Requisition -Create a new record. -BP: McGiver -Product: Hammer -Complete -Go to Procurement Management || Transactions || Requisition To Order -Select the requisition created. -Create the purchase order. -Go to Procurement Management || Transactions || Purchase Order -Realize that the purchase order created has Trnsaction Document: Purchase Order, when it must be 'Document Type New' | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(0026320) adrianromero (viewer) 2010-04-16 16:29 |
Probably the error is in the function AD_GET_DOCTYPE and has to be added a DESC modifier when ordering by field ISDEFAULT in the query: SELECT C_DocType_ID, NAME,ISDEFAULT FROM C_DOCTYPE WHERE DOCBASETYPE='POO' AND ISACTIVE='Y' AND AD_Client_Id='1000000' AND AD_ISORGINCLUDED('0', AD_Org_ID, '1000000') <> -1 ORDER BY AD_ISORGINCLUDED('0', AD_Org_ID, '1000000'), IsDefault DESC, C_DocType_ID Be very carefull when modifying this function because it is used in several places |
(0026558) hgbot (developer) 2010-04-22 08:18 |
Repository: erp/devel/pi Changeset: 783d62a775119eb164ee5e29b15fd196602d676e Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com> Date: Thu Apr 22 11:47:46 2010 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/783d62a775119eb164ee5e29b15fd196602d676e [^] Fixes issue 12879: The Document Type is wrong when we use Requisition to Order --- M src-db/database/model/functions/AD_GET_DOCTYPE.xml --- |
(0026559) sivaraman (viewer) 2010-04-22 08:23 |
Steps to test: kindly follow all the steps as given in 'Steps To Reproduce' section. |
(0026655) sureshbabu (viewer) 2010-04-23 18:34 edited on: 2010-04-26 13:09 |
Tested working fine |
(0026676) sureshbabu (viewer) 2010-04-26 13:11 |
Tested in live qa PI build working fine |
(0027266) hudsonbot (viewer) 2010-05-14 15:27 |
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/783d62a77511 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/36f76c8d7193 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17198.obx [^] |
![]() |
|||
Date Modified | Username | Field | Change |
2010-04-06 11:39 | networkb | New Issue | |
2010-04-06 11:39 | networkb | Assigned To | => adrianromero |
2010-04-06 11:39 | networkb | OBNetwork customer | => Yes |
2010-04-12 11:32 | adrianromero | Status | new => scheduled |
2010-04-12 11:32 | adrianromero | fix_in_branch | => pi |
2010-04-16 16:05 | adrianromero | Relationship added | related to 0012857 |
2010-04-16 16:29 | adrianromero | Note Added: 0026320 | |
2010-04-16 16:49 | psarobe | Note Added: 0026321 | |
2010-04-16 16:51 | psarobe | Note Deleted: 0026321 | |
2010-04-21 12:49 | adrianromero | Relationship deleted | related to 0012857 |
2010-04-22 06:37 | sivaraman | Assigned To | adrianromero => sivaraman |
2010-04-22 08:18 | hgbot | Checkin | |
2010-04-22 08:18 | hgbot | Note Added: 0026558 | |
2010-04-22 08:18 | hgbot | Status | scheduled => resolved |
2010-04-22 08:18 | hgbot | Resolution | open => fixed |
2010-04-22 08:18 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/783d62a775119eb164ee5e29b15fd196602d676e [^] |
2010-04-22 08:23 | sivaraman | Note Added: 0026559 | |
2010-04-23 18:34 | sureshbabu | Note Added: 0026655 | |
2010-04-23 18:34 | sureshbabu | Status | resolved => new |
2010-04-23 18:34 | sureshbabu | Resolution | fixed => open |
2010-04-26 11:56 | adrianromero | Status | new => scheduled |
2010-04-26 13:05 | adrianromero | Status | scheduled => resolved |
2010-04-26 13:05 | adrianromero | Resolution | open => fixed |
2010-04-26 13:09 | sureshbabu | Note Edited: 0026655 | View Revisions |
2010-04-26 13:11 | sureshbabu | Note Added: 0026676 | |
2010-04-26 13:11 | sureshbabu | Status | resolved => closed |
2010-04-27 00:00 | anonymous | sf_bug_id | 0 => 2992607 |
2010-05-14 15:27 | hudsonbot | Checkin | |
2010-05-14 15:27 | hudsonbot | Note Added: 0027266 | |
2010-05-18 12:12 | gorka_gil | Target Version | 2.50MP15 => 2.50MP17 |
Copyright © 2000 - 2009 MantisBT Group |