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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0017283
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajoralways2011-05-19 17:372011-06-08 17:35
ReportermaiteView Statuspublic 
Assigned Tojecharri 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision8b5871a00062
ProjectionnoneETAnoneTarget Version3.0MP1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00174902.50MP31 closeddalsasua Column CALCCOST does not allow decimals 
related to defect 0017495 closedjecharri try-2.50-api and try-api has failed because one column has been change 

-  Notes
(0038043)
iciordia (manager)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2011-06-08 17:35

verified

- Issue History
Date Modified Username Field Change
2011-05-19 17:37 maite New Issue
2011-05-19 17:37 maite Assigned To => adrianromero
2011-05-19 17:37 maite Modules => Core
2011-05-19 17:49 maite Issue Monitored: networkb
2011-06-03 10:57 dalsasua Assigned To adrianromero => dalsasua
2011-06-03 12:16 jecharri Status new => scheduled
2011-06-03 12:16 jecharri Assigned To dalsasua => jecharri
2011-06-03 12:16 jecharri fix_in_branch => pi
2011-06-03 12:17 jecharri version 2.50MP29 => pi
2011-06-03 12:17 jecharri Target Version 2.50MP31 => 3.0MP1
2011-06-03 12:17 jecharri fix_in_branch pi =>
2011-06-06 15:28 iciordia Note Added: 0038043
2011-06-07 11:11 jecharri Relationship added related to 0017495
2011-06-07 12:30 hgbot Checkin
2011-06-07 12:30 hgbot Note Added: 0038106
2011-06-07 12:30 hgbot Status scheduled => resolved
2011-06-07 12:30 hgbot Resolution open => fixed
2011-06-07 12:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8b5871a000626213dba600ebd44883bf6eb5d4d6 [^]
2011-06-07 12:31 hgbot Checkin
2011-06-07 12:31 hgbot Note Added: 0038109
2011-06-07 12:34 hgbot Checkin
2011-06-07 12:34 hgbot Note Added: 0038114
2011-06-08 17:35 maite Note Added: 0038179
2011-06-08 17:35 maite Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker