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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0014323
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2010-08-26 13:592010-09-13 12:38
ReportersureshbabuView Statuspublic 
Assigned Toadrianromero 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0d04ea1a0486
ProjectionnoneETAnoneTarget Version2.50MP21
OSLinux 32 bitDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP20SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014323: 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
TagsRegression QA
Attached Filesjpg file icon Not able copy lines using copy from order option in sales order.JPG [^] (218,623 bytes) 2010-08-26 14:02

- Relationships Relation Graph ] Dependency Graph ]
depends on defect 00136812.50MP20 closedsivaraman Not able to copy line item details using Copy from order option from sales order window 

-  Notes
(0030357)
hgbot (developer)
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 (manager)
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 (reporter)
2010-08-30 07:32

verified in postgres context now its working fine
(0030678)
hudsonbot (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-08-26 13:59 sureshbabu New Issue
2010-08-26 13:59 sureshbabu Assigned To => adrianromero
2010-08-26 14:02 sureshbabu File Added: Not able copy lines using copy from order option in sales order.JPG
2010-08-26 14:07 sureshbabu Relationship added depends on 0013681
2010-08-26 14:29 hgbot Checkin
2010-08-26 14:29 hgbot Note Added: 0030357
2010-08-26 14:29 hgbot Status new => resolved
2010-08-26 14:29 hgbot Resolution open => fixed
2010-08-26 14:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0d04ea1a0486d5cc3e4b00daac09efd9c4da2263 [^]
2010-08-26 14:31 adrianromero Note Added: 0030358
2010-08-30 07:32 sureshbabu Note Added: 0030429
2010-08-30 07:32 sureshbabu Status resolved => closed
2010-08-30 10:14 psarobe Tag Attached: Regression QA
2010-09-07 09:17 hudsonbot Checkin
2010-09-07 09:17 hudsonbot Note Added: 0030678
2010-09-13 12:38 anonymous sf_bug_id 0 => 3065185


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker