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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011926
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2010-01-11 10:552010-02-01 17:53
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityimmediateResolutionfixedFixed in Version2.50MP11
StatusclosedFix in branchFixed in SCM revision38be6c5a1c51
ProjectionnoneETAnoneTarget Version2.50MP11
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP9SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011926: Import Order creates uncorrect documentno and Date invoice

DescriptionWhen POS order is used in Import Order window, it generates good shipment and sales invoice.

If two POS order are created to be imported, their sales invoices are created uncorrect, such as:

Sales Invoice 1: DocumentNo 20005, Date Invoiced 01-01-2010
Sales Invoice 2: DocumentNo 20004, Date Invoiced 02-01-2010

It should be:

Sales Invoice 1: DocumentNo 20004, Date Invoiced 01-01-2010
Sales Invoice 2: DocumentNo 20005, Date Invoiced 02-01-2010

Note: In order to be able to reproduce this bug, this one, https://issues.openbravo.com/view.php?id=11801 [^] must be applied first
Steps To ReproduceGo to General Setup > Import Data > Import Order.
Create a new register. Select POS order as Document type; Main as Organization; 02-01-2010 as Order Date and Scheduled Delivery Date; Select one BP; select a Product; Enter a Ordered Quantity and Order Price.
Save it.
Create other register. Fill same paremeters as the previous one, BUT, enter as Order Date and Scheduled Delivery Date, 01-01-2010.
Save it.
Process it.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00118012.50MP11 closedharikrishnan Invoice date and Movement date are not correct when a POS order is imported 
related to defect 00119402.50MP14 closedadrianromero Import order creates uncorrect dates 
related to backport 00159842.50MP27 closedadrianromero When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order) 

-  Notes
(0023374)
hgbot (developer)
2010-01-13 06:53

 Repository: erp/devel/pi
Changeset: 399d481f34488aa0626a568fa378a9c8eb947553
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Jan 13 11:21:17 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/399d481f34488aa0626a568fa378a9c8eb947553 [^]

Fixes Issue 11926: Import Order creates uncorrect documentno and Date invoice.

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0023557)
harikrishnan (viewer)
2010-01-19 11:11

 steps to test fix are
  1.First Record
      Organization =main
      Document Type=POS Order
      Document No=80020(Automatically created while saving the record)
      Order Date = 01-01-2010
      Scheduled Delivery Date =01-01-2010
      Business Partner= McGiver Supplies
      Product = Hat
      Ordered Quantity = 10
      Unit Price =10
  Save the record.
  2.Second Record
      Organization =main
      Document Type=POS Order
      Document No=80021(Automatically created while saving the record)
      Order Date = 02-01-2010
      Scheduled Delivery Date =02-01-2010
      Business Partner= McGiver Supplies
      Product = Hat
      Ordered Quantity = 10
      Unit Price =10
      Click on "Import Orders".

The result obtained

    Process completed successfully
Orders inserted: 2; Orders line inserted: 2;
Orders processed: 2;
Process result:
80020 - Shipment No. 600016 has been created , Invoice No. 200017 has been created
80021 - Shipment No. 600017 has been created , Invoice No. 200018 has been created
(0023561)
arunkumar (viewer)
2010-01-19 12:09

 Tested & Working fine
(0023638)
hudsonbot (viewer)
2010-01-20 23:25

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/399d481f3448 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/fa6621f85351 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15942.obx [^]
(0023824)
hgbot (developer)
2010-01-27 13:12

 Repository: erp/devel/pi
Changeset: 38be6c5a1c51fec82b9ff006f2d85183e8243276
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Jan 27 17:41:26 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/38be6c5a1c51fec82b9ff006f2d85183e8243276 [^]

Fixes Issue 11926: Import Order creates uncorrect documentno and Date invoice.

---
M src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
---
(0023868)
networkb (viewer)
2010-01-29 17:05

 It has been tested with 20.000 orders, and works properly
(0023869)
rafaroda (viewer)
2010-01-29 17:07

 Did these orders belong to different organizations?
(0023870)
networkb (viewer)
2010-01-29 17:08

 No
(0023873)
sureshbabu (viewer)
2010-02-01 11:15

 Now its working as per the steps given above..
(0023894)
hudsonbot (viewer)
2010-02-01 17:53

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/38be6c5a1c51 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/3d5bd712a24b [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16007.obx [^]

- Issue History
Date Modified Username Field Change
2010-01-11 10:55 networkb New Issue
2010-01-11 10:55 networkb Assigned To => rafaroda
2010-01-11 10:55 networkb OBNetwork customer => Yes
2010-01-11 16:33 rafaroda Relationship added related to 0011801
2010-01-12 10:29 rafaroda Assigned To rafaroda => harikrishnan
2010-01-12 10:29 rafaroda Status new => scheduled
2010-01-12 16:34 rafaroda Relationship added related to 0011940
2010-01-13 06:53 hgbot Checkin
2010-01-13 06:53 hgbot Note Added: 0023374
2010-01-13 06:53 hgbot Status scheduled => resolved
2010-01-13 06:53 hgbot Resolution open => fixed
2010-01-13 06:53 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/399d481f34488aa0626a568fa378a9c8eb947553 [^]
2010-01-19 11:11 harikrishnan Note Added: 0023557
2010-01-19 12:09 arunkumar Note Added: 0023561
2010-01-19 12:09 arunkumar Status resolved => closed
2010-01-19 12:09 arunkumar Fixed in Version => 2.50MP11
2010-01-20 00:01 anonymous sf_bug_id 0 => 2935292
2010-01-20 23:25 hudsonbot Checkin
2010-01-20 23:25 hudsonbot Note Added: 0023638
2010-01-27 13:12 hgbot Checkin
2010-01-27 13:12 hgbot Note Added: 0023824
2010-01-27 13:12 hgbot Status closed => resolved
2010-01-27 13:12 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/399d481f34488aa0626a568fa378a9c8eb947553 [^] => http://code.openbravo.com/erp/devel/pi/rev/38be6c5a1c51fec82b9ff006f2d85183e8243276 [^]
2010-01-29 17:05 networkb Note Added: 0023868
2010-01-29 17:07 rafaroda Note Added: 0023869
2010-01-29 17:08 networkb Note Added: 0023870
2010-02-01 11:15 sureshbabu Note Added: 0023873
2010-02-01 11:15 sureshbabu Status resolved => closed
2010-02-01 17:53 hudsonbot Checkin
2010-02-01 17:53 hudsonbot Note Added: 0023894
2011-03-15 14:39 adrianromero Relationship added related to 0015984

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker