Libero Manufacturing Official Extension

From ADempiere
Revision as of 14:28, 25 October 2013 by Rvergara (Talk) (See Also)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
Logo e-Evolution.png
DesignIcon.jpg Designer: Victor Pérez.
Email.jpg Contact Sponsor e-mail: [victor.perez@e-evolution.com].
Develop.png Developer: [Victor Pérez].
Sponsor smily.png Sponsor: e-Evolution,SC, located in Mexico, Equador and Venezuela.

This is to introduce Libero's Manufacturing functionality for integrating into ADempiere ERP Business Suite.

Libero Manufacturing Official Extension

Introduction

The Libero Manufacturing is an Official ADempiere Extension, developed and maintained for [e-Evolution]

for business or additional request please send to victor.perez@e-evolution.com

Source code

Source code

Tracker to report bug

Jira Tracker

How to Install

1.- Install ADempiere 370LTS 2.- Download the binary liberoMFG.jar and liberozkMFG.jar files 3.- Open Terminal command 4.- Change the ADempiere Home directory

   #cd $ADEMPIERE_HOME

5.- Copy the liberoMFG.jar file to packages directory

   #cp liberoMFG.jar $ADEMPIERE_HOME/packages/liberoMFG/lib/

6.- Copy the liberoMFG.jar file to packages directory

   #cp liberozkMFG.jar $ADEMPIERE_HOME/zkpackages/liberoMFG/lib/    

7.- Run ADempiere setup

   #RUN_setup.sh or RUN_silentsetup.sh

8.- Ready

Roadmap Document

Functionality / Feature Status Developer Priority Milestone Release Date Summary
Manufacturing Management -> Engineering Management -> Product Life Cycle Management
* Product Life Cycle Management Under development Victor Perez Low 354 no defined ...
* Finish the implementation of BOM Change Notice Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Engineering Management -> Manufacturing Resource
Pool Resource Management Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Engineering Management -> Manufacturing Workflow
Manufacturing Workflow Editor migrate current Swing form to Web ZK Form Implemeted Victor Perez High 360LTS ready ...
Manufacturing Management -> Engineering Management -> Bill of Material & Formulas
Product Configuration BOM Under development Victor Perez Low 354 no defined ...
BOM & Formula Info migrate current Swing form to Web ZK Form Implemented Victor Perez High 360LTS Ready ...
Co-Product/By Product functionality for Process Industry Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Planning Management - Forecast Management
Calculate Forecast Under development Victor Perez Low 354 no defined ...
Forecast Status Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Planning Management - MRP
Calculate Material Plan of Net Change Under development Victor Perez High 354 no defined ...
MRP Info migrate current Swing form to Web ZK Form implemented Victor Perez High 360LTS ready 100%
Planned Order Approval migrate current Swing form to Web ZK Form Implemented Victor Perez High 360LTS Ready 100%
Integrate MRP to RFQ Under development Victor Perez High 354 no defined ...
Tracking Solution for Demands Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Planning Management - CRP
Resource Load View migrate current Swing form to Web ZK Form implemented Victor Perez High 360LTS ready 100%
CRP Info migrate current Swing form to Web ZK Form Implemented Victor Perez High 360LTS ready 100%
Implement Pool Resource to summary the Capacity by Pool Resource Under development Victor Perez Low 354 no defined ...
Resource Load Report Under development Victor Perez Low 354 no defined ...
Input/Output Report Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Planning Management -> DRP
Calculated Distribution Plan implemented Victor Perez High 360LTS ready ...
Manufacturing Management -> Production Management -> Discrete Manufacturing
Order Receipt & Issue migrate current Swing form to Web ZK Form Implemented Cristina Ghita Low 360LTS ready 100%
Manufacturing Order Components Shortage Browse Under development Victor Perez Low 354 no defined ...
Manufacturing Order Dispatch Browse & Report Under development Victor Perez Low 354 no defined ...
Management the backflush Material issues 80% Completed the group backflush need be implement in Production Under development Victor Perez Low 354 no defined ...
Integrate Request Management with Manufacturing Management Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Production Management -> Continue & Repetitive Manufacturing
Production Line Setup Under development Victor Perez Low 354 no defined ...
Repetitive Schedule Under development Victor Perez Low 354 no defined ...
Change of Product in Production Line Under development Victor Perez Low 354 no defined ...
Workbench for Production Line Scheduling Under development Victor Perez Low 354 no defined ...
Production Line Load Report Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Production Management-> Maintenance Management
Maintenance Order Under development Victor Perez Medium 354 no defined ...
Manufacturing Management -> Production Management-> Activity Control
Use Resource Report Under development Victor Perez Low 354 no defined ...
Resource Efficiency Report Under development Victor Perez Medium 354 no defined ...
Integrate Activity Control with Payroll 70% Completed is necessary validate the Teo´s Work Under development Victor Perez High 354 no defined ...
Manufacturing Management -> Quality Management
Quality Specifications Implemented Victor Perez Low 354 ready ...
Quality Order Implemented Victor Perez Low 370TLS ready ...
Print Test Results Implemented Victor Perez Low 370TLS Ready ...
Manufacturing Management -> Production Management-> Based on TOC
Buffers Management Under development Victor Perez Low 354 no defined ...
Resource Constraints Report (Drum) Under development Victor Perez Low 354 no defined ...
Schedule Optimizer (Rope) Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Throughput Accounting
Throughput Reports Under development Victor Perez Low 354 no defined ...
Manufacturing Management -> Standard Costing Management
Manufacturing Order WIP Cost Report Under development Victor Perez Medium 354 no defined ...
Manufacturing Order History Report Under development Victor Perez Low 354 no defined ...
Frozen/UnFrozen Standard Cost Under development Victor Perez Medium 354 no defined ...
Workflow Manufacturing Cost Browse & Report. Under development Victor Perez Medium 354 no defined ...
Manufacturing Account facts 70% implemented is necessary validate the Teo´s Work. Under implemented Victor Perez High 370TLS ready ...

