Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009823Openbravo ERP09. Financial managementpublic2009-07-09 17:532009-07-18 00:00
Reporternetworkb 
Assigned Tovmromanos 
PriorityimmediateSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP6 
Target VersionFixed in Version 
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
Summary0009823: 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
depends on backport 0009884 closed vmromanos columns in table C_TAXREGISTERLINE are wrong defined 
related to defect 0009923 closed pjuvara API check: build 81 fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-09 17:53networkbNew Issue
2009-07-09 17:53networkbAssigned To => rafaroda
2009-07-09 17:53networkbOBNetwork customer => Yes
2009-07-10 10:19pjuvaraNote Added: 0018077
2009-07-10 10:19pjuvaraStatusnew => feedback
2009-07-10 10:55networkbversion => 2.40MP6
2009-07-10 10:55networkbTarget Version2.40MP6 =>
2009-07-10 16:44pjuvaraStatusfeedback => new
2009-07-13 09:31rafarodaNote Added: 0018149
2009-07-13 09:31rafarodaAssigned Torafaroda => mtaal
2009-07-13 09:36mtaalNote Added: 0018150
2009-07-13 09:36mtaalAssigned Tomtaal => rafaroda
2009-07-14 09:02rafarodaAssigned Torafaroda => eduardo_Argal
2009-07-14 09:02rafarodaStatusnew => scheduled
2009-07-14 09:02rafarodafix_in_branch => pi
2009-07-15 11:04vmromanosAssigned Toeduardo_Argal => vmromanos
2009-07-15 14:18hgbotCheckin
2009-07-15 14:18hgbotNote Added: 0018260
2009-07-15 14:18hgbotStatusscheduled => resolved
2009-07-15 14:18hgbotResolutionopen => fixed
2009-07-15 14:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5ce40ea258729e4174f29002a3a5b5d248bead57 [^]
2009-07-16 10:50shuehnerRelationship addedrelated to 0009923
2009-07-17 13:35plujanStatusresolved => closed
2009-07-18 00:00anonymoussf_bug_id0 => 2823355

Notes
(0018077)
pjuvara   
2009-07-10 10:19   
Please specify product version.
(0018149)
rafaroda   
2009-07-13 09:31   
Martin, could you please inform about the problems that could arise in pi (because of DAL) and in 2.40 by a change in the type of a column of a table?

Thanks.
(0018150)
mtaal   
2009-07-13 09:36   
Hi Rafa,
I do not expect problems for the DAL and the xml import. generate.entities needs to be rerun but that's it afaics. This because afaics the changes in format are backwards compatible (a decimal field can be filled from a integer number and the same for documentno from integer to string).

gr. Martin
(0018260)
hgbot   
2009-07-15 14:18   
Repository: erp/devel/pi
Changeset: 5ce40ea258729e4174f29002a3a5b5d248bead57
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Jul 15 14:15:17 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5ce40ea258729e4174f29002a3a5b5d248bead57 [^]

Fixed bug 9823: 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
---