Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0005661 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
backport | [Openbravo ERP] 02. Master data management | minor | have not tried | 2008-10-27 09:54 | 2009-03-03 17:16 | |||
Reporter | Dowid | View Status | public | |||||
Assigned To | Dowid | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 10639 | |||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0005661: Import Order process problem | |||||||
Description | 1. 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 Reproduce | 1) 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 Solution | Review the import process and sort by DocumentNo and DateOrdererd before importing from the temporary table, also review the logic that checks for existing orders. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
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 |