Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009884Openbravo ERP09. Financial managementpublic2009-07-09 17:532009-07-22 14:22
Reporternetworkb 
Assigned Tovmromanos 
PriorityimmediateSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP6 
Target VersionFixed in Version2.40MP8 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009884: columns in table C_TAXREGISTERLINE are wrong defined
Descriptionthree problems:

Columns TOTALAMT, TAXBASEAMT and TAXAMT belong C_TAXREGISTERLINE are wrong defined for two reasons:
 1. the lengths of this fields, in some cases are too small. when run process "create var register" error is returned:
ORA-01438 value larger than specified precision allowed for this column.

 2. the fields are defined like number(10), without decimals. They should be defined with decimals

Column DOCUMENTNO:
 3. It is defined in application dictionary like integer, but it should be String
Steps To Reproducewhen run "create var register" process in Financial Management || Receivables & Payables || Transactions || Tax Payment || Header:
in Tax Register Header:
 "Last Register Amount" and "tax total amount" fields dont have decimals
in lines:
 "taxable amount", "tax amount" and "total amount" fields dont have decimals
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009823 closed vmromanos columns in table C_TAXREGISTERLINE are wrong defined 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-14 09:02rafarodaTypedefect => backport
2009-07-14 09:02rafarodafix_in_branch => 2.40
2009-07-15 11:04vmromanosAssigned Toeduardo_Argal => vmromanos
2009-07-15 16:52vmromanosNote Added: 0018270
2009-07-16 14:30hgbotCheckin
2009-07-16 14:30hgbotNote Added: 0018321
2009-07-16 14:30hgbotStatusscheduled => resolved
2009-07-16 14:30hgbotResolutionopen => fixed
2009-07-16 14:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/d40541661c15e2747af89f9b6c76e66c7183ce8d [^]
2009-07-22 14:22sureshbabuStatusresolved => closed
2009-07-22 14:22sureshbabuNote Added: 0018558
2009-07-22 14:22sureshbabuFixed in Version => 2.40MP8

Notes
(0018270)
vmromanos   
2009-07-15 16:52   
Pending the push to the branch since 2.40 is currently frozen
(0018321)
hgbot   
2009-07-16 14:30   
Repository: erp/stable/2.40
Changeset: d40541661c15e2747af89f9b6c76e66c7183ce8d
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Jul 15 16:48:52 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/d40541661c15e2747af89f9b6c76e66c7183ce8d [^]

Fixed bug 9884: columns in table C_TAXREGISTERLINE are wrong defined

---
M src-db/database/model/tables/C_TAXREGISTER.xml
M src-db/database/model/tables/C_TAXREGISTERLINE.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0018558)
sureshbabu   
2009-07-22 14:22   
Tested working as expected.