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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009884
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajorsometimes2009-07-09 17:532009-07-22 14:22
ReporternetworkbView Statuspublic 
Assigned Tovmromanos 
PriorityimmediateResolutionfixedFixed in Version2.40MP8
StatusclosedFix in branch2.40Fixed in SCM revisiond40541661c15
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.40MP6SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009884: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0009823 closedvmromanos columns in table C_TAXREGISTERLINE are wrong defined 

-  Notes
(0018270)
vmromanos (manager)
2009-07-15 16:52

Pending the push to the branch since 2.40 is currently frozen
(0018321)
hgbot (developer)
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 (reporter)
2009-07-22 14:22

Tested working as expected.

- Issue History
Date Modified Username Field Change
2009-07-14 09:02 rafaroda Type defect => backport
2009-07-14 09:02 rafaroda fix_in_branch => 2.40
2009-07-15 11:04 vmromanos Assigned To eduardo_Argal => vmromanos
2009-07-15 16:52 vmromanos Note Added: 0018270
2009-07-16 14:30 hgbot Checkin
2009-07-16 14:30 hgbot Note Added: 0018321
2009-07-16 14:30 hgbot Status scheduled => resolved
2009-07-16 14:30 hgbot Resolution open => fixed
2009-07-16 14:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/d40541661c15e2747af89f9b6c76e66c7183ce8d [^]
2009-07-22 14:22 sureshbabu Status resolved => closed
2009-07-22 14:22 sureshbabu Note Added: 0018558
2009-07-22 14:22 sureshbabu Fixed in Version => 2.40MP8


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker