Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037642Openbravo ERP06. Material requirement planning (MRP)public2018-01-15 18:222018-02-22 18:18
Reportergorkaion 
Assigned Tononofrancisco 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket50348
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037642: Enable tree view in MRP Manufacturing Plan window
DescriptionEnable tree view in Manufacturing Plan window.

The Lines tab of this window usually has many rows, 100s or 1000s. Since it is not possible to set an order by several fields, for example product and planned date, it is very difficult to understand the results. Enabling the Tree View on it has a big impact to properly understand them.

This window already has the Parent link column (Report Set field), so it is quite straight forward to define it as a Tree View.

The same can be developed in Purchasing Plan window.

Steps To ReproduceConfigure and execute a Manufacturing Plan.
Check that the result are not easy to understand.
Proposed SolutionFollow the following wiki to set up a Link To Parent tree on the MRP_RUN_PRODUCTIONLINE table.
http://wiki.openbravo.com/wiki/How_to_Define_a_Table_as_a_Tree [^]
Additional Information
TagsNo tags attached.
Relationships
causes design defect 0037982 closed markmm82 Not possible to delete Manufacturing Plans 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-15 18:22gorkaionNew Issue
2018-01-15 18:22gorkaionAssigned To => Triage Finance
2018-01-15 18:22gorkaionOBNetwork customer => No
2018-01-15 18:22gorkaionModules => Core
2018-01-15 18:22gorkaionSupport ticket => 50348
2018-01-15 18:22gorkaionTriggers an Emergency Pack => No
2018-01-15 18:58gorkaionDescription Updatedbug_revision_view_page.php?rev_id=16533#r16533
2018-01-17 18:57gorkaionOBNetwork customerNo => Yes
2018-01-22 15:27nonofranciscoAssigned ToTriage Finance => nonofrancisco
2018-01-22 15:28nonofranciscoStatusnew => scheduled
2018-01-23 10:22hgbotCheckin
2018-01-23 10:22hgbotNote Added: 0101886
2018-01-23 10:22hgbotStatusscheduled => resolved
2018-01-23 10:22hgbotResolutionopen => fixed
2018-01-23 10:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/21e9102f2f7d35c80b8c06aa5984cfb761005220 [^]
2018-01-23 10:26dmiguelezReview Assigned To => dmiguelez
2018-01-23 10:26dmiguelezNote Added: 0101889
2018-01-23 10:26dmiguelezStatusresolved => closed
2018-01-23 10:26dmiguelezFixed in Version => 3.0PR18Q2
2018-01-24 16:05nonofranciscoNote Added: 0101927
2018-02-20 17:44gorkaionIssue cloned0037982
2018-02-20 17:44gorkaionRelationship addedcauses 0037982
2018-02-22 18:18hudsonbotCheckin
2018-02-22 18:18hudsonbotNote Added: 0102682

Notes
(0101886)
hgbot   
2018-01-23 10:22   
Repository: erp/devel/pi
Changeset: 21e9102f2f7d35c80b8c06aa5984cfb761005220
Author: Nono Carballo <nonofce <at> gmail.com>
Date: Mon Jan 22 17:22:09 2018 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/21e9102f2f7d35c80b8c06aa5984cfb761005220 [^]

Fixes issue 37642: Enable tree view in MRP Manufacturing Plan window

A tree of type LinkToParent was created using the column parentId (Report Set)
in table mrp_run_productionline.
The tree was set in manufacturing Plan/Lines tab.

---
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src-db/database/sourcedata/AD_TABLE_TREE.xml
---
(0101889)
dmiguelez   
2018-01-23 10:26   
Code Review + Testing Ok
(0101927)
nonofrancisco   
2018-01-24 16:05   
Test Plan

As F&B International Group Admin
  * Create a new Product
    Organization "F&B España Region Norte"
    Search key: "RM"
    Name: "Raw Material"
    Production: true
  * Create a new Product
      Organization "F&B España Region Norte"
      Search key: "Final"
      Name: "Final Product"
      Production: true

  * Create a new Manufacturing Plan
      Organization "F&B España Region Norte"
      Name: "MP"
      * Verify Lines tab is showing in grid view
      * Create a new line
        Planned date: today
        Product: "Final"
      * Create a new line
        Planned date: today
        Product: "Raw Material"
        Report set: "MP - - Final - Final - -"
      * Activate tree view for Lines tab

  Verify the lines are shown in tree view, the root node of the tree is the line containing "Final" product; the leaf node is the line containing "Raw Material" product.
(0102682)
hudsonbot   
2018-02-22 18:18   
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/980a6ad5bbf5 [^]
Maturity status: Test