Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012339Openbravo ERP00. Application dictionarypublic2010-02-18 15:572010-05-18 21:44
Reporternetworkb 
Assigned Tosivaraman 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP17Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012339: Rate column is not properly defined. It is not possible to use decimals
DescriptionC_Withholding table, has rate column that is defined as following:

  rate numeric(10) DEFAULT 0,


It should be defined as NUMERIC
Steps To ReproduceGo To Master Data Management > Business Partner management > Withholding.
create a new register.
Enter as rate 0.5
Proposed Solutionalter table c_withholding alter column rate type numeric
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0011333 closed adrianromero Withholding rate is rounded to a integer 
related to defect 0013261 closed sivaraman api check build 380 fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-18 15:57nataliaperuNew Issue
2010-02-18 15:57nataliaperuAssigned To => alostale
2010-02-22 08:20alostaleAssigned Toalostale => adrianromero
2010-03-15 11:47networkbRelationship addedhas duplicate 0011333
2010-03-15 11:51networkbTarget Version => 2.50MP16
2010-03-15 11:51networkbReporternataliaperu => networkb
2010-03-17 17:43adrianromeroStatusnew => scheduled
2010-03-17 17:43adrianromerofix_in_branch => pi
2010-05-07 06:13sivaramanAssigned Toadrianromero => sivaraman
2010-05-07 06:19hgbotCheckin
2010-05-07 06:19hgbotNote Added: 0027017
2010-05-07 06:19hgbotStatusscheduled => resolved
2010-05-07 06:19hgbotResolutionopen => fixed
2010-05-07 06:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/70835b3169e818cba271a9dd3284b3f306687b22 [^]
2010-05-07 11:32shuehnerRelationship addedrelated to 0013261
2010-05-11 18:19jpabloaeTarget Version2.50MP16 => 2.50MP17
2010-05-12 09:26arunkumarNote Added: 0027161
2010-05-12 09:26arunkumarStatusresolved => closed
2010-05-13 00:00anonymoussf_bug_id0 => 3000764
2010-05-18 21:44hudsonbotCheckin
2010-05-18 21:44hudsonbotNote Added: 0027492

Notes
(0027017)
hgbot   
2010-05-07 06:19   
Repository: erp/devel/pi
Changeset: 70835b3169e818cba271a9dd3284b3f306687b22
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Fri May 07 09:48:33 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/70835b3169e818cba271a9dd3284b3f306687b22 [^]

Fixes issue 12339: Rate column is not properly defined. It is not possible to use decimals

---
M src-db/database/model/tables/C_WITHHOLDING.xml
---
(0027161)
arunkumar   
2010-05-12 09:26   
Tested Working fine
(0027492)
hudsonbot   
2010-05-18 21:44   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/70835b3169e8 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]