Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017283Openbravo ERP05. Production managementpublic2011-05-19 17:372011-06-08 17:35
Reportermaite 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP1Fixed 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
Summary0017283: Column CALCCOST does not allow decimals
DescriptionColumn CALCCOST does not allow decimals. It is defined as numeric(10,0) in database.

Steps To Reproduce1. Define Machine. Add Cost 1.33 per Hour
2. Define Indirect Cost: type Poduction; Add Value from 01-05-2011 to 01-05-2011 ; cost 0.85 and per Hour
3. Define Cost Center. Add Version with Cost empty; uom perHour; valid from 01-05-2011 . Add Machine created with UsageCoeficient=1. Add Indirect Cost created
4. Define Activity and associate Cost Center created
5. Go to Product window and mark 2 products as "Production"
6. Define Process Plan. Add Version from 01-05-2011 to 12-12-9999. Add Operation setting your Activity ; Cost center use time=1; Multiplier=1.
Add IOProducts: one as P- and another one as P+
7. Run process Calculate Standard Cost

Navigate to tab Machine and Indirect cost of your process plan and realize that cost is set to 1 (instead of 1.33 and 0.85) as it is not allowing decimals
Proposed Solutioncolumn CALCCOST in tables MA_SEQUENCE_* should be defined to allow decimales.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00174902.50MP31 closed dalsasua Column CALCCOST does not allow decimals 
related to defect 0017495 closed jecharri try-2.50-api and try-api has failed because one column has been change 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-19 17:37maiteNew Issue
2011-05-19 17:37maiteAssigned To => adrianromero
2011-05-19 17:37maiteModules => Core
2011-05-19 17:49maiteIssue Monitored: networkb
2011-06-03 10:57dalsasuaAssigned Toadrianromero => dalsasua
2011-06-03 12:16jecharriStatusnew => scheduled
2011-06-03 12:16jecharriAssigned Todalsasua => jecharri
2011-06-03 12:16jecharrifix_in_branch => pi
2011-06-03 12:17jecharriversion2.50MP29 => pi
2011-06-03 12:17jecharriTarget Version2.50MP31 => 3.0MP1
2011-06-03 12:17jecharrifix_in_branchpi =>
2011-06-06 15:28iciordiaNote Added: 0038043
2011-06-07 11:11jecharriRelationship addedrelated to 0017495
2011-06-07 12:30hgbotCheckin
2011-06-07 12:30hgbotNote Added: 0038106
2011-06-07 12:30hgbotStatusscheduled => resolved
2011-06-07 12:30hgbotResolutionopen => fixed
2011-06-07 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8b5871a000626213dba600ebd44883bf6eb5d4d6 [^]
2011-06-07 12:31hgbotCheckin
2011-06-07 12:31hgbotNote Added: 0038109
2011-06-07 12:34hgbotCheckin
2011-06-07 12:34hgbotNote Added: 0038114
2011-06-08 17:35maiteNote Added: 0038179
2011-06-08 17:35maiteStatusresolved => closed

Notes
(0038043)
iciordia   
2011-06-06 15:28   
Approved. But please confirm with a note in this issue that the DAL methods to access those columns have not changed.

Ismael
(0038106)
hgbot   
2011-06-07 12:30   
Repository: erp/devel/pi
Changeset: 8b5871a000626213dba600ebd44883bf6eb5d4d6
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Fri Jun 03 13:23:17 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8b5871a000626213dba600ebd44883bf6eb5d4d6 [^]

Fixes issue 17283: Column CALCCOST does not allow decimals

---
M src-db/database/model/tables/MA_SEQUENCE_EMPLOYEE.xml
M src-db/database/model/tables/MA_SEQUENCE_IC.xml
M src-db/database/model/tables/MA_SEQUENCE_MACHINE.xml
---
(0038109)
hgbot   
2011-06-07 12:31   
Repository: erp/devel/api-checks
Changeset: 363b15de0901cc585efeb400f2d11962427873d0
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Jun 07 12:28:46 2011 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/363b15de0901cc585efeb400f2d11962427873d0 [^]

Fixes issue 17495.
Tested database model changed according to fix to issue 17283

---
M model/src-db/database/model/tables/MA_SEQUENCE_EMPLOYEE.xml
M model/src-db/database/model/tables/MA_SEQUENCE_IC.xml
M model/src-db/database/model/tables/MA_SEQUENCE_MACHINE.xml
---
(0038114)
hgbot   
2011-06-07 12:34   
Repository: erp/stable/api-checks-2.50
Changeset: d05d1565ed87e1fb54b6048ded00b2148ba68539
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Jun 07 12:25:33 2011 +0200
URL: http://code.openbravo.com/erp/stable/api-checks-2.50/rev/d05d1565ed87e1fb54b6048ded00b2148ba68539 [^]

Fixes Issue 17532.
Tested database model changed according to fix to issue 17283

---
M model/model/tables/MA_SEQUENCE_EMPLOYEE.xml
M model/model/tables/MA_SEQUENCE_IC.xml
M model/model/tables/MA_SEQUENCE_MACHINE.xml
---
(0038179)
maite   
2011-06-08 17:35   
verified