Libero MFG for iDempiere 3.1

[red1]

[You can collect the plugin jar here - to try]
This is in continuation of the work at viewtopic.php?f=45&t=1775&start=50 so there is no release changes since last update in November 18, 2015.
INSTALL plugin and START. Some minor warning about dependency does not stop anything, it still works well.

Plugin source checks out well and remains intact in the jump to iDempiere 3.1 source which has changes:
1.1) Migration of mercurial repository to low volume by Hiep LQ
1.2) Latest fixes to 3.1.

The focus has moved form Swing UI to fully ZK UI which has all custom forms transferred over so no Swing UI plugin testing.

Fresh database seed dated today from iDempiere SourceForge download. RUN_ImportIdempiere to test from clean base.
2.1 The embedded 2Pack packs-in OK in ss console when plugin started.
2.2 Tested also in source, 2Pack packs-in OK in Eclipse console:

Screen Shot 2015-12-08 at 7.23.20 PM.png (83.66 KiB) Viewed 16856 times

Plugin source at http://bitbucket.org/red1/org.libero.manufacturing dated November 18, 2015
iDempiere Source http://bitbucket.org/idempiere/idempiere dated November 14, 2015.
(Note these sources are constantly updated as can be seen on the time-stamps there)

Then i examine in the Libero Menu that has latest . Seems all there.

Screen Shot 2015-12-08 at 1.19.39 PM.png (32.26 KiB) Viewed 16884 times

Testing on it at first gave an error because Lawn Fertilizer has no ProductPrice:

Screen Shot 2015-12-08 at 3.01.31 PM.png (57.69 KiB) Viewed 16881 times

After creating a Standard Price for it, it gives all green to the CalculateMaterialPlan test:

Screen Shot 2015-12-08 at 4.56.14 PM.png (74.55 KiB) Viewed 16881 times

Work continues:
1. Order and Receipt custom form to be converted to easier maintainable and extensible InfoWindow framework
2. The Danish 4 recommendations to complete the Workflow Resource Activity visibility and control
3. More FitNesse incorporation for http://red1.org/iDempiereFitNesse.pdf (just been updated to v1.0 - pages 16, 44, 49)

[red1]

Following bugs are solved:
Product Planning is not opening Manufacturing Workflow. Added ZoomCondition in Workflow table.
Ferry Irawan has pointed out a functional loophole here http://groups.google.com/forum/#!topic/ ... cP90FTWvJM
Brian Karemba has pointed out a bug http://groups.google.com/forum/#!topic/ ... tQ79vqixWA

Following patches are submitted to core:
http://idempiere.atlassian.net/browse/IDEMPIERE-3020 (process stopper. Carlos has applied the patch, so if your download is latest, then no need to apply to your source.)

[red1]

Latest Changes:
1. During SalesOrder prepare or complete or reverse:
a. MRP generated or updated as before but DocStatus set to Draft.
b. Manufacturing Workflow of Product hard set PP_MRP as Table during runtime.
c. Manufacturing Workflow Node can set Action

2. During CalculateMaterialPlan, the following happens:
a. MRP from 1.a is set to InProgress
b. Generates as usual Demand and Supply MRP records and associated PP_Order (MO) records.
c. WF_Activity created
d. S_Resource_Assignment created
Most new code happens in

Prerequisites to test Fertilizer#50:
0. Apply patch in previous post or take the latest iDempiere build.
1. Product must have Planning Data, NotPurchased and no '0' PromisedDeliveryTime for getDuration to trigger 2.c/d
2. Set Manufacturing Workflow 'Packing Process' Node action to 'UserWindow' and Window set to 'MRP', Duration Unit set to 'Hour'.

Below are screenshots explaining the above.
After a Sales Order of an internally manufactured Fertilizer #50 which is insufficient, an MRP (1.a) is created. Opening up the MRP Info (Info) shows only one Draft MRP record. After selecting it and running CalculateMaterialPlan, it refreshes as below:

OrderGenMRP.png (133.48 KiB) Viewed 16638 times

Three new MRP records are created, 1 Supply and 2 Demands. A new PP_Order (MO) record is created, linked to the source OrderLine and MRP records. Note the Dashboard panel for Activities will receive a new notification:

WFActivity.png (42.37 KiB) Viewed 16638 times

Clicking on it will open the WF Activities Panel:

WFActivityPanel.png (67.87 KiB) Viewed 16638 times

This means Libero Manufacturing activity is part of a live WF Activity that can be processed to kick off subsequent activities as defined in its Workflow, and behave accordingly as in a Production Schedule Gantt Chart where Critical Path can be defined. Next at the Dashboard Views, open up the Schedule Info and go to the WorkCentre resourcetype and PackingProductionLine resource:

