Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014323Openbravo ERP07. Sales managementpublic2010-08-26 13:592010-09-13 12:38
Reportersureshbabu 
Assigned Toadrianromero 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.50MP20 
Target Version2.50MP21Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014323: Not able to copy lines using Copy From Order from sales order window
DescriptionNot able to copy lines using Copy From Order from sales order window
Steps To Reproduce1) create and complete a sales order using below details
BP: Red Bunny
Product: hammer
Qty"3

2) Try to create one more sales order using "Copy From Order" option

System throws the below error message
      
ERROR: function m_get_offers_price(timestamp without time zone, character varying, character varying, numeric, numeric, numeric) does not exist
Proposed Solution
Additional Information
TagsRegression QA
Relationships
depends on defect 00136812.50MP20 closed sivaraman Not able to copy line item details using Copy from order option from sales order window 
Attached Filesjpg Not able copy lines using copy from order option in sales order.JPG (218,623) 2010-08-26 14:02
https://issues.openbravo.com/file_download.php?file_id=2961&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2010-08-26 13:59sureshbabuNew Issue
2010-08-26 13:59sureshbabuAssigned To => adrianromero
2010-08-26 13:59sureshbabuOBNetwork customer => No
2010-08-26 14:02sureshbabuFile Added: Not able copy lines using copy from order option in sales order.JPG
2010-08-26 14:07sureshbabuRelationship addeddepends on 0013681
2010-08-26 14:29hgbotCheckin
2010-08-26 14:29hgbotNote Added: 0030357
2010-08-26 14:29hgbotStatusnew => resolved
2010-08-26 14:29hgbotResolutionopen => fixed
2010-08-26 14:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0d04ea1a0486d5cc3e4b00daac09efd9c4da2263 [^]
2010-08-26 14:31adrianromeroNote Added: 0030358
2010-08-30 07:32sureshbabuNote Added: 0030429
2010-08-30 07:32sureshbabuStatusresolved => closed
2010-08-30 10:14psarobeTag Attached: Regression QA
2010-09-07 09:17hudsonbotCheckin
2010-09-07 09:17hudsonbotNote Added: 0030678
2010-09-13 12:38anonymoussf_bug_id0 => 3065185

Notes
(0030357)
hgbot   
2010-08-26 14:29   
Repository: erp/devel/pi
Changeset: 0d04ea1a0486d5cc3e4b00daac09efd9c4da2263
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Aug 26 14:28:00 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0d04ea1a0486d5cc3e4b00daac09efd9c4da2263 [^]

Fixes issue 0014323: Not able to copy lines using Copy From Order from sales order window
It has been removed the TO_NUMBER invoke because the last parameter of the M_GET_OFFERS_PRICE is a VARCHAR

---
M src/org/openbravo/erpCommon/ad_actionButton/CopyFromPOOrder_data.xsql
---
(0030358)
adrianromero   
2010-08-26 14:31   
* Testing the issue

In Posgresql follow the steps to reproduce and notice that now there is no error thrown after executing the "Copy From Order" process

* Other areas affected

It is only affected the Copy From Order process. Because the change involves an SQL change, it has to be verified the fix in both database engines: PostgreSQL and Oracle.
(0030429)
sureshbabu   
2010-08-30 07:32   
verified in postgres context now its working fine
(0030678)
hudsonbot   
2010-09-07 09:17   
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/0d04ea1a0486 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4390fe5213a4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18274.obx [^]