Sponsors

  • Please send sponsorship funding via this Paypal account: victor.perez@e-evolution.com
    • Please sponsor today! - We thank you in making this the best ERP in the world. - Redhuan D. Oon
  • Wilbar International Sponsored for 6800 USD
  • ARHIPAC SRL sponsored with development & testing (contact: Teo Sarca)

Production Control

  • Print Manufacturing Order 100% Completed in Production
  • Issue and receipt for Material for Manufacturing Order 100% Completed in Production

Activity Control

  • Finish Activity Control (Shop Floor Control) Functionality 100% Completed and in Production
  • Feed Back Manufacturing Activity 100% Completed and in Production
  • Report the Feed Back for Labor,Real Time 100% Completed and in Production
  • Subcontract Management 100% Completed and in Production
    • Create Subcontract Purchase Order 100% Completed and in Production
    • Create Account Rule for Subcontract 100% Completed and in Production

Standard Cost

    • Report to Bill of Material Cost 100% Completed and in Production

Project Lead

Developers


Requirements

Functional Specs

Organization

Testers

Functional team

  • Volunteers for reviewing:
    • Mario Calderon 20:01, 15 July 2013 (UTC) - Functional and Technical Review

Result of Functional Review

  • General observations. San Salvador, July 16th, 2013, 14:24 GMT.
    • Libero MFG is now part of Adempiere; the main difference is that is is implemented as a package (like Libero HR), which can or cannot be included in the implementation.
    • The module reuses whenever possible existing Adempiere objects. A good example is here the adaptation of workflows, resources and costing elements.
    • Libero claims to cover all the aspects of a production.
    • It seems that due to its concept, modifications and enhancements are organic, this means, the module is upgradable. A very illustrative example is here the Forecast: in the original version, Forecasts consisted just of one window and importing. In further developments, it was developed to a full-fledged forecasting system, all integrated to sales, replacing altogether legacy systems.
    • The module enables to manage complex production scenarios/situations
    • Reports are quite basic, so there will be a need to expand the existing ones or create new ones altogether when implementing
    • I wouldn't recommend to use it for simple manufacturings: the effort to configure it is too big. In such cases, Manufacturing Light may be an alternative.
    • The costing was spared altogether from this review, because costing is reviewed by Susanne and Steven elsewhere. I just mention it when it is inevitable.
    • A good implementation is done when the different windows, processes and tools here reviewed are combined in an optimal way. This requires exhaustive study of them.
    • There is a Manual, which has to be updated with the latest changes.
    • All windows, processes, fields are in English and Spanish (Mexico)
    • There are workflows to all major areas and the help is explicative though I think the translations into English could be grammatically improved.
    • See also Libero doc
    • As there are many windows, processes and Smart Browsers involved, this documentation of the revision is just about answering the question if it works as intended/specified, not about explaining the functionality. In order to know the functionality, please see the documentation and the code.
  • I've tested Libero according to its menu structure
    • Engineering Management
      • Resource Manufacturing
        • Resource Type.......>>result: approved
          • Creation of resource types (to use in Manufacturing plants)
          • UOM of resource (which will later have the product; mostly hours, because the costing will be in hours)
          • Product category (e.g. "Resources")
          • Time slots: hours and minutes
          • Days of week
          • Good: one can model different times for different resources.
          • FR: Missing: working hours for Saturday and Sunday, which is mostly different
        • Manufacturing Resource.......>>result: approved
          • Select the type (this means, different slots possible)
          • Warehouse selectable (it binds Warehouse to a Manufacturing Resource)
          • Manufacturing Resource type: Workstation, Plant (with Planning horizon for MRP). If no Planning horizon given, MRP will fail.
          • There are also Production line and Work center, but they seem to be the same as Workstations
          • When saving, a Resource is created and a Product with same name. This is a very clever move, as this allows the resource to be used for cost purposes.
      • Manufacturing Workflow
        • Manufacturing Workflows.......>>result: approved
          • Process type
          • Starting node
          • Calculated costs (fields are editable, they should be read only, so only the rollup can change them)
          • Batch size (later for Manufacturing Orders)
          • Resource (don't know exactly the reason for a resource here. I've use it in the Activities)
          • Validate button (just to test if there are circular references in the activities). If the WF is not validated, some processes stop.
          • Activities
            • dead times definable
            • Resource for costing
            • Qty/unit of time
            • Yield of activity
            • Transition to next activity
            • If no resource selected, no costs will be calculated. Perhaps a message while saving the workflow would help (this can be done in the Application dictionary as a saving message).
        • Manufacturing Workflow Editor.......>>result: approved
          • It shows the workflows graphically
          • Similar to the WF editors of Adempiere
      • Bill of Materials & Formulas
        • Bill of Materials & Formula.......>>result: approved
          • Several BOMs for one product definable
          • Make-to-kit, Make-to-Order, Current work. There are others, but I didn't test them.
          • Validation period
          • FR: when BOM value=Product value, it is considered the default BOM. A "Default" field would be more suitable.
        • BOM & Formula Info.......>>result: approved
          • Shows BOM graphically, also in several levels
          • Implosion - very good
          • Shows qtys and Component info
        • Multi Level BOM & Formula Detail.......>>result: approved
          • Report for BOM, also for multi levels
          • Resorts to view RV_PP_Product_BOMLine
          • Adaptable according to view fields
        • Simulated Pick List.......>>result: approved
          • Report simulating a Pick List of all levels
          • Not sure about when it is needed exactly
        • Mutiple Components Change
        • Product Configuration BOM.......>>result: not approved
          • Didn't get it to work
    • Planning Management
      • Product Planning
        • Product Planning Data.......>>result: approved
          • First tab: Product
          • Second tab: Data Planning
          • BOM and Workflow for a product definable
          • For CRP/MRP/DRP
          • Other parameters: Plant, Warehouse, Organization, Minimal Stock, etc..
          • You can configure if a data planning is included in Production Master Plan, is considered for MRP and DRP
          • Several Data planning entries for a Product possible, depending on Plant, Warehouse and Organization
          • Data Planning can be imported. This is a big help.
          • FR: now, a special Data Planning for Rollup is needed (Organization=0). Perhaps this can be spared.
          • FR: a window just for data planning is desirable, similar to the window for BOMs. The actual window forces you to first select a product and then you see the data planning. In environments where the % of BOMs to total products is low, this can become a tedious task. I created such a window, and it helped a lot.
        • Create Product Planning.......>>result: approved
          • Creates data planning entries according to several paramaters
          • Also possible via importing
      • Forecast management
      • MRP
        • Calculate Low Level.......>>result: approved
          • Calculates the level for all BOMS
          • To be used at Rollup, MRP, CRP
          • It is not crystal clear for me, when it should be executed. In the code, it is called several times, so I executed it every time I changed the levels of BOMs.
        • Create Record MRP.......>>result: approved
          • Deletes records and creates records within PP_MRP (the Production Master Plan)
          • Actually, it updates the Production Master Plan
          • Perhaps usable when one is not so sure whether the Master Plan is OK
        • Regenerative Material Plan.......>>result: approved
          • Actual MRP
          • Considers demands and supplies
          • Generates Manufacturing Orders, Material Requisitions Just in Time, according to calling parameters, configuration and Production Master Plan
          • Generates Errors for several reasons (no planning data for calling parameters, due dates, etc.).
          • Very good for simulations, because drafted documents are deleted and re-created.
          • Oportunity to change configuration (e.g. Promised dates) and re-run MRP
          • Very difficult to get correct results. One must to be very careful.
          • If one little parameter or value is missing, no results are generated
          • FR: the actual info is very sparse. If there is an error, you have to guess in the configuration, making it very difficult to find it. As the MRP process is central in Libero, a very detailed information result is a must. This should be include which Plant, Organization, Warehouse, level, etc is being processed, and the steps taken/errors encountered. The code is very explicit here, and it should be no big issue to add it.
        • Net Change Material Plan.......>>result: approved
          • The same as MRP, only that it calculates MRP when there are changes in
            • Product
            • Product BOM & Formula
            • Forecast
            • Sales Order
            • Distribution Order
            • Purchase Order
            • Inventory
        • Selective Material Plan.......>>result: approved
          • MRP for selected products/configurations
        • MRP Info.......>>result: approved
          • The same information as the Production Master Plan
        • MRP Notice.......>>result: approved
          • Messages from MRP Process
          • Just for the actual user
        • MRP Notice (all).......>>result: approved
          • Messages from MRP Process
          • For all users
        • MRP Action Messages.......>>result: approved
          • Smart Browser
          • Shows the action messages created by MRP
          • Filters: Organization, Warehouse, Plant, Planner, Message, Order Type, Priority, Product, Scheduled Start Date)
          • To visualize the message detail: click the zoom button.
        • View MRP Records.......>>result: approved
          • This is the Production Master Plan (RV_PP_MRP)
        • MRP Demands Browse.......>>result: approved
          • Smart Browser for the demands
          • Several filters
          • Zoom: it shows the MRP Demands View (with pegging to supplies detail)
          • Exportable to Excel
        • MRP Demands View.......>>result: approved
          • Master-Detail window
          • Shows Demands (Master) and pegged Supply (Detail)
          • Very good to know demands and how a demand is met
          • FR: it would be desirable if Forecasts are included
        • MRP Details.......>>result: approved
          • The Production Master plan (RV_PP_MRP) as a report
          • Several parameters to filter
        • MRP Supplies Browse.......>>result: approved
          • Smart Browser for the supplies
          • Several filters
          • Zoom: it shows the MRP Supplies View (with pegging to demands detail)
          • Exportable to Excel
        • MRP Supplies View.......>>result: approved
          • Master-Detail window
          • Shows Supplies (Master) and pegged Demands (Detail)
          • Very good to know supplies and the demand behind
        • Approval Material Requisition.......>>result: approved
          • Smart Browser
          • Selected document is deleted
          • New document is created with specified parameters
          • Document is prepared, so it will not be deleted when running MRP again (this is the Approval)
        • Approval Manufacturing Order.......>>result: approved
          • Smart Browser
          • Selected document is deleted
          • New document is created with specified parameters
          • Document is prepared, so it will not be deleted when running MRP again (this is the Approval)
        • Approval Distribution Order.......>>result: approved
          • Smart Browser
          • Selected document is deleted
          • New document is created with specified parameters
          • Document is prepared, so it will not be deleted when running MRP again (this is the Approval)
      • CRP
        • Calculate Capacity Plan.......>>result: approved
          • The actual CRP process
          • For a whole plant
          • Forward or backward
          • Calculates the times for every activity in the Manufacturing orders and also the beginning or finishing date of the MO (depending if the process was run backward or forward)
          • Very straight forward
          • FR: Here applies the same as in the MRP process: a much detailed result info is needed, so the user can get an idea of what and why it happened.
        • Resource Load View.......>>result: approved
          • Graphical image of the load of one resource
          • Free time and load time per day
          • Overload visible
          • Somehow difficult to understand
        • CRP Info.......>>result: approved
          • Graphical Report of the workload of one resource
          • Period to show selectable
          • The time consumed everyday can be read on the right side
          • Altogether, the graphics don't depict in a graceful way the matter
          • FR: A Smart Browser where starting and end dates of Manufacturing Orders and another for Activities would be a great help.
      • DRP
        • Calculate Distribution Plan
        • DRP Details
    • Production Management
      • Discreet Manufacturing
        • Manufacturing Order.......>>result: approved
          • The document for production
          • Can be generated by MRP, Sales Order (if BOM is Make-to-Order) or created manually
          • Explosion of BOM and Workflow occurs automatically
          • When status not=Drafted, then it is not deleted by MRP
          • MRP and CRP do changes on them when executed, the same as with other dedicated Smart Browsers
          • Very good: the BOM, workflow, and the components and their quantities can be changed during the Drafted status.
          • FR: a Smart Browser were you can complete and close MOs in massive form
        • Manufacturing Orders Review .......>>result: approved
          • Report for Manufacturing Orders
          • View: RV_PP_Order
          • Several Parameters
        • Component Check.......>>result: approved
          • For a single Manufacturing Order
          • Components of the BOM
          • Report shows qty available and qty required for every component
          • Usable before the real production
        • Print & Release Order.......>>result: approved
          • A Manufacturing Order can be completed
          • Some reports can be run at the same time
          • FR: missing something similar, but for many MO's. It can happen that a plant needs to release a lot of MOs at once.
        • Order Receipt & Issue.......>>result: approved
          • The actual production
          • Only for completed orders
          • Can be separated between just consuming material (issue), the actual production(receipt) or both at the same time (backflush)
          • Partial production possible
          • Lot can be defined here
          • Date of production definable here
          • Locator to deliver production selectable
          • Partial issue possible
          • Scrap can be defined, though it is not 100% correct
          • If there are errors, they are very cryptic and you must know what they mean
          • Document can be closed here.
          • FR: the form disappears as soon as you type in the last dialog. It should remain there and you must close it afterwards
          • FR: the close dialog is almos imperceptible. It should ask clearly if you want to close the MO
          • FR: a Smart Browser were you can complete and close MOs in massive form
          • Form is quite awkward, there is no other way to produce
        • Inventory in Process.......>>result: not approved
          • Report based on View RV_PP_WIP
          • I didn't get a result
          • View doesn't exist in AD nor DB (Postgres)
        • Order Transactions.......>>result: approved
          • Report on view RV_PP_Order_Transactions
          • To verify the detail of every transaction executed as a result of a Manufacturing Order
          • Fields: document number, quantities, products and the date in which the transactions were made, etc.
      • Activity Control
        • Activity Control Report.......>>result: approved with remarks
          • A window to document differences in production (thus Control report)
          • Creates one cost collector
          • Part of the costing
          • Cumbersome to work with
        • Shop Floor Transaction Details.......>>result: approved
          • Report of the activities of a Manufacturing Order
          • Based on view RV_PP_Operation_Activity
          • Shows actually the data of the Activity tab of a MO
    • Distribution Management
        • Distribution Network
        • Distribution Order
        • Distribution Order Detail
        • Distribution List
        • Distribution Run
        • Distribution Run Orders
        • Generate Movement Manual
        • Generate Movement
        • Move Confirmation
        • Material Receipt Distribution Order
    • Standard Costing Management
        • Frozen/UnFrozen Cost
        • Create Doc Type to Manufacturing.......>>result: approved
          • Process to be run only once -if ever: it creates the document type Manufacturing Order, in case it is not defined
        • Create Element.......>>result: approved
          • Cost Elements can be created for Organization, Account Schema, Cost type, Product Category and Product
          • According to the Costing method defined in the Account Schema
          • Different Cost elements for different Costing Methods can be generated
          • Has to be treated carefully; perhaps is recommendable to delete unnecessary Cost elements via SQL afterwards
        • Copy Price to Standard Cost.......>>result: approved
          • A price from a price list is copied to a Standard Cost Element
          • Nice helper when building up the cost configuration
        • Workflow Cost Roll-Up.......>>result: approved
          • takes all information of the workflows that match the parameters
          • calculates the cost per unit per activity
          • sums up the cost of all activities to the workflow
        • Bill of Material & Formula Cost Roll-Up.......>>result: approved
          • Calculates recursively all costs of BOMS, depending on the parameters selected
          • The costs of the actual and the low levels below are calculated
          • With the Workflow roll up, the complete expected manufacturing costs can be planned
        • Cost BOM Multi Level Review.......>>result: approved
          • Recursive report of the costs of a Product for all its low levels
          • Shows costs of actual and lower level
          • Only works for BOMs
        • Cost Collector
          • The result of reporting activities, costing MOs activities and completing MOs as cost collectors.
  • Misc
    • Importing BOMs.......>>result: approved
      • Works
    • Importing Workflows.......>>result: approved
      • Works
    • Importing Planning data.......>>result: approved
      • Works
    • Importing forecasts.......>>result: approved
      • Works

