0036005: Wrong cost for produced product in a work effort if the consumed product has duplicated cost entry - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0036005

Openbravo ERP

04. Warehouse management

public

2017-05-16 11:36

2017-06-08 17:12

Reporter

ngarcia

Assigned To

collazoandy4

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Target Version

Fixed in Version

3.0PR17Q3

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

46778

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0036005: Wrong cost for produced product in a work effort if the consumed product has duplicated cost entry

Description

Wrong cost for produced product in a work effort if the consumed product has duplicated cost entry.

Duplicated costs can be obtained manually but also when a product do not set as production is received in two warehouses and the costing rule is configured with WH dimension and the product is then consumed in a work effort

Steps To Reproduce

As group admin role:
   Create two products, set them as production
   Set the storage bin in the Manufacturing tab to the produced one
   Add two manual costs to the consumed one:
      Starting Date: today
      Ending Date: 31-12-9999
   Increase the stock of the consumed one
   Create a Manufacturing Cost Center and Version
   Create an Activity associated to it
   Create a Process Plan, Version and Operation
   Assign the previously created activity to it
   Add the previously created products to it: one as P+ and the other one as P-
   Create a Work Requirement from the Process Plan
   Create a Work Effort from the Work Requirement
   Validate it
   Launch the Costing Background Process
   Check the two costs of the consumed product were taken into account for calculating the cost of the produced one

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to

defect

0036008

closed

collazoandy4

It is possible to add not production products in work efforts

Attached Files

Issue History

Date Modified

Username

Field

Change

2017-05-16 11:36

New Issue

2017-05-16 11:36

Assigned To

=> Triage Finance

2017-05-16 11:36

OBNetwork customer

=> Yes

2017-05-16 11:36

Modules

=> Core

2017-05-16 11:36

Support ticket

=> 46778

2017-05-16 11:36

Resolution time

=> 1496700000

2017-05-16 11:36

Triggers an Emergency Pack

=> No

2017-05-16 11:36

Issue Monitored: networkb

2017-05-16 13:02

Relationship added

related to 0036008

2017-05-17 13:36

Assigned To

Triage Finance => collazoandy4

2017-05-26 00:05

collazoandy4

Status

new => scheduled

2017-06-03 02:15

collazoandy4

Note Added: 0097117

2017-06-05 18:34

Checkin

2017-06-05 18:34

Note Added: 0097143

2017-06-05 18:34

Status

scheduled => resolved

2017-06-05 18:34

Resolution

open => fixed

2017-06-05 18:34

Fixed in SCM revision

=> http://code.openbravo.com/erp/devel/pi/rev/042fe61f85f7f180dc2967a5554cb22a1dbcd2b0 [^]

2017-06-05 18:35

Review Assigned To

=> aferraz

2017-06-05 18:35

Note Added: 0097146

2017-06-05 18:35

Status

resolved => closed

2017-06-05 18:35

Fixed in Version

=> 3.0PR17Q3

2017-06-08 17:12

Checkin

2017-06-08 17:12

Note Added: 0097242

Notes

Test Plan
Go to Product window and create a new record:
   Search Key/Name: Consume
   Check Production field
   Create a new record in Costing tab:
     Cost Type: Standard
     Cost: 10
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
    Create a new record in Costing tab:
     Cost Type: Average
     Cost: 20
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
    Create a new record in Costing tab:
     Cost Type: Average
     Cost: 30
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
  In Product window create a new record:
    Search Key/Name: Produced
    Check Production field
    Create a new record in Manufacturing tab:
      Storage Bin: Rn-0-0-0
  Go to Physical Inventory and create a new record:
    Movement Date: Today
    Create a new record in Lines tab:
      Product: Consume
      Quantity count: 500
    Process inventory count
  Go to Manufacturing Cost Center and create a new record:
    Search Key/Name: Issue Cost Center
    Create a new record in Version tab:
      Valid From Date: Today
  Go to Activity window and create a new record:
    Search Key/Name: Issue Activity
    Cost Center: Issue Cost Center
  Go to Process Plan window and create a new record:
    Search Key/Name: Issue Plan
    Create a new record in Version Tab:
      Starting Date: 01-05-2017
      Ending Date: 01-05-2099
      Create a new record in Operation tab:
        Search Key/Name: Issue Operation
        Activity: Issue Activity
        Create a new record in I/O Products tab:
          Product: Consume
          Production Type: Product use (P-)
          Quantity: 5
        Create a new record in I/O Products tab:
          Product: Produced
          Production Type: Product Production (P+)
          Quantity: 1
  Go to Work Requirement window and create a new record:
      Process Plan: Issue Plan
      Starting Date: 01-05-2017
    Ending Date: 01-05-2099
    Quantity: 50
    Process the requirement
    Clic on Create a Work Effort button
      Date: Today
  Go to Production Run window and edit the previous production created:
    Completed Quantity: 1
    Clic on Create Standard button
  Go to Work Effort window and validate the previous one created
  Launch the Costing Background Process and check that the min consume product cost was used for the produced product cost