Compiere provides flexible material policy (FIFO/LIFO) at Company/product category/product level

tenthplanet blog compiere Compiere provides flexible material policy FIFO LIFO at Company product category product level

What is Material policy ?

Material Policy defines the movement of goods from the warehouse. In the warehouse, products are arranged in lots. First, we need to define the material policy so during shipment product is picked from the warehouse based on the material policy. If we do not define the material policy then products are picked up randomly by the users so we don’t have control over the movement of goods.

Compiere provide us following material policy which is used during shipment generation to pick the products. Material policy is based on the movement date.

  1. FIFO – First In First Out (Product which comes in first will goes out first).
  2. LIFO – Last In First Out (Product which comes last will goes out first).

Material policy can be configured at the product category level if it is not configured then it will use the material policy configured in the Tenant screen.

For the both material policy, it is possible to pick the goods based on Product expiry value. i.e. During shipment products with early expiry will be processed first. If the expiry date is not provided then it will check for the Lot Priority No and finally, it will look for Lot creation value which in turn based on Material policy i.e. Either FIFO/LIFO.

Compiere Material policy will give the control over the movement of goods. With Product Expiry combination, it will not allow sending the expiry goods to the customers.

If the Product has lot & expiry date, then Compiere generate the Customer Shipment as per below table.

Shelf Life Configured in Business Partner Screen
ProductLotEx DateShelf LifeBPMovement DateExpected Shelf LifeActual Shelf LifeResult
WOOD 3X4Lot131/10/1718045.00%02/08/1740090Not Allow to create Shipment
Lot230/09/1718045.00%02/08/1740059Not Allow to create Shipment
Lot330/10/1818045.00%02/08/17400454Allow to create Shipment
Shelf Life not Configured in Business Partner Screen
LotEx DateShelf LifeBPMovement DateExpected Shelf LifeActual Shelf LifeResult
WOOD 3X4Lot131/10/1718002/08/179090Allow to create Shipment
Lot230/09/1718002/08/175959Allow to create Shipment
Lot330/10/1818002/08/17454454Allow to create Shipment

Expected Shelf life Formula:

Shelf Life *100/BP => 180*100/45% =>400

Actual Shelf Life formula:

Expiry Date-Movement Date => 31/10/17 – 02/08/17=>90

compiere_customization