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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0046260
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo Localizations] Localization Portugalmajoralways2021-04-13 15:402021-09-22 12:07
ReporterpsanjuanView Statuspublic 
Assigned Tomarkmm82 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version7.x
OS VersionOpenbravo Appliance 14.04Database version9.3.xAnt version1.9.x
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Regression introduced in release
Summary

0046260: Wrong region code for Açores and Madeira regions. Rest of regions need to have the code PT

DescriptionWrong region code for Açores and Madeira regions. ISO code is required by PT SAFT file.
Steps To ReproduceN/A
Proposed SolutionCorrect search key or value for below listed PT regions is:

Madeira = MA
Acores = AC

Rest of Regions should have as search key the value "PT", as that is the country ISO code of Portugal, validated in SAFT file.

This change needs to be done in the module Portuguese Regions:

https://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Portuguese-Regions [^]
TagsNOR
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0046262 closedmarkmm82 SAFT code must export the region search key if a tax rate has a region setup 
related to feature request 0046264 closedcaristu New taxes need to be created in the PT taxes dataset 

-  Notes
(0127395)
hgbot (developer)
2021-04-20 17:03

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.portugal.regions/-/merge_requests/1 [^]
(0127396)
markmm82 (developer)
2021-04-20 17:10

Test Plan:

Go to Country and Regions window.
Filter by Portugal Search Key = PT
Go to Regions tab.
Notice all te regions have "PT" as search key, except Madeira and Acores that have the following information:
  Madeira = MA
  Acores = AC
(0127487)
hgbot (developer)
2021-04-23 08:34

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.portugal.regions/-/merge_requests/1 [^]
(0127488)
hgbot (developer)
2021-04-23 08:34

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.portugal.regions [^]
Changeset: 3feb9d55ee5487d354f000abeb93da16da3a1f8d
Author: Mark Orlando Molina <markmm82@gmail.com>
Date: 2021-04-23T06:34:15+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.portugal.regions/-/commit/3feb9d55ee5487d354f000abeb93da16da3a1f8d [^]

Fixes BUG-46260: Fixed Portugal region search keys

---
M referencedata/standard/Portuguese_Regions.xml
M src-db/database/sourcedata/AD_DATASET.xml
---
(0127489)
psanjuan (manager)
2021-04-23 09:24

Query below will have to be executed for existing customer enviroments as Country/Region dataset is a system dataset which can only be applied through "install.source" process.
(0127501)
markmm82 (developer)
2021-04-23 14:18

Query to update Portugal regions manually:
update c_region set value = 'PT' where c_country_id='281' and name not in ('Açores', 'Madeira');

- Issue History
Date Modified Username Field Change
2021-04-13 15:40 psanjuan New Issue
2021-04-13 15:40 psanjuan Assigned To => psanjuan
2021-04-13 15:40 psanjuan Assigned To psanjuan => Triage Finance
2021-04-13 15:54 psanjuan Proposed Solution updated
2021-04-13 15:56 psanjuan Description Updated View Revisions
2021-04-13 15:56 psanjuan Proposed Solution updated
2021-04-13 15:58 psanjuan Proposed Solution updated
2021-04-13 17:56 vmromanos Assigned To Triage Finance => markmm82
2021-04-14 08:55 maite Resolution time => 1620165600
2021-04-14 09:05 rafaroda Tag Attached: NOR
2021-04-14 09:05 rafaroda Issue Monitored: rafaroda
2021-04-14 10:31 maite Issue Monitored: maite
2021-04-20 14:01 psanjuan Proposed Solution updated
2021-04-20 14:07 psanjuan Relationship added related to 0046262
2021-04-20 16:19 markmm82 Status new => scheduled
2021-04-20 17:03 hgbot Note Added: 0127395
2021-04-20 17:10 markmm82 Note Added: 0127396
2021-04-23 08:34 hgbot Resolution open => fixed
2021-04-23 08:34 hgbot Note Added: 0127487
2021-04-23 08:34 hgbot Status scheduled => closed
2021-04-23 08:34 hgbot Note Added: 0127488
2021-04-23 09:24 psanjuan Note Added: 0127489
2021-04-23 14:18 markmm82 Note Added: 0127501
2021-09-22 12:07 psanjuan Summary Wrong region code for Açores and Madeira regions => Wrong region code for Açores and Madeira regions. Rest of regions need to have the code PT
2021-09-22 12:16 rafaroda Relationship added related to 0046264


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker