Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011926Openbravo ERP02. Master data managementpublic2010-01-11 10:552010-02-01 17:53
Reporternetworkb 
Assigned Toharikrishnan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP9 
Target Version2.50MP11Fixed in Version2.50MP11 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011926: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00118012.50MP11 closed harikrishnan Invoice date and Movement date are not correct when a POS order is imported 
related to defect 00119402.50MP14 closed adrianromero Import order creates uncorrect dates 
related to backport 00159842.50MP27 closed adrianromero When importing POS orders and in some special conditions some orders are created to one order in the temporal table (i_order) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-11 10:55networkbNew Issue
2010-01-11 10:55networkbAssigned To => rafaroda
2010-01-11 16:33rafarodaRelationship addedrelated to 0011801
2010-01-12 10:29rafarodaAssigned Torafaroda => harikrishnan
2010-01-12 10:29rafarodaStatusnew => scheduled
2010-01-12 16:34rafarodaRelationship addedrelated to 0011940
2010-01-13 06:53hgbotCheckin
2010-01-13 06:53hgbotNote Added: 0023374
2010-01-13 06:53hgbotStatusscheduled => resolved
2010-01-13 06:53hgbotResolutionopen => fixed
2010-01-13 06:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/399d481f34488aa0626a568fa378a9c8eb947553 [^]
2010-01-19 11:11harikrishnanNote Added: 0023557
2010-01-19 12:09arunkumarNote Added: 0023561
2010-01-19 12:09arunkumarStatusresolved => closed
2010-01-19 12:09arunkumarFixed in Version => 2.50MP11
2010-01-20 00:01anonymoussf_bug_id0 => 2935292
2010-01-20 23:25hudsonbotCheckin
2010-01-20 23:25hudsonbotNote Added: 0023638
2010-01-27 13:12hgbotCheckin
2010-01-27 13:12hgbotNote Added: 0023824
2010-01-27 13:12hgbotStatusclosed => resolved
2010-01-27 13:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/399d481f34488aa0626a568fa378a9c8eb947553 [^] => http://code.openbravo.com/erp/devel/pi/rev/38be6c5a1c51fec82b9ff006f2d85183e8243276 [^]
2010-01-29 17:05networkbNote Added: 0023868
2010-01-29 17:07rafarodaNote Added: 0023869
2010-01-29 17:08networkbNote Added: 0023870
2010-02-01 11:15sureshbabuNote Added: 0023873
2010-02-01 11:15sureshbabuStatusresolved => closed
2010-02-01 17:53hudsonbotCheckin
2010-02-01 17:53hudsonbotNote Added: 0023894
2011-03-15 14:39adrianromeroRelationship addedrelated to 0015984

Notes
(0023374)
hgbot   
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   
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   
2010-01-19 12:09   
Tested & Working fine
(0023638)
hudsonbot   
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   
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   
2010-01-29 17:05   
It has been tested with 20.000 orders, and works properly
(0023869)
rafaroda   
2010-01-29 17:07   
Did these orders belong to different organizations?
(0023870)
networkb   
2010-01-29 17:08   
No
(0023873)
sureshbabu   
2010-02-01 11:15   
Now its working as per the steps given above..
(0023894)
hudsonbot   
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 [^]