Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0035740Openbravo ERP05. Production managementpublic2017-04-10 11:382017-05-29 17:43
VictorVillar 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
 
3.0PR17Q3 
aferraz
Core
No
0035740: Traceability Report does not show any information related with Production
Traceability Report does not show any information related with Production
0. Create Show MRP and Production fields preference.

1. Product window: create 2 Products for raw materials and final products.
                  a. Production checkbox selected.
    b. For Raw materials the Purchase flag should be checked. For final products the purchase checkbox not selected. Both should have attributes defined (Lot)
Manufacturing tab: add a new register for organization España Región Norte and select a Bin for the Final Product.

 2. Manufacturing Cost Center window:
Create new record,
select US in the organization field,
 type search key and name.

3. Activity window, to configure the Production Activities:
- Create new record, selecting US in the organization field.
- Select the cost center required,
- Type search key and name.

4. Process Plan window: create the process Plan by typing Process Plan in the quick launch menu and create new record:
Select US in Organization
type search key and name
Process unit and Conversion rate
4.a. Version tab: create a version for the Process Plan with starting and ending date
4.b. Operations tab: create the operations needed for the Process Plan.
Create one record defining the sequence of the Process Plan.
type search key and name.
Select the activity.
Check Create Standards
4.c. I/O Products tab: input-output of the products of the sequence.
Create a new record and select Product
Production Type (if product is consumed P- or produced P+ in the production process)
Quantity needed.

5. Product window: for the Final Products it is necessary to select the Process Plan created for the corresponding product.

6. Work Requirement window:
Create new record,
select España Región Norte in the organization field
Select quantity, creation date, starting date, ending date
Select the Process Plan that this work requirement refers to
Press Process Work Requirement button and the information from the Process Plan will be inserted

Create Work Effort

7.- Work Effort window:
select the Work Effort previously created, add the Lot for the Final Product and Validate the Work Effort.

Launch the Traceability report (either incoming or outgoing) and select the Final Product and the attribute.

No information appears.
No tags attached.
related to defect 0035540 closed alostale Traceability Report does not work 
related to defect 0024875 new jonalegriaesarte documentation for traceability report 
related to defect 0036020 closed AtulOpenbravo Necessary to show properly the column names in the Traceability report 
Issue History
2017-04-10 11:38VictorVillarNew Issue
2017-04-10 11:38VictorVillarAssigned To => Triage Finance
2017-04-10 11:38VictorVillarModules => Core
2017-04-10 11:38VictorVillarResolution time => 1494367200
2017-04-10 11:38VictorVillarTriggers an Emergency Pack => No
2017-04-25 14:16aferrazSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15050#r15050
2017-04-25 18:42aferrazRelationship addedrelated to 0035540
2017-04-25 18:43aferrazRelationship addedrelated to 0024875
2017-04-25 19:06aferrazAssigned ToTriage Finance => AtulOpenbravo
2017-04-25 19:57AtulOpenbravoStatusnew => scheduled
2017-04-28 08:26AtulOpenbravoNote Added: 0096247
2017-05-02 18:09hgbotCheckin
2017-05-02 18:09hgbotNote Added: 0096323
2017-05-02 18:09hgbotStatusscheduled => resolved
2017-05-02 18:09hgbotResolutionopen => fixed
2017-05-02 18:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e21ff3363f1ee32a3479b6168b3c8617ea3aa2e9 [^]
2017-05-02 18:11aferrazReview Assigned To => aferraz
2017-05-02 18:11aferrazNote Added: 0096324
2017-05-02 18:11aferrazStatusresolved => closed
2017-05-02 18:11aferrazFixed in Version => 3.0PR17Q3
2017-05-29 17:43hudsonbotCheckin
2017-05-29 17:43hudsonbotNote Added: 0096920
2017-05-30 13:21aferrazRelationship addedrelated to 0036020

Notes
(0096247)
AtulOpenbravo   
2017-04-28 08:26   
Test Plan

- Create Show MRP and Production fields preference.

- Product window: create 3 Products in Organization "España Región Norte":
    1. Raw material A : Production = Yes, Purchase = Yes, Attribute Set = Lote
    2. Raw Material B : Production = Yes, Purchase = Yes, Attribute Set = Lote
    3. Final Product AB : Production = Yes, Purchase = No, Attribute Set = Lote
                  
- For the Final Product AB, Manufacturing tab: Add a new record for organization: España Región Norte and select a Bin. RN-0-0-0

- Create new record, Manufacturing Cost Center window:
    Organization: España Región Norte
    Search Key : Test Cost Center
    Name : Test Cost Center

- Create a record in Activity window,
   - Organization as "España Región Norte"
   - Select the cost center as "Test Cost Center"
   - Define search key and name.

- Define a Process Plan:
     - Set Organization as "España Región Norte".
     - Define search key and name.
     - Define Process unit and Conversion rate.
     - In Version tab: create a version for the Process Plan:
          - Starting Date - 01-01-2017
          - Ending Date - 31-12-2017
     - In Operations tab: create the operations for the Process Plan.
          - Define Sequence of the Process Plan.
          - Define search key and name.
          - Select the activity as "Test Activity"
          - Set Create Standards = Yes
     - In I/O Products tab: input-output of the products of the sequence.
          - Create a new record with Product
               "Raw Material A", Production Use P-, Quantity = 1
          - Create a new record with Product
               "Raw Material B", Production Use P-, Quantity = 2
          - Create a new record with Product
               "Final Product AB", Production P+, Quantity = 1

- Product window: for the Final Products it is necessary to select the Process Plan created for the corresponding product.

- Create a Goods Receipt for following Products:
   - Raw Material A, Attribute Set: L100, Quantity 100.
   - Raw Material B, Attribute Set: L200, Quantity 200
   - Process Goods Receipt.

- Work Requirement window:
   - Create new record,
   - select España Región Norte in the organization field
   - Select quantity = 10, creation date, starting date, ending date = today dates
   - Select the Process Plan that this work requirement refers to.
   - Press Process Work Requirement button and the information from the Process
   Plan will be inserted
   - Create Work Effort

- In Work Effort window, select the Work Effort previously created, add the Lot for the Final Product AB for eg: 100200 and Validate the Work Effort.

- Launch the Traceability report, Apply outgoing filter and select the Final Product AB and the attribute.

- Check that information about the Raw Material consumed to produce Final Product AB appears.

- Launch the Traceability report, Apply incoming filter and select the Raw Material A or Raw Material B and the respective attribute.

- Check that information about the Goods Receipts, Production Use P- appears in the report. Moreover Final Product AB details appears below it to check which product was produced from the Raw Material.
(0096323)
hgbot   
2017-05-02 18:09   
Repository: erp/devel/pi
Changeset: e21ff3363f1ee32a3479b6168b3c8617ea3aa2e9
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Apr 28 11:31:55 2017 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e21ff3363f1ee32a3479b6168b3c8617ea3aa2e9 [^]

Fixes issue 35740: Traceability Report does not show Production information

AND clause MovementType <> 'P+' in case of both incoming and
outgoing filter of the report skipped production lines information.
Clause is modified in order to take care of incoming outgoing filter
as well as production information.

---
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports_data.xsql
---
(0096324)
aferraz   
2017-05-02 18:11   
Code review + Testing OK
(0096920)
hudsonbot   
2017-05-29 17:43   
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/1ee70113bdc4 [^]
Maturity status: Test