Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0036020Openbravo ERP05. Production managementpublic2017-05-17 11:162017-05-31 15:23
VictorVillar 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
pi 
3.0PR17Q3 
aferraz
Core
No
0036020: Necessary to show properly the column names in the Traceability report
Necessary to show properly the column names in the Traceability report
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.

The column name of Product, Attribute and Warehouse appear but there is no information regarding the columns below (see the attached image). It is possible to guess what is the meaning of each column but it is not clear at all the information of the last column
No tags attached.
related to defect 0035740 closed AtulOpenbravo Traceability Report does not show any information related with Production 
png Selection_082.png (123,335) 2017-05-17 11:16
https://issues.openbravo.com/file_download.php?file_id=10766&type=bug
png
Issue History
2017-05-17 11:16VictorVillarNew Issue
2017-05-17 11:16VictorVillarAssigned To => Triage Finance
2017-05-17 11:16VictorVillarFile Added: Selection_082.png
2017-05-17 11:16VictorVillarModules => Core
2017-05-17 11:16VictorVillarResolution time => 1497650400
2017-05-17 11:16VictorVillarTriggers an Emergency Pack => No
2017-05-17 12:52ngarciaResolution time1497650400 => 1496786400
2017-05-18 13:57aferrazAssigned ToTriage Finance => AtulOpenbravo
2017-05-24 10:25AtulOpenbravoStatusnew => scheduled
2017-05-28 11:27AtulOpenbravoNote Added: 0096838
2017-05-30 13:21aferrazRelationship addedrelated to 0035740
2017-05-30 17:23hgbotCheckin
2017-05-30 17:23hgbotNote Added: 0097024
2017-05-30 17:23hgbotStatusscheduled => resolved
2017-05-30 17:23hgbotResolutionopen => fixed
2017-05-30 17:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c6d8f568ca52dcd97351081ca47c09ad1d873aef [^]
2017-05-30 17:23hgbotCheckin
2017-05-30 17:23hgbotNote Added: 0097025
2017-05-30 17:45aferrazReview Assigned To => aferraz
2017-05-30 17:45aferrazNote Added: 0097029
2017-05-30 17:45aferrazStatusresolved => closed
2017-05-30 17:45aferrazFixed in Version => 3.0PR17Q3
2017-05-31 15:23hudsonbotCheckin
2017-05-31 15:23hudsonbotNote Added: 0097053
2017-05-31 15:23hudsonbotCheckin
2017-05-31 15:23hudsonbotNote Added: 0097054

Notes
(0096838)
AtulOpenbravo   
2017-05-28 11:27   
- Create Show MRP and Production fields preference.

- In 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.

- In Manufacturing Cost Center window:
    - Create new record,
    - select Espana REgion Norte in the organization field.
    - Type search key and name.

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

- In Process Plan window: Create the process Plan by typing Process Plan in the quick launch menu and create new record:
    - Select Espana Region Norte in Organization
    - Type search key and name
    - Process unit and Conversion rate
    - a. Version tab: create a version for the Process Plan with starting and
         ending date
    - 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
    - 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.

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

- 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

- Nagivate to Work Effort window and 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.

- The column name of Product, Attribute and Warehouse appear.
- Below this information about headers for each column as Movement Date,
  Movement Type, Locator, Movement Quantity Uom, Transaction Reference, Total
  Quantity Uom.
(0097024)
hgbot   
2017-05-30 17:23   
Repository: erp/devel/pi
Changeset: c6d8f568ca52dcd97351081ca47c09ad1d873aef
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Sun May 28 09:32:38 2017 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c6d8f568ca52dcd97351081ca47c09ad1d873aef [^]

Fixes issue 36020: Column names not properly shown in Traceability report

Added column headers for the Movement Date, Movement Type, Movement Quantity Uom, Locator,
Transaction Reference, Total Quantity Uom. Incase there is Order Quantity and Product Uom
Additional column header next to Movement Quantity Uom is shown for Order Quantity Uom.

---
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports.html
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports.java
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports.xml
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports_data.xsql
---
(0097025)
hgbot   
2017-05-30 17:23   
Repository: erp/devel/pi
Changeset: 78820ce7d6e06be5e4d685de5c0c25791249d264
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue May 30 17:14:46 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/78820ce7d6e06be5e4d685de5c0c25791249d264 [^]

Related to issue 36020: Code review improvements

Avoid to run same MInOutTraceReportsData.selectChilds query two times
(inside createHeader and processChilds methods).

---
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports.java
---
(0097029)
aferraz   
2017-05-30 17:45   
Code review + Testing OK
(0097053)
hudsonbot   
2017-05-31 15:23   
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/e39fb42d847c [^]
Maturity status: Test
(0097054)
hudsonbot   
2017-05-31 15:23   
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/e39fb42d847c [^]
Maturity status: Test