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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005661
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 02. Master data managementminorhave not tried2008-10-27 09:542009-03-03 17:16
ReporterDowidView Statuspublic 
Assigned ToDowid 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision10639
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005661: Import Order process problem

Description1. When importing orders with "mixed" order lines in the *.csv file, incorrect orders are created.

2. When importing the same *.csv file twice the process creates orders with the same Order dates and Document No
Steps To Reproduce1) Import order following the steps in [1]

For the CSV, TXT file use the following data format:

BB7747FFQQ,POS Order,bellphone,beer,500,10.6,100
BB7747FFQQ1,POS Order,Millman,beer,500,10.6,100
BB7747FFQQ1,POS Order,Millman,beer,500,10.6,100
AA875875875RRTT,Standard Order,Millman,beer,100,10.5,102
AA875875875RRTT,Standard Order,Millman,shirts,400,13.4,102
BB7747FFQQ1,POS Order,Millman,beer,100,10.6,100
BB7747FFQQ1,POS Order,Millman,beer,200,10.6,100
AA875875875RRTT,Standard Order,Millman,beer,100,10.5,102
AA875875875RRTT,Standard Order,Millman,beer,100,10.5,102
BB7747FFQQ,POS Order,Millman,beer,500,10.6,100

2) Import this file twice.

3) Go to the orders imported in 'Sales Management || Transactions || Sales Order'.

Please notice that the orders have been inserted incorrectly.



[1] http://wiki.openbravo.com/wiki/QA_test_plan_2.50/Test_cases [^] [^]
Proposed SolutionReview the import process and sort by DocumentNo and DateOrdererd before importing from the temporary table, also review the logic that checks for existing orders.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0005633 closedDowid Import Order process problem 

-  Notes
(0010692)
svnbot (reporter)
2008-11-26 10:52

Repository: openbravo
Revision: 10594
Author: dowid
Date: 2008-11-26 10:52:37 +0100 (Wed, 26 Nov 2008)

Bug fixed 0005661: Import Order process problem

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_process/ImportOrder.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=10594&sc=1 [^]
(0010742)
svnbot (reporter)
2008-11-26 18:33

Repository: openbravo
Revision: 10639
Author: villind
Date: 2008-11-26 18:33:25 +0100 (Wed, 26 Nov 2008)

Merged r10594. Bug fixed 0005661: Import Order process problem

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_process/ImportOrder.java
U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
_U branches/bonware/r2.40/update.database.launch
---

https://dev.openbravo.com/websvn/openbravo/?rev=10639&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-10-27 09:54 psarobe New Issue
2008-10-27 09:54 psarobe Assigned To => Dowid
2008-10-27 09:54 psarobe Status new => scheduled
2008-11-26 10:52 svnbot Checkin
2008-11-26 10:52 svnbot Note Added: 0010692
2008-11-26 10:52 svnbot Status scheduled => resolved
2008-11-26 10:52 svnbot Resolution open => fixed
2008-11-26 10:52 svnbot svn_revision => 10594
2008-11-26 18:33 svnbot Checkin
2008-11-26 18:33 svnbot Note Added: 0010742
2008-11-26 18:33 svnbot svn_revision 10594 => 10639
2009-03-03 17:16 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker