Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015984Openbravo ERP02. Master data managementpublic2011-02-15 12:062011-03-16 19:10
Reporterjonalegriaesarte 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP26 
Target Version2.50MP27Fixed in Version2.50MP28 
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
Summary0015984: 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
related to defect 00119262.50MP11 closed harikrishnan Import Order creates uncorrect documentno and Date invoice 
depends on defect 0016308 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-02-15 12:06jonalegriaesarteNew Issue
2011-02-15 12:06jonalegriaesarteAssigned To => adrianromero
2011-02-15 12:06jonalegriaesarteModules => Core
2011-02-15 12:54jonalegriaesarteIssue Monitored: networkb
2011-03-15 14:39adrianromeroRelationship addedrelated to 0011926
2011-03-15 14:40adrianromeroStatusnew => scheduled
2011-03-15 14:40adrianromeroTypedefect => backport
2011-03-15 14:41adrianromeroIssue cloned0016308
2011-03-15 14:41adrianromeroRelationship addeddepends on 0016308
2011-03-15 14:43hgbotCheckin
2011-03-15 14:43hgbotNote Added: 0034886
2011-03-15 14:43hgbotStatusscheduled => resolved
2011-03-15 14:43hgbotResolutionopen => fixed
2011-03-15 14:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/0bf90dbd4f3403e8454e9356aa5720b940440a9a [^]
2011-03-15 14:47adrianromeroNote Added: 0034888
2011-03-16 19:10jonalegriaesarteNote Added: 0034967
2011-03-16 19:10jonalegriaesarteStatusresolved => closed
2011-03-16 19:10jonalegriaesarteFixed in Version => 2.50MP28

Notes
(0034886)
hgbot   
2011-03-15 14:43   
Repository: erp/stable/2.50
Changeset: 0bf90dbd4f3403e8454e9356aa5720b940440a9a
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Mar 15 14:42:36 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/0bf90dbd4f3403e8454e9356aa5720b940440a9a [^]

Fixes issue 0015984: 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
---
(0034888)
adrianromero   
2011-03-15 14:47   
* 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.
(0034967)
jonalegriaesarte   
2011-03-16 19:10   
Verified