Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0014395 | Openbravo ERP | A. Platform | public | 2010-09-01 17:39 | 2010-09-17 00:00 |
|
| Reporter | vmromanos | |
| Assigned To | mtaal | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.50MP20 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0014395: Strange behaviour updating a dataset |
| Description | Due to the bug 0014034, we have updated the Spanish Taxes dataset with the following modifications:
1. Remove C_TAX_ZONE records associated with 6 taxes
2. Remove the Country and To Country data from the C_Tax table of these 6 taxes
3. Added more Taxes with their new C_TAX_ZONE records.
We have applied this new dataset into a new client and everything works fine, however, if we use this dataset for updating an existing client the point 2 (remove the Country and To Country data from the C_Tax table of these 6 taxes) doesn't work. The old data is still there. |
| Steps To Reproduce | 1. Install the Spanish Taxes Module version 1.2.17 from the Central Repository (last stable version)
2. Create a new client and apply the Taxes dataset in the Initial Client Setup
3. Search "Importaciones 16%" tax at Financial Management || Accounting || Setup || Tax Rate. Check Country= USA and To Country=Spain
4. Install the 1.2.18 version from the provided .obx
5. Apply the dataset to the previous client through the Enterprise Module Management (Org *)
6. Search again the "Importaciones 16%" tax at Financial Management || Accounting || Setup || Tax Rate. Check Country= USA and Destination Country=Spain, which is wrong, these two fields should be empty.
7. Create a new client applying the 1.2.18 dataset.
8. Search again the "Importaciones 16%" tax at Financial Management || Accounting || Setup || Tax Rate. Check Country= NULL and Destination Country=NULL, which is OK. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | blocks | defect | 0014034 | | closed | psanjuan | Localization Pack: Spain | "Import" (Importaciones) related Tax Rates setup as both 0% tax rates and 18/16%-8/7%-4% to be used depending on the needs | | blocks | defect | 0014456 | | closed | vmromanos | Localization Pack: Spain | There are some taxes that have no countries defined in the tax zone tab. | | blocks | defect | 0014453 | | closed | vmromanos | Localization Pack: Spain | Wrong setup in Spanish Taxes reference data |
|
| Attached Files |  org.openbravo.localization.spain.referencedata.taxes-1.2.18.obx (279,277) 2010-09-01 17:39
https://issues.openbravo.com/file_download.php?file_id=3005&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2010-09-01 17:39 | vmromanos | New Issue | |
| 2010-09-01 17:39 | vmromanos | Assigned To | => alostale |
| 2010-09-01 17:39 | vmromanos | File Added: org.openbravo.localization.spain.referencedata.taxes-1.2.18.obx | |
| 2010-09-01 17:40 | vmromanos | Relationship added | blocks 0014034 |
| 2010-09-01 17:47 | rafaroda | Issue Monitored: rafaroda | |
| 2010-09-02 08:29 | alostale | Status | new => scheduled |
| 2010-09-02 08:29 | alostale | Assigned To | alostale => mtaal |
| 2010-09-02 08:29 | alostale | fix_in_branch | => pi |
| 2010-09-02 09:19 | mtaal | Note Added: 0030565 | |
| 2010-09-02 09:19 | mtaal | Status | scheduled => feedback |
| 2010-09-02 10:22 | vmromanos | Note Added: 0030575 | |
| 2010-09-02 10:22 | vmromanos | Status | feedback => new |
| 2010-09-06 08:10 | alostale | Status | new => scheduled |
| 2010-09-07 15:58 | networkb | fix_in_branch | pi => |
| 2010-09-07 15:58 | networkb | Issue Monitored: networkb | |
| 2010-09-07 16:29 | psanjuan | Relationship added | blocks 0014456 |
| 2010-09-07 16:29 | psanjuan | Relationship added | blocks 0014453 |
| 2010-09-09 13:41 | hgbot | Checkin | |
| 2010-09-09 13:41 | hgbot | Note Added: 0030897 | |
| 2010-09-09 13:41 | hgbot | Status | scheduled => resolved |
| 2010-09-09 13:41 | hgbot | Resolution | open => fixed |
| 2010-09-09 13:41 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/acf15c4cab5cfe2b47e2201f8b12eb336380da12 [^] |
| 2010-09-10 09:07 | hudsonbot | Checkin | |
| 2010-09-10 09:07 | hudsonbot | Note Added: 0030919 | |
| 2010-09-16 12:36 | marvintm | Note Added: 0031152 | |
| 2010-09-16 12:36 | marvintm | Status | resolved => closed |
| 2010-09-17 00:00 | anonymous | sf_bug_id | 0 => 3068051 |
|
Notes |
|
|
(0030565)
|
|
mtaal
|
|
2010-09-02 09:19
|
|
The import does normally not remove data. There is one case where data is removed. This is:
- when the data is child data and the parent and child exported together
- the parent is exported as a business object (see the isBusinessObject flag in the dataset_table), so when checking the xml you would see the hierarchical structure of the parent and childs in the xml
Then when such a xml gets imported then any removed child (not present anymore in the xml) should be removed from the database also.
gr. Martin |
|
|
|
|
Hi Martin,
The problem is not when removing the children data (C_TAX_ZONE). This is working fine using the IsBusinessObject flag.
The problem is that 2 columns of the C_Tax table remember its previous value instead of changing to the new one (NULL) |
|
|
|
(0030897)
|
|
hgbot
|
|
2010-09-09 13:41
|
|
|
|
|
|
|
|
|
|
|
Verified that the change fixed the issue (the countries are null after reapplying the dataset through the Enterprise Module Management) |
|