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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012879
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2010-04-06 11:392010-05-18 12:12
ReporternetworkbView Statuspublic 
Assigned Tosivaraman 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision783d62a77511
ProjectionnoneETAnoneTarget Version2.50MP17
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP14SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012879: The Document Type is wrong when we use Requisition to Order

DescriptionWe 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'
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0026320)
adrianromero (manager)
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 (reporter)
2010-04-22 08:23

Steps to test: kindly follow all the steps as given in 'Steps To Reproduce' section.
(0026655)
sureshbabu (reporter)
2010-04-23 18:34
edited on: 2010-04-26 13:09

Tested working fine

(0026676)
sureshbabu (reporter)
2010-04-26 13:11

Tested in live qa PI build working fine
(0027266)
hudsonbot (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-04-06 11:39 networkb New Issue
2010-04-06 11:39 networkb Assigned To => adrianromero
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
Powered by Mantis Bugtracker