Result of Technical Review

  • General observations San Salvador, July 17th, 2013, 02:24 GMT.
    • Libero Production and HR is somehow split: some files are in the actual code, others are in packages.
    • ADempiere code now
      • All model classes are in the package org.eevolution.model, which is an integral part of ADempiere
        • This applies to Libero Manufacturing and Libero HR
        • Example: X_PP_Order, I_PP_Order (Model for Manufacturing Orders)
      • In the package org.eevolution.process there are some processes, like ViewCopyFrom, ImportProductBOM
    • In the Libero branch are the classes defined which implement the business logic
      • No I nor X class
      • Almost all M classes (a couple are in the actual ADempiere branch now)
        • Example: MPPOrder, MPPMRP, MPPOrderBOM
      • All processes
        • Example: MRP, CRP, GenerateForecast, Import Workflow
    • The I and X classes are generated and their nomenclature is OK.
    • The same applies to the M classes: they stick to the naming of other ADempiere documents like MOrder.
    • Private variables follow the ADempiere convention (m_.... or p_....)
    • All class headers I reviewed have JavaDoc comments.
    • Some (not all) methods have JavaDoc comments.
    • Extensive usage of Query and DB classes for accessing the database.
    • Model validators are used as otherwise in ADempiere
    • Usage of self-explanatory exceptions when important errors encountered
    • License headers and serialVersionUID existent in the classes I reviewed.
    • Comments are sparse and could be more explicit, but this is common in ADempiere
    • Imports are dedicated
      • example: import org.compiere.util.Env;. This is how it is implemented --> OK
      • example: import org.compiere.model.*. I haven't found any case like this --> OK
    • Usage of static final variables when needed
    • Code readable: well formatted.
    • Some methods are quite long
    • I have debugged MRP, CRP, DRP and other processes; after a couple of tries, the functionality can be understood.

Related subject

Manufacturing Standard Cost

Manufacturing Work Shop

Reference Sites

  • These are sites that have Libero Manufacturing in production use:

See Also