Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0026844 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 05. Production management | major | always | 2014-06-11 16:22 | 2014-08-19 20:18 | |||
| Reporter | ngarcia | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | f042a64ea3c7 | |||
| Projection | none | ETA | none | Target Version | 3.0PR14Q4 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | AtulOpenbravo | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0026844: Standard cost is not taken into account for not stocked products consumed in a work effort | |||||||
| Description | Standard cost is not taken into account for not stocked products consumed in a work effort | |||||||
| Steps To Reproduce | As group admin role: Create a product and set it as: Production: Y Stocked: N Assign a cost to it: Cost Type: Standard Cost Starting date: today Ending Date: 31-12-9999 Manual: Y Permanent: Y Assign a Storage Bin in the Manufacturing tab Create a Manufacturing Cost Center Create an Activity and assign that Cost Center Create a Process Plan, Version and Operation Add the previously created product as P- and another product as P+ Assign the previously created Activity Create a Work Requirement for the Process Plan Process it and create a Work Effort Check the Cost Center Version has been assigned in the Production Run (assign it if not) Validate it Run the Costing Background process and check the following error is raised: "java.lang.IllegalStateException: org.postgresql.util.PSQLException: ERROR: No average cost found for given product and date..." If you change the Cost Type to Average in the Product - Costing tab, the cost will be calculated correctly | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0069116) rafaroda (developer) 2014-08-07 15:24 |
Selection of the costing method in MA_PRODUCTION_COST procedure will be the following. If costing logic is NOT migrated to the newest version: * Look for Average or Standard Cost: c.COSTTYPE IN ('AV','ST') AND v_iscostmigrated = 'N' If costing logic is migrated to the newest version: * If product is item and is stocked, select Average: CASE WHEN (SELECT COUNT(1) FROM M_PRODUCT WHERE M_PRODUCT_ID = ppl.M_PRODUCT_ID AND PRODUCTTYPE = 'I' AND ISSTOCKED = 'Y') > 0 THEN 'AVA' * Else, select Standard: ELSE 'STA' |
|
(0069384) hgbot (developer) 2014-08-15 08:42 |
Repository: erp/devel/pi Changeset: f042a64ea3c70ce56eb9ec2c69bb5dbd4e2e77c5 Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com> Date: Thu Aug 14 14:22:55 2014 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/f042a64ea3c70ce56eb9ec2c69bb5dbd4e2e77c5 [^] Fixes issue 26844 Modified MA_PRODUCTION_COST to select the correct costing method in production --- M src-db/database/model/functions/MA_PRODUCTION_COST.xml --- |
|
(0069451) hudsonbot (developer) 2014-08-18 01:58 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ed428d44c18c [^] Maturity status: Test |
|
(0069527) AtulOpenbravo (developer) 2014-08-19 20:18 |
Verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-06-11 16:22 | ngarcia | New Issue | |
| 2014-06-11 16:22 | ngarcia | Assigned To | => jonalegriaesarte |
| 2014-06-11 16:22 | ngarcia | Modules | => Core |
| 2014-06-11 16:22 | ngarcia | Resolution time | => 1405375200 |
| 2014-06-11 16:22 | ngarcia | Triggers an Emergency Pack | => No |
| 2014-06-11 18:24 | jonalegriaesarte | Assigned To | jonalegriaesarte => pramakrishnan |
| 2014-06-16 12:48 | jonalegriaesarte | Target Version | PR14Q3 => PR14Q4 |
| 2014-07-28 11:22 | ngarcia | Steps to Reproduce Updated | View Revisions |
| 2014-07-28 11:22 | ngarcia | Issue Monitored: networkb | |
| 2014-07-28 12:08 | ngarcia | Steps to Reproduce Updated | View Revisions |
| 2014-07-28 12:40 | rafaroda | Status | new => scheduled |
| 2014-07-28 12:40 | rafaroda | Assigned To | pramakrishnan => rafaroda |
| 2014-07-28 12:40 | rafaroda | fix_in_branch | => pi |
| 2014-08-07 15:24 | rafaroda | Note Added: 0069116 | |
| 2014-08-15 08:42 | hgbot | Checkin | |
| 2014-08-15 08:42 | hgbot | Note Added: 0069384 | |
| 2014-08-15 08:42 | hgbot | Status | scheduled => resolved |
| 2014-08-15 08:42 | hgbot | Resolution | open => fixed |
| 2014-08-15 08:42 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/f042a64ea3c70ce56eb9ec2c69bb5dbd4e2e77c5 [^] |
| 2014-08-18 01:58 | hudsonbot | Checkin | |
| 2014-08-18 01:58 | hudsonbot | Note Added: 0069451 | |
| 2014-08-19 20:18 | AtulOpenbravo | Review Assigned To | => AtulOpenbravo |
| 2014-08-19 20:18 | AtulOpenbravo | Note Added: 0069527 | |
| 2014-08-19 20:18 | AtulOpenbravo | Status | resolved => closed |
| 2014-08-19 20:18 | AtulOpenbravo | Fixed in Version | => pi |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |