Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0017283 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 05. Production management | major | always | 2011-05-19 17:37 | 2011-06-08 17:35 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | jecharri | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 8b5871a00062 | ||||
| Projection | none | ETA | none | Target Version | 3.0MP1 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0017283: Column CALCCOST does not allow decimals | |||||||
| Description | Column CALCCOST does not allow decimals. It is defined as numeric(10,0) in database. | |||||||
| Steps To Reproduce | 1. 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 Solution | column CALCCOST in tables MA_SEQUENCE_* should be defined to allow decimales. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0038043) iciordia (viewer) 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 (viewer) 2011-06-08 17:35 |
verified |
|
Notes |
|
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:37 | maite | OBNetwork customer | => Yes |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |