Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0041071 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] SAP Connector Mappings | major | unable to reproduce | 2019-06-11 13:12 | 2019-12-26 18:39 | |||
| Reporter | samuel_nicuesa | View Status | public | |||||
| Assigned To | nonofrancisco | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | b6e347875fb1 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | aferraz | |||||||
| Regression introduced in release | ||||||||
| Summary | 0041071: In some circumstances some cash ups are not exported to SAP | |||||||
| Description | In some circumstances, some cash ups are not exported to SAP | |||||||
| Steps To Reproduce | When processing a cashup (and any DAL object), the updated column is not updated when the object is committed, but when the object is flushed. It could happen that the cashup export process is run between the moment a cashup is flushed and the moment it is committed. In that case, this cashup won't be exported during this process because although it meets the updated condition, it hasn't been committed to the database yet. It will neither be exported during next export processes because it won't meet the updated condition anymore. | |||||||
| Proposed Solution | Add EM_SAPOBMP_ISEXPORTED column to cashup table with defaultValue 'N'. Take into account this column, instead of updated column, in cashup export query; same as we do in invoice export query. Add a modulescript to update EM_SAPOBMP_ISEXPORTED to 'Y' to every cashup with updated column < cashup last synchronization date (present in OBEI_Entity_Synchronization table). | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0112856) aferraz (manager) 2019-06-18 12:39 |
We could have the same problem with any entity being exported to SAP based on its updated column. Fix should be done in the infrastructure part. |
|
(0112937) aferraz (manager) 2019-06-21 12:58 edited on: 2019-06-21 13:00 |
Finally, we will fix the cashup export in the mappings module and we will report a new design defect to fix the problem in the core module for every entity: 0041150 |
|
(0113022) nonofrancisco (developer) 2019-06-26 06:01 edited on: 2019-06-26 23:02 |
Test Plan Install SAP ECC Mappings module 1.- On ERP Back End As Openbravo/The White Valley Group Admin Go to Initialize Entity Synchronization Table window External System type: SAP ECC Start Integration From Time: now Click on Done button Run update.database Verify the following information is shown when modulescript UpdateExportedFlagInCashUpModuleScript is executed 3 OBPOS_APP_CASHUP records updated for WPUUMS mapping on client The White Valley Group 3 OBPOS_APP_CASHUP records updated for WPUTAB mapping on client The White Valley Group 2.- On Retail Front End As vallblanca User in VBS-1 terminal Create a new ticket Pay the ticket in Cash Create a new Cash Up 3.- On ERP Back End As Openbravo/The White Valley Group Admin Go EDL Configuration window Add a new record EDL Process: BOB ID Based Export Process Go to Output tab Add a new record Output Type: Debug Go to Communication with SAP ECC Server window Add a new record Communication Protocol: Debug Path to iDoc folder: path where documents will be exported Go to Organization window Edit Vall Blanca Store organization Set some value in SAP Filiale field Go to Tax Rate window Edit Entregas IVA 21% tax rate Set some value in SAP Code field Go to Channel Touchpoint window Edit VBS POS Terminal terminal Set some value in SAP Terminal field Go to Payment Methods window Edit Cash payment method Set some value in SAP Code field Go to Process Request window Add a new record Process: SAP ECC Export Synchronization Process Timming: Run Immediately Reschedule process SAP ECC Export Synchronization Process Go to path where iDocs should be generated Verify WPUUMS and WPUTAB documents were generated Go to Cashup History window Edit the last Cashup created Verify the flags Has been exported to SAP in a WPUUMS iDoc Has been exported to SAP in a WPUUTAB iDoc are checked 4.- On Retail Front End As vallblanca User in VBS-1 terminal Create a new ticket Pay the ticket in Cash Create a new Cash Up 5.- On ERP Back End As Openbravo/The White Valley Group Admin Go to Cashup History window Edit the last Cashup created Verify the flags Has been exported to SAP in a WPUUMS iDoc Has been exported to SAP in a WPUUTAB iDoc are unchecked |
|
(0113075) hgbot (developer) 2019-06-27 18:30 |
Repository: erp/pmods/org.openbravo.service.integration.sap.ecc.mappings Changeset: b6e347875fb1d1d2a7ec7790d762a40aa4763315 Author: Nono Carballo <nonofce <at> gmail.com> Date: Tue Jun 25 16:31:37 2019 -0400 URL: http://code.openbravo.com/erp/pmods/org.openbravo.service.integration.sap.ecc.mappings/rev/b6e347875fb1d1d2a7ec7790d762a40aa4763315 [^] Fixes issue 41071: Controls when Cash Up records have been exported. Two new columns were created in OBPOS_AppCashUp table to record when a CashUp has been exported in a WPUMMS or WPUTAB iDoc. The columns are shown in Cash Up History and Channel Touch Point/Cash Up History windows. The new columns were alse added to SAPOBMP_CashUp view. Two new RecordScheduledToBeExportedListener implementations were created to update the new columns when a WPUTAB/WPUUMS iDoc is generated. Exporters for WPUTAB and WPUUMS were modified to consider the new column instead of the updated column. A modulescript was added to set the new columns as exported for CashUps whose updated date is prior the last synchronization date of WPUUMS/WPUTAB iDocs. --- M src-db/database/model/views/SAPOBMP_CASHUP.xml M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_ELEMENT.xml M src-db/database/sourcedata/AD_FIELD.xml M src/org/openbravo/service/integration/sap/ecc/mappings/exporter/CashUpExporter.java M src/org/openbravo/service/integration/sap/ecc/mappings/exporter/CashUpWPUTABExporter.java A build/classes/org/openbravo/service/integration/sap/ecc/mappings/modulescript/UpdateExportedFlagInCashUpData.class A build/classes/org/openbravo/service/integration/sap/ecc/mappings/modulescript/UpdateExportedFlagInCashUpModuleScript.class A src-db/database/model/modifiedTables/OBPOS_APP_CASHUP.xml A src-util/modulescript/src/org/openbravo/service/integration/sap/ecc/mappings/modulescript/UpdateExportedFlagInCashUpModuleScript.java A src-util/modulescript/src/org/openbravo/service/integration/sap/ecc/mappings/modulescript/UpdateExportedFlagInCashUp_data.xsql A src/org/openbravo/service/integration/sap/ecc/mappings/exporter/ExportedCashupListener.java A src/org/openbravo/service/integration/sap/ecc/mappings/exporter/ExportedWPUTABListener.java A src/org/openbravo/service/integration/sap/ecc/mappings/exporter/ExportedWPUUMSListener.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2019-06-11 13:12 | samuel_nicuesa | New Issue | |
| 2019-06-11 13:12 | samuel_nicuesa | Assigned To | => platform |
| 2019-06-11 13:12 | samuel_nicuesa | Resolution time | => 1562018400 |
| 2019-06-13 09:41 | aferraz | Assigned To | platform => Triage Finance |
| 2019-06-13 13:21 | aferraz | Steps to Reproduce Updated | View Revisions |
| 2019-06-13 13:21 | aferraz | Proposed Solution updated | |
| 2019-06-13 13:22 | aferraz | Assigned To | Triage Finance => nonofrancisco |
| 2019-06-17 19:52 | nonofrancisco | Status | new => scheduled |
| 2019-06-18 12:37 | aferraz | Assigned To | nonofrancisco => platform |
| 2019-06-18 12:37 | aferraz | Status | scheduled => acknowledged |
| 2019-06-18 12:37 | aferraz | Status | acknowledged => scheduled |
| 2019-06-18 12:37 | aferraz | Status | scheduled => feedback |
| 2019-06-18 12:37 | aferraz | Status | feedback => new |
| 2019-06-18 12:39 | aferraz | Note Added: 0112856 | |
| 2019-06-19 13:03 | AugustoMauch | Assigned To | platform => AugustoMauch |
| 2019-06-19 15:45 | martinsdan | Issue Monitored: martinsdan | |
| 2019-06-19 16:03 | rafaroda | Issue Monitored: rafaroda | |
| 2019-06-21 12:58 | aferraz | Note Added: 0112937 | |
| 2019-06-21 13:00 | aferraz | Note Edited: 0112937 | View Revisions |
| 2019-06-21 13:00 | aferraz | Relationship added | related to 0041150 |
| 2019-06-21 13:01 | aferraz | Assigned To | AugustoMauch => nonofrancisco |
| 2019-06-21 13:01 | aferraz | Category | SAP Connector => SAP Connector Mappings |
| 2019-06-21 21:25 | nonofrancisco | Status | new => scheduled |
| 2019-06-26 06:01 | nonofrancisco | Note Added: 0113022 | |
| 2019-06-26 22:57 | nonofrancisco | Note Edited: 0113022 | View Revisions |
| 2019-06-26 22:58 | nonofrancisco | Note Edited: 0113022 | View Revisions |
| 2019-06-26 23:02 | nonofrancisco | Note Edited: 0113022 | View Revisions |
| 2019-06-27 18:30 | hgbot | Checkin | |
| 2019-06-27 18:30 | hgbot | Note Added: 0113075 | |
| 2019-06-27 18:30 | hgbot | Status | scheduled => resolved |
| 2019-06-27 18:30 | hgbot | Resolution | open => fixed |
| 2019-06-27 18:30 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.service.integration.sap.ecc.mappings/rev/b6e347875fb1d1d2a7ec7790d762a40aa4763315 [^] |
| 2019-06-27 18:30 | aferraz | Review Assigned To | => aferraz |
| 2019-06-27 18:30 | aferraz | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |