Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0018158 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
backport | [Openbravo ERP] 02. Master data management | major | random | 2011-08-02 13:43 | 2011-08-23 13:13 | |||
Reporter | adrianromero | View Status | public | |||||
Assigned To | adrianromero | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP33 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 48e207d5d25d | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | PostgreSQL | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.50MP31 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | 12282 | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0018158: When syncrhonizing a and processing orders at the same time orders are not properly imported | |||||||
Description | When 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 Reproduce | Launch the import orders job and the process of orders several times at the same time. | |||||||
Proposed Solution | Do 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|||||||||||||||
|
![]() |
|
(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 (viewer) 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 (viewer) 2011-08-23 13:13 |
Verified |
![]() |
|||
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 | OBNetwork customer | => Yes |
2011-08-02 13:43 | adrianromero | Support ticket | => 12282 |
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 |