ResourceScheduleInfo.png (59.57 KiB) Viewed 16624 times

The next MRP request on similar resource will place a new blue marker after the last one, so that it reflects actual time display. MRP and MO records will also reflect time starts and ends accordingly.

Pending:
0. PP_Order (MO) explosion of its BOM does not create Requisition for raw materials shortfall (DONE)
0.a ..does not create roll up totals in children. (DONE)
1. To allow WF Activity completion, its linked MRP requires DocAction. (DONE)
2. A Master Production Schedule (MPS) Viewer based on the ScheduleInfo but combined all the plant shopfloor resources with different color coding and hyperlinked to relevant MRP document. (FUTURE)
2.a The MPS can change color code of a delayed task.
3. A dynamic readjustment of MPS tasks when WFActivity is completed at different times then original. (FUTURE)

[red1]

Found a slight but crucial gap bug in Manufacturing Order where it does not iterate further if its BOM components are themselves BOM parents. Now solved as shown below. MO showing the second BOM parent and MRP Info iterate all including requisitions. I have also cross linked all records to the originating Sales Order/Line for easier handling. Note now there is roll up of bom qtys which is a net calculated with scrap extra percentage and Requisition also consider available stocks.

MO-multiBOM.png (69.5 KiB) Viewed 16595 times

FinishedCMP.png (264.36 KiB) Viewed 16593 times

Note that water even got extrapolated. Since it has unlimited supply, its demand MRP need no Supply counterpart. I also made extra criteria and arrange the columns more intuitive so that users can filter for more focus. Been an info window of course all can be changed without coding.
I found out also that the ResourceAssignment InfoSchedule does not really avoid off duty slots. But there is IsDateAvailable routine to handle that in future. However it can use a Week factor to offset the time i.e. a 6 day week has 1.2 factor added to the Duration.

[red1]

Made some improvement to give a Master Production Schedule feel to the Info-Schedule of Plant Machinery resources. Submitted patch to core at JIRA http://idempiere.atlassian.net/browse/IDEMPIERE-3029

ResourceAssignmentByType.png (37.61 KiB) Viewed 16397 times

Now by selecting the '*' for all resources listed within a resource type, their time schedule assignments can be shown on the same calendar. It will toggle its background colour if so.

ResourceOverlap.png (35.83 KiB) Viewed 16397 times

It can also overlap each other and the colour toggling helps to differentiate them.

[red1]

I have followed through the whole process (for the first time ever actually) leading to the Order Receipts Issue and then Cost Collector completion and seeing all the results. There is another pre requisite to do in order to reach Cost Collector - set the Accounting Schema to Standard Costing.
From the last MRP Info window, the generated requisitions are in separate docs but can be easily consolidated by Requisition to invoice > Create PO From Requisition

RequisitionsConsolidatePO.png (69.78 KiB) Viewed 16478 times

Then, the single PO with all the generated requests is processed and Material Receipts done so that they are in stock. You can use the BOM Configurator to easily act as a viewer:

BOMConfigView.png (47.6 KiB) Viewed 16478 times

Now we call the Order Receipt & Issue to examine the Manufacturing Order details and put in Movement Date, Warehouse Locator, and exact usage that may differ from calculated:

OrderReceiptIssue.png (145.57 KiB) Viewed 16478 times

Then the sub product is selected and press OK for it to process for the Cost Collector:

CostCollector.png (99.35 KiB) Viewed 16478 times

You can check back the MRP Info to see the MRPs are closed. They can then be deleted in the next round.

AfterIssueReceipt.png (120.04 KiB) Viewed 16478 times

You can also see the Accounting Consequence:

AccountingConsequence.png (98.28 KiB) Viewed 16478 times

[red1]

[red1]

[red1]

[johnbendi]

[red1]

Hi John Bendi, thank you so much for your report. Please can you put it in the and follow the linked in the google group welcome message. Please make sure you have follow all the tests and setup steps as avoiding them may cause such erorrs. If so, then i will debug it and reply there.

My forum here is preferred for users / developers who share fixes and code as part of the Free as in Freedom policy of FOSS.

[red1]

Rifatul has discovered bugs during his testing and suggested remedies. Confirmed and committed together with reverting an earlier solution which i realised was wrong as Low Level is to be processed in separate PP_Order (Mfg Order). http://groups.google.com/forum/#!topic/ ... 5hUJNhsCII

Source: http://bitbucket.org/red1/org.lib.mfg4
Binary: http://sourceforge.net/projects/red1/fi ... facturing/