Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016308Openbravo ERP02. Master data managementpublic2011-03-15 14:412011-03-17 00:00
Reporteradrianromero 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0RC6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016308: When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order)
DescriptionWhen importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order). It could happen that data are not sorted correctly and if there are two lines for the same order, another order could appear between these lines and two orders are generated to the same order. For example:

Order1 Documentno: 1
Order2 Documentno: 2
Order2 Documentno: 2
Order1 Documentno: 1
Steps To Reproduce- Master Data Management || Import Data || Import Orders
- Import 1000 lines (500 different orders)
- Some orders are created to one POS order in table i_order

(we can provide a database to reproduce the problem)
Proposed SolutionThe problem is in method selectNotImported in src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql. Actually the order by is:

Order by dateordered, documentno,....

and i think that it should be:

Order by ad_client_id, documentno, dateordered,....
Additional Information
TagsNo tags attached.
Relationships
blocks backport 00159842.50MP27 closed adrianromero When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-15 14:41adrianromeroNew Issue
2011-03-15 14:41adrianromeroAssigned To => adrianromero
2011-03-15 14:41adrianromeroModules => Core
2011-03-15 14:41adrianromeroIssue generated from0015984
2011-03-15 14:41adrianromeroRelationship addedblocks 0015984
2011-03-15 14:48hgbotCheckin
2011-03-15 14:48hgbotNote Added: 0034889
2011-03-15 14:48hgbotStatusnew => resolved
2011-03-15 14:48hgbotResolutionopen => fixed
2011-03-15 14:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/84d59a44cabdbf7185bfaa47487e95c728b97926 [^]
2011-03-15 14:48adrianromeroNote Added: 0034890
2011-03-16 19:11jonalegriaesarteNote Added: 0034968
2011-03-16 19:11jonalegriaesarteStatusresolved => closed
2011-03-16 19:11jonalegriaesarteFixed in Version => 3.0RC6
2011-03-17 00:00anonymoussf_bug_id0 => 3217699

Notes
(0034889)
hgbot   
2011-03-15 14:48   
Repository: erp/devel/pi
Changeset: 84d59a44cabdbf7185bfaa47487e95c728b97926
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Mar 15 14:47:00 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/84d59a44cabdbf7185bfaa47487e95c728b97926 [^]

Fixes issue 0016308: When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order)
It has been modified the order of fields in the ORDER BY clause to order first by document number.

---
M src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
---
(0034890)
adrianromero   
2011-03-15 14:48   
* Testing the issue

Follow the steps to test and verify that now only two orders are created instead of three.

Verify also that the related issue 11926 works as expected.

* Areas affected

No other areas affected. Just the Import orders process has been modified.
(0034968)
jonalegriaesarte   
2011-03-16 19:11   
Verified