Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2018-01-15 18:222018-02-22 18:18
ReportergorkaionView Statuspublic 
Assigned Tononofrancisco 
PrioritynormalResolutionfixedFixed in Version3.0PR18Q2
StatusclosedFix in branchFixed in SCM revision21e9102f2f7d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0037642: 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. [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
causes design defect 0037982 closedmarkmm82 Not possible to delete Manufacturing Plans 

-  Notes
hgbot (developer)
2018-01-23 10:22

Repository: erp/devel/pi
Changeset: 21e9102f2f7d35c80b8c06aa5984cfb761005220
Author: Nono Carballo <nonofce <at>>
Date: Mon Jan 22 17:22:09 2018 +0100
URL: [^]

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
dmiguelez (developer)
2018-01-23 10:26

Code Review + Testing Ok
nonofrancisco (developer)
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.
hudsonbot (developer)
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: [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2018-01-15 18:22 gorkaion New Issue
2018-01-15 18:22 gorkaion Assigned To => Triage Finance
2018-01-15 18:22 gorkaion Modules => Core
2018-01-15 18:22 gorkaion Triggers an Emergency Pack => No
2018-01-15 18:58 gorkaion Description Updated View Revisions
2018-01-22 15:27 nonofrancisco Assigned To Triage Finance => nonofrancisco
2018-01-22 15:28 nonofrancisco Status new => scheduled
2018-01-23 10:22 hgbot Checkin
2018-01-23 10:22 hgbot Note Added: 0101886
2018-01-23 10:22 hgbot Status scheduled => resolved
2018-01-23 10:22 hgbot Resolution open => fixed
2018-01-23 10:22 hgbot Fixed in SCM revision => [^]
2018-01-23 10:26 dmiguelez Review Assigned To => dmiguelez
2018-01-23 10:26 dmiguelez Note Added: 0101889
2018-01-23 10:26 dmiguelez Status resolved => closed
2018-01-23 10:26 dmiguelez Fixed in Version => 3.0PR18Q2
2018-01-24 16:05 nonofrancisco Note Added: 0101927
2018-02-20 17:44 gorkaion Issue cloned 0037982
2018-02-20 17:44 gorkaion Relationship added causes 0037982
2018-02-22 18:18 hudsonbot Checkin
2018-02-22 18:18 hudsonbot Note Added: 0102682

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker