Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017490Openbravo ERP05. Production managementpublic2011-05-19 17:372011-06-08 17:19
Reportermaite 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP29 
Target Version2.50MP31Fixed in Version2.50MP31 
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
Summary0017490: 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
blocks defect 00172833.0MP1 closed jecharri Column CALCCOST does not allow decimals 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-06-03 12:16jecharriTypedefect => backport
2011-06-03 12:16jecharrifix_in_branch => 2.50
2011-06-07 12:33hgbotCheckin
2011-06-07 12:33hgbotNote Added: 0038112
2011-06-07 12:33hgbotStatusscheduled => resolved
2011-06-07 12:33hgbotResolutionopen => fixed
2011-06-07 12:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/a5db67d4c7974e469d34f84db9a759a8b0560b0b [^]
2011-06-08 17:19maiteNote Added: 0038176
2011-06-08 17:19maiteStatusresolved => closed
2011-06-08 17:19maiteFixed in Version => 2.50MP31

Notes
(0038112)
hgbot   
2011-06-07 12:33   
Repository: erp/stable/2.50
Changeset: a5db67d4c7974e469d34f84db9a759a8b0560b0b
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Fri Jun 03 13:22:09 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/a5db67d4c7974e469d34f84db9a759a8b0560b0b [^]

Fixes issue 17490: 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
---
(0038176)
maite   
2011-06-08 17:19   
verified