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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015984
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 02. Master data managementmajoralways2011-02-15 12:062011-03-16 19:10
ReporterjonalegriaesarteView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version2.50MP28
StatusclosedFix in branchFixed in SCM revision0bf90dbd4f34
ProjectionnoneETAnoneTarget Version2.50MP27
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP26SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015984: 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,....
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00119262.50MP11 closedharikrishnan Import Order creates uncorrect documentno and Date invoice 
depends on defect 0016308 closedadrianromero When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order) 

-  Notes
(0034886)
hgbot (developer)
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 (manager)
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 (reporter)
2011-03-16 19:10

Verified

- Issue History
Date Modified Username Field Change
2011-02-15 12:06 jonalegriaesarte New Issue
2011-02-15 12:06 jonalegriaesarte Assigned To => adrianromero
2011-02-15 12:06 jonalegriaesarte Modules => Core
2011-02-15 12:54 jonalegriaesarte Issue Monitored: networkb
2011-03-15 14:39 adrianromero Relationship added related to 0011926
2011-03-15 14:40 adrianromero Status new => scheduled
2011-03-15 14:40 adrianromero Type defect => backport
2011-03-15 14:41 adrianromero Issue cloned 0016308
2011-03-15 14:41 adrianromero Relationship added depends on 0016308
2011-03-15 14:43 hgbot Checkin
2011-03-15 14:43 hgbot Note Added: 0034886
2011-03-15 14:43 hgbot Status scheduled => resolved
2011-03-15 14:43 hgbot Resolution open => fixed
2011-03-15 14:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/0bf90dbd4f3403e8454e9356aa5720b940440a9a [^]
2011-03-15 14:47 adrianromero Note Added: 0034888
2011-03-16 19:10 jonalegriaesarte Note Added: 0034967
2011-03-16 19:10 jonalegriaesarte Status resolved => closed
2011-03-16 19:10 jonalegriaesarte Fixed in Version => 2.50MP28


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker