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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018158
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 02. Master data managementmajorrandom2011-08-02 13:432011-08-23 13:13
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version2.50MP33
StatusclosedFix in branchFixed in SCM revision48e207d5d25d
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP31SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018158: When syncrhonizing a and processing orders at the same time orders are not properly imported

DescriptionWhen launching at the same time the job that imports orders in I_ORDER and the process of orders imported, some orders are not properly processed and there is a difference in the total in sales reports in ERP and POS.

Probably the reason is that when starting the process of orders, it is taken part of one order that is currently syncrhonizing. Then the same order in POS will be splitted into two orders in ERP with two shipments and two invoices and the calculation of taxes and discounts may make this difference

When launching the processes at a different time, totals in ERP and POS are equal
Steps To ReproduceLaunch the import orders job and the process of orders several times at the same time.
Proposed SolutionDo not synchronize orders by line but by order. i.e. Syncrhonize all orders line of the same order in the same transaction in order to avoid orders to be splitted into two.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on defect 0018159 closedadrianromero When syncrhonizing a and processing orders at the same time orders are not properly imported 
related to backport 00182682.50MP33 closedadrianromero When syncrhonizing a and processing orders at the same time orders are not properly imported 

-  Notes
(0040002)
hgbot (developer)
2011-08-08 14:48

Repository: erp/stable/2.50
Changeset: 3566ab13442fd4b1672de48c246f209831885641
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Aug 08 14:32:35 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/3566ab13442fd4b1672de48c246f209831885641 [^]

Fixes issue 0018158: When syncrhonizing a and processing orders at the same time orders are not properly imported
It has been added a check that sets when all lines of an order have been synchronized

---
M src-db/database/model/tables/I_ORDER.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
---
(0040004)
hgbot (developer)
2011-08-08 15:21

Repository: erp/pmods/org.openbravo.pos.sync
Changeset: 48e207d5d25d732a59420a302c03c3ecbc053c70
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Aug 08 13:44:38 2011 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.pos.sync/rev/48e207d5d25d732a59420a302c03c3ecbc053c70 [^]

Fixes issue 0018158: When syncrhonizing a and processing orders at the same time orders are not properly imported
It has been added a check that sets when all lines of an order have been synchronized

---
M resources/ORDERS.ktr
M src/org/openbravo/pos/sync/rest/UploadOrderProcess.java
---
(0040024)
adrianromero (manager)
2011-08-09 09:54

* Testing the issue

It must be verified first that a simple cycle of orders import can be done without any issue.

To test sepcifically the issue it must be tested that orders not fully synchronized are not taken into account when processing orders. To do this use the testing job https://code.openbravo.com/erp/pmods/org.openbravo.pos.sync/file/1cf76cbf04fe/resources/test_orders_2.50.ktr [^]

* Synchronize one line of one order of two lines. To do this indicate in the url generation step line_id = 0 and maxline_id = 1. This indicates that it is going to be synchronized a line of an order of two lines: 0 and 1

* Try to execute the import orders process and verify that no order is created.

* Synchronize the second line of the order : line_id = 1 and maxline_id = 1

* Try to execute the import orders process and verify that one order of two lines has been synchronized.

* Other areas affected

Only the import order process and synchronization process has been affected.
(0040438)
jonalegriaesarte (reporter)
2011-08-23 13:13

Verified

- Issue History
Date Modified Username Field Change
2011-08-02 13:43 adrianromero New Issue
2011-08-02 13:43 adrianromero Assigned To => adrianromero
2011-08-02 13:43 adrianromero Modules => Core
2011-08-02 13:43 adrianromero Issue generated from 0018099
2011-08-02 13:44 adrianromero Status new => scheduled
2011-08-02 13:44 adrianromero fix_in_branch => pi
2011-08-02 13:45 adrianromero Issue cloned 0018159
2011-08-02 13:45 adrianromero Relationship added depends on 0018159
2011-08-02 13:47 adrianromero Target Version 3.0MP3 =>
2011-08-02 13:47 adrianromero fix_in_branch pi =>
2011-08-08 14:48 hgbot Checkin
2011-08-08 14:48 hgbot Note Added: 0040002
2011-08-08 14:48 hgbot Status scheduled => resolved
2011-08-08 14:48 hgbot Resolution open => fixed
2011-08-08 14:48 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/3566ab13442fd4b1672de48c246f209831885641 [^]
2011-08-08 15:21 hgbot Checkin
2011-08-08 15:21 hgbot Note Added: 0040004
2011-08-08 15:21 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.50/rev/3566ab13442fd4b1672de48c246f209831885641 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.pos.sync/rev/48e207d5d25d732a59420a302c03c3ecbc053c70 [^]
2011-08-09 09:54 adrianromero Note Added: 0040024
2011-08-12 10:32 adrianromero Issue cloned 0018268
2011-08-12 10:32 adrianromero Relationship added related to 0018268
2011-08-23 13:13 jonalegriaesarte Note Added: 0040438
2011-08-23 13:13 jonalegriaesarte Status resolved => closed
2011-08-23 13:13 jonalegriaesarte Fixed in Version => 2.50MP33


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker