Difference between revisions of "Sponsored Development: Libero Distribution Resource Planning"

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
(Requirements)
m
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
===Project Team===
+
=Proposal=
 +
To introduce a [[Libero]] DRP (Distribution Resource Planning into the [[ADempiere]] suite of manufacturing related features.
  
====Coordinator====
+
=Project Team=
 +
 
 +
==Coordinator==
 
[mailto:victor.perez@e-evolution.com Victor Perez]
 
[mailto:victor.perez@e-evolution.com Victor Perez]
  
====Functional Disaing====
+
==Functional Design==
 
*Victor Perez (contribute with work) of e-Evolution
 
*Victor Perez (contribute with work) of e-Evolution
  
====Developers====
+
==Developers==
 
*Victor Perez (contribute with work) of e-Evolution
 
*Victor Perez (contribute with work) of e-Evolution
  
====Testers====
+
==Testers==
  
 
*Victor Perez (contribute with work) of e-Evolution
 
*Victor Perez (contribute with work) of e-Evolution
  
====Sponsors====
+
==Sponsors==
  
 
*[http://www.e-evolution.com e-Evolution,SC (with work)]
 
*[http://www.e-evolution.com e-Evolution,SC (with work)]
Line 20: Line 23:
 
others welcome
 
others welcome
  
===Overview===
+
=Overview=
[[Image:DRP.pdf|Libero DRP in spanish]]
+
[http://www.adempiere.com/wiki/images/5/50/DRP.pdf DRP in Spanish]
  
===Requirements===
+
=Requirements=
  
 
'''Distribution Resource Planning''' (DRP) is a method used in business administration for planning orders within a supply chain. DRP enables the user to set certain inventory control parameters (like a safety stock) and calculate the time-phased inventory requirements.
 
'''Distribution Resource Planning''' (DRP) is a method used in business administration for planning orders within a supply chain. DRP enables the user to set certain inventory control parameters (like a safety stock) and calculate the time-phased inventory requirements.
Line 40: Line 43:
 
*the on-hand inventory at the beginning of a period.
 
*the on-hand inventory at the beginning of a period.
  
==Distribution Order==
+
=Distribution Order=
  
===Approach ===
+
==Approach ==
  
 
I am analyzing what is best way to management the transit inventory?  
 
I am analyzing what is best way to management the transit inventory?  
Line 95: Line 98:
 
[http://sourceforge.net/forum/message.php?msg_id=4550660 the discussion here ]
 
[http://sourceforge.net/forum/message.php?msg_id=4550660 the discussion here ]
  
==Implementation==
+
=Implementation=
  
 
[[Image:EE04.png]]
 
[[Image:EE04.png]]
  
===Distribution Management Menu===
+
==Distribution Management Menu==
  
 
* New menu are here:
 
* New menu are here:
Line 105: Line 108:
 
[[Image:DistributionManagement.png]]
 
[[Image:DistributionManagement.png]]
  
===Distribution Order Window===
+
==Distribution Order Window==
  
 
[[Image:DistributionOrder.png]]
 
[[Image:DistributionOrder.png]]
  
===Generate Movement (Manual) Form ===
+
==Generate Movement (Manual) Form ==
  
 
[[Image:GenerateMovementManual.png]]
 
[[Image:GenerateMovementManual.png]]
  
===Generate Movement Receipt Form ===
+
==Generate Movement Receipt Form ==
  
 
[[Image:GenerateMovementReceipt.png]]
 
[[Image:GenerateMovementReceipt.png]]
  
===Generate Movement Process===
+
==Generate Movement Process==
  
 
[[Image:GenerateMovement.png]]
 
[[Image:GenerateMovement.png]]
  
===New Inventory Movement Window ===
+
==New Inventory Movement Window ==
  
 
[[Image:InventoryMovement.png]]
 
[[Image:InventoryMovement.png]]
  
==Reference:==
+
=Reference:=
  
[http://en.wikipedia.org/wiki/Distribution_Resource_Planning Distribution Resource Planning]
+
[http://en.wikipedia.org/wiki/Distribution_Resource_Planning DRP article in Wikipedia]
  
 
[http://en.wikipedia.org/wiki/Manufacturing_resource_planning Manufacturing Resource Planning]
 
[http://en.wikipedia.org/wiki/Manufacturing_resource_planning Manufacturing Resource Planning]
Line 133: Line 136:
 
[http://www.adempiere.com/wiki/index.php/Libero Libero MRP II to ADempiere]
 
[http://www.adempiere.com/wiki/index.php/Libero Libero MRP II to ADempiere]
  
[http://www.businessdictionary.com/definition/distribution-resource-planning-DRP-II.html Distribution Resource Planning]
+
[http://www.businessdictionary.com/definition/distribution-resource-planning-DRP-II.html DRP article in Business Dictionary]
  
 
[[Category:Development]]
 
[[Category:Development]]
 
[[Category:Features]]
 
[[Category:Features]]

Latest revision as of 23:18, 1 April 2010

Proposal

To introduce a Libero DRP (Distribution Resource Planning into the ADempiere suite of manufacturing related features.

Project Team

Coordinator

Victor Perez

Functional Design

  • Victor Perez (contribute with work) of e-Evolution

Developers

  • Victor Perez (contribute with work) of e-Evolution

Testers

  • Victor Perez (contribute with work) of e-Evolution

Sponsors

others welcome

Overview

DRP in Spanish

Requirements

Distribution Resource Planning (DRP) is a method used in business administration for planning orders within a supply chain. DRP enables the user to set certain inventory control parameters (like a safety stock) and calculate the time-phased inventory requirements.

DRP uses several variables:

  • the on-hand inventory at the end of a time period.
  • the backordered demand at the end of a time period.
  • the required quantity of product needed at the beginning of a time period.
  • the constrained quantity of product available at the beginning of a time period.
  • the recommended order quantity at the beginning of a period.

DRP needs the following information:

  • the demand in a future time period.
  • the scheduled receipts at the beginning of a time period.
  • the safety stock requirement for a period.
  • the on-hand inventory at the beginning of a period.

Distribution Order

Approach

I am analyzing what is best way to management the transit inventory?


Situation:

  • In a retail industry the environment are conform by multiple warehouses, each warehouse need management his own Reservation, On hand inventory , generality a store warehouse get the supply from central warehouse, so is necessary to management the requirement supply as Distribution Order.
  • the distribution order should to have next information shipper, promised date, ship to , product , qty to transfer. warehouse source , warehouse transit , warehouse target , etc., with this new document we can create distribution order. between warehouse and have the management of internal supply.


New functionality proposed :

  • The functionality to management this need is crate a new document called distribution order where we set the warehouse source, warehouse transit and warehouse target, the store create a new distribution order to item that need supply to support you demand.
  • Also is necessary a good control of back order, promise date.
  • when a distribution order is completed the system generate a inventory move with a move confirmation from warehouse source to warehouse transit , you entry the real quantities that you send from warehouse central to warehouse target, it movement generate the transaction the issue to each item and inventory on-hand is updated.
  • When the material is receipt in warehouse target you entry the qty confirm into the move confirmation and when the confirmation is completed the System generate a inventory move from warehouse transit to warehouse target, also here the are generate the transaction and on-hand is updated.
  • The new distribution order allow future new functionality to MRP or DRP (Distribution Requirement Plan).


Current functionality:

current Adempiere only management inventory move & move confirmation, but the functionality is very limit.

Issue with the current functionality:

  • 1.- current do no exist a control the back order , the quantities in transit , promise date to each item, do no is possible management the demand and supply between warehouses .
  • 2.- the current approach do not update the on-hand until you complete the move confirmation, it is big issue because the material in transit can take 2 to 5 days to been deliver, while it time the inventory do not show the real on-hand inventory.

here I want start a debate to know what is your perspective this subject.


The 2 way to solve it issue is :

  • 1.- Modify the current functionality to support some way the back order , the quantities in transit , promise date and solve the issue with qty on-hand
  • 2.- Create a new document called Distribution Order to management it business process.

Any comment or idea are welcome!

Victor Perez

CEO

http://www.e-evolution.com

the discussion here

Implementation

EE04.png

Distribution Management Menu

  • New menu are here:

DistributionManagement.png

Distribution Order Window

DistributionOrder.png

Generate Movement (Manual) Form

GenerateMovementManual.png

Generate Movement Receipt Form

GenerateMovementReceipt.png

Generate Movement Process

GenerateMovement.png

New Inventory Movement Window

InventoryMovement.png

Reference:

DRP article in Wikipedia

Manufacturing Resource Planning

Libero MRP II to ADempiere

DRP article in Business Dictionary