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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007664
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2009-02-18 19:062009-04-22 00:00
ReporterwalleView Statuspublic 
Assigned Torajagopal 
PrioritylowResolutionfixedFixed in Version2.50
StatusclosedFix in branchFixed in SCM revisione99661ebff20
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007664: Copy from Order in Sales Order - wrong ordering

DescriptionThe ordering of the importet lines from a other order or proposal is not like
the sequence ordering in the baseorder from where you copy the lines.
Steps To Reproduce1) Create a new sales order
2) Go to sales order lines and add seq. 10 "product 1", seq 20 "product 2", seq 5 "product 3"
3) Create a new sales order and use Copy From Order button to copy this lines selecting the previous order

the sequence in the new order will be:
seq 10 "Product 1", seq 20 "product 2", seq 30 "product 3"
But in this case "product 3" must have the sequence 10 in the new order
Proposed SolutionChange ordering rule from field "c_orderline_id" to "line"
Tagscomsupchennai_sprint2
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0007653pi closedvmromanos Copy lines in the order should order result lines by product name 

-  Notes
(0014027)
psarobe (manager)
2009-02-24 13:30

 please provide the steps to get to that button
(0014265)
walle (reporter)
2009-03-03 09:34

 Hi...
After a detailed investigation we know now that there is no orderrule for the positions, the involved xsql file is the CopyFromPOOrder_data.xsql. Please change here the the following select statement

SELECT C_ORDERLINE_ID as orderline, C_UOM_ID, M_PRODUCT_ID, QTYORDERED, QUANTITYORDER,
M_PRODUCT_UOM_ID, DESCRIPTION, C_CURRENCY_ID
FROM C_ORDERLINE
WHERE C_ORDER_ID = TO_NUMBER(?)

with

SELECT C_ORDERLINE_ID as orderline, C_UOM_ID, M_PRODUCT_ID, QTYORDERED, QUANTITYORDER,
M_PRODUCT_UOM_ID, DESCRIPTION, C_CURRENCY_ID
FROM C_ORDERLINE
WHERE C_ORDER_ID = TO_NUMBER(?)
ORDER BY LINE ASC

This will allow that on pressing the button "Copy from Order" the same sequence ordering as in the sourceorder is granted.

BR, Walter
(0014651)
hgbot (developer)
2009-03-16 08:43

 Repository: erp/devel/pi
Changeset: e99661ebff202e70cedac841ba98a13913526890
Author: Rajagopal Baskaran <rajagopal.baskaran <at> openbravo.com>
Date: Mon Mar 16 12:55:33 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e99661ebff202e70cedac841ba98a13913526890 [^]

Fixes bug 7664 imported lines from a other order or proposal is not like the sequence ordering in the base order has been fixed.

---
M src/org/openbravo/erpCommon/ad_actionButton/CopyFromPOOrder_data.xsql
---

- Issue History
Date Modified Username Field Change
2009-02-18 19:06 walle New Issue
2009-02-18 19:06 walle Assigned To => rafaroda
2009-02-24 13:30 psarobe Note Added: 0014027
2009-02-24 13:30 psarobe Status new => feedback
2009-03-03 09:34 walle Note Added: 0014265
2009-03-06 08:30 rafaroda Assigned To rafaroda => rajagopal
2009-03-06 08:30 rafaroda Priority normal => low
2009-03-06 08:30 rafaroda Status feedback => scheduled
2009-03-06 08:30 rafaroda Proposed Solution updated
2009-03-16 08:43 hgbot Checkin
2009-03-16 08:43 hgbot Note Added: 0014651
2009-03-16 08:43 hgbot Status scheduled => resolved
2009-03-16 08:43 hgbot Resolution open => fixed
2009-03-16 08:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e99661ebff202e70cedac841ba98a13913526890 [^]
2009-03-16 11:33 rafaroda Relationship added related to 0007653
2009-03-17 11:22 rajagopal Tag Attached: comsupchennai_sprint2
2009-04-21 10:53 psarobe Status resolved => closed
2009-04-22 00:00 anonymous sf_bug_id 0 => 2777900

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker