Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036020
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajoralways2017-05-17 11:162017-05-31 15:23
ReporterVictorVillarView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version3.0PR17Q3
StatusclosedFix in branchFixed in SCM revisionc6d8f568ca52
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036020: Necessary to show properly the column names in the Traceability report

DescriptionNecessary to show properly the column names in the Traceability report
Steps To Reproduce0. 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
TagsNo tags attached.
Attached Filespng file icon Selection_082.png [^] (123,335 bytes) 2017-05-17 11:16

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0035740 closedAtulOpenbravo Traceability Report does not show any information related with Production 

-  Notes
(0096838)
AtulOpenbravo (developer)
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 (developer)
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 (developer)
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 (manager)
2017-05-30 17:45

 Code review + Testing OK
(0097053)
hudsonbot (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2017-05-17 11:16 VictorVillar New Issue
2017-05-17 11:16 VictorVillar Assigned To => Triage Finance
2017-05-17 11:16 VictorVillar File Added: Selection_082.png
2017-05-17 11:16 VictorVillar Modules => Core
2017-05-17 11:16 VictorVillar Resolution time => 1497650400
2017-05-17 11:16 VictorVillar Triggers an Emergency Pack => No
2017-05-17 12:52 ngarcia Resolution time 1497650400 => 1496786400
2017-05-18 13:57 aferraz Assigned To Triage Finance => AtulOpenbravo
2017-05-24 10:25 AtulOpenbravo Status new => scheduled
2017-05-28 11:27 AtulOpenbravo Note Added: 0096838
2017-05-30 13:21 aferraz Relationship added related to 0035740
2017-05-30 17:23 hgbot Checkin
2017-05-30 17:23 hgbot Note Added: 0097024
2017-05-30 17:23 hgbot Status scheduled => resolved
2017-05-30 17:23 hgbot Resolution open => fixed
2017-05-30 17:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c6d8f568ca52dcd97351081ca47c09ad1d873aef [^]
2017-05-30 17:23 hgbot Checkin
2017-05-30 17:23 hgbot Note Added: 0097025
2017-05-30 17:45 aferraz Review Assigned To => aferraz
2017-05-30 17:45 aferraz Note Added: 0097029
2017-05-30 17:45 aferraz Status resolved => closed
2017-05-30 17:45 aferraz Fixed in Version => 3.0PR17Q3
2017-05-31 15:23 hudsonbot Checkin
2017-05-31 15:23 hudsonbot Note Added: 0097053
2017-05-31 15:23 hudsonbot Checkin
2017-05-31 15:23 hudsonbot Note Added: 0097054

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker