Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027313Openbravo ERP02. Master data managementpublic2014-08-12 09:372015-03-09 17:49
Reporterjonalegriaesarte 
Assigned Toreinaldoguerra 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q2Fixed in Version 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket30368
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027313: D-U-N-S number should not be mandatory
DescriptionD-U-N-S number should not be mandatory, because is something that is not used in all the goberments/companies
Steps To ReproduceD-U-N-S number should not be mandatory, because is something that is not used in all the goberments/companies. Now we are adding (in demo data, F&B) ? character when the number is not needed, but this does not make sense. If the field is not needed, it should be empty.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0028283 closed aferraz API Change Request : Change DUNS field in Organization Information to Non Mandatory 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-12 09:37jonalegriaesarteNew Issue
2014-08-12 09:37jonalegriaesarteAssigned To => dmiguelez
2014-08-12 09:37jonalegriaesarteOBNetwork customer => Yes
2014-08-12 09:37jonalegriaesarteModules => Core
2014-08-12 09:37jonalegriaesarteSupport ticket => 30368
2014-08-12 09:37jonalegriaesarteResolution time => 1410732000
2014-08-12 09:37jonalegriaesarteTriggers an Emergency Pack => No
2014-08-12 09:39jonalegriaesarteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6256#r6256
2014-09-29 16:12jonalegriaesarteTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-10-31 13:09dmitry_mezentsevAssigned Todmiguelez => Sandrahuguet
2014-11-08 06:21reinaldoguerraAssigned ToSandrahuguet => reinaldoguerra
2014-11-08 06:21reinaldoguerraStatusnew => scheduled
2014-11-11 02:52reinaldoguerraNote Added: 0071539
2014-11-26 06:57pramakrishnanRelationship addeddepends on 0028283
2014-12-29 16:08SandrahuguetTarget Version3.0PR15Q1 => 3.0PR15Q2
2015-03-09 11:10hgbotCheckin
2015-03-09 11:10hgbotNote Added: 0075302
2015-03-09 11:10hgbotStatusscheduled => resolved
2015-03-09 11:10hgbotResolutionopen => fixed
2015-03-09 11:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7a7adf930de6ea8c2e5ea21db67de00788dcf21c [^]
2015-03-09 11:10hgbotCheckin
2015-03-09 11:10hgbotNote Added: 0075303
2015-03-09 11:44aferrazReview Assigned To => aferraz
2015-03-09 11:44aferrazNote Added: 0075306
2015-03-09 11:44aferrazStatusresolved => closed
2015-03-09 17:49hudsonbotCheckin
2015-03-09 17:49hudsonbotNote Added: 0075335
2015-03-09 17:49hudsonbotCheckin
2015-03-09 17:49hudsonbotNote Added: 0075336

Notes
(0071539)
reinaldoguerra   
2014-11-11 02:52   
Test plan used:
1- Login into Openbravo ERP
2- Go to Organization window
3- Select one record for example: F&B España - Región Norte
4- Go to information tab and realize that D-U-N-S number is not a mandatory field.
5- Change actual value (?) to an empty value.
6- Now it is possible to save record.
(0075302)
hgbot   
2015-03-09 11:10   
Repository: erp/devel/pi
Changeset: 7a7adf930de6ea8c2e5ea21db67de00788dcf21c
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Fri Nov 07 23:24:39 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/7a7adf930de6ea8c2e5ea21db67de00788dcf21c [^]

Fixed bug 27313: D-U-N-S number should not be mandatory

D-U-N-S number column in organization's information table was changed to non mandatory.
Now when introducing data in organization's information tab it is not necessary to fill D-U-N-S number as it is something that is not used in all the goberments/companies.

---
M src-db/database/model/tables/AD_ORGINFO.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0075303)
hgbot   
2015-03-09 11:10   
Repository: erp/devel/pi
Changeset: 17996ec1f87f664e45e518bffdf6961ba9ba7106
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Mar 03 18:19:16 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/17996ec1f87f664e45e518bffdf6961ba9ba7106 [^]

Related to bug 27313: Duns field in AD_ORGINFO will not be filled automatically

AD_ORG_TRG trigger has been modified in order not to set automatically '?' value to duns column in AD_ORGINFO table

---
M src-db/database/model/triggers/AD_ORG_TRG.xml
---
(0075306)
aferraz   
2015-03-09 11:44   
Code review + Testing OK
(0075335)
hudsonbot   
2015-03-09 17:49   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ef8a16dd11b3 [^]
Maturity status: Test
(0075336)
hudsonbot   
2015-03-09 17:49   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ef8a16dd11b3 [^]
Maturity status: Test