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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005633
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminorhave not tried2008-10-23 16:452009-04-21 11:06
ReporterDowidView Statuspublic 
Assigned ToDowid 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision10593
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

0005633: 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 ]
depends on backport 0005661 closedDowid Import Order process problem 
related to feature request 0006201 acknowledgedrmorley The unique condition for Sales Order. 

-  Notes
(0009753)
psarobe (manager)
2008-10-27 09:54

 Please only fix the import process to sort by DocumentNo and DateOrdered.

The unique condition should be: Organization, type document, Documentno, Dateordered. But this should be reported as Feature request and the condition must be a unique constraint in the C_ORDER table
(0010691)
svnbot (reporter)
2008-11-26 10:51

 Repository: openbravo
Revision: 10593
Author: dowid
Date: 2008-11-26 10:51:06 +0100 (Wed, 26 Nov 2008)

Bug fixed 0005633: Import Order process problem

---
U trunk/src/org/openbravo/erpCommon/ad_process/ImportOrder.java
U trunk/src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
---

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

- Issue History
Date Modified Username Field Change
2008-10-23 16:45 Dowid New Issue
2008-10-23 16:45 Dowid Assigned To => cromero
2008-10-23 16:45 Dowid sf_bug_id 0 => 2189590
2008-10-23 16:45 Dowid Regression testing => No
2008-10-23 16:45 Dowid Description Updated
2008-10-24 14:21 Dowid Proposed Solution updated
2008-10-27 09:54 psarobe Status new => scheduled
2008-10-27 09:54 psarobe Note Added: 0009753
2008-10-27 09:54 psarobe Assigned To cromero => Dowid
2008-10-27 09:54 psarobe fix_in_branch => trunk
2008-11-26 10:44 Dowid Relationship added related to 0006201
2008-11-26 10:51 svnbot Checkin
2008-11-26 10:51 svnbot Note Added: 0010691
2008-11-26 10:51 svnbot Status scheduled => resolved
2008-11-26 10:51 svnbot Resolution open => fixed
2008-11-26 10:51 svnbot svn_revision => 10593
2009-04-21 11:06 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker