Inventory Batches

Inventory batches represent a number of inventory items that need to be grouped and traced a such. Each batch of inventory, of the same product type, may differ. Think of the expiry date the product has, the color that was used to paint the item, the location the product was made, the purchase price or the type of material that was used.

Why use Inventory Batches?

There are a number of reasons why it is important to know the differences in the products, especially when products are sold to your customers.

Batches will enable you to

  • Track expiry dates
  • Analyze return rates for certain batches
  • Answer customer questions about differences between products
  • Make more accurate reports on revenue, profit margin reports, Simple Moving Average (SMA) and more

Furthermore, inventory batches will allow you to set up specific strategies, such as LIFO, FIFO, and FEFO.

Strategies with Inventory Batch Tracking

Smart inventory management is crucial for any product-oriented business. FIFO, LIFO, and FEFO are common inventory methods. The strategy you choose will have profound effects on logistics and profitability. These are the major differences between the three:

FIFO, LIFO, FEFO

A “First In First Out” strategy implies that products that came in first, will move out first. Fifo is mainly used by companies that sell fast-moving products.

“Last In First Out”, means that products that came in last, move out first. Lifo is mainly used in cases where products do not have a shelf life.

The “First Expired First Out” method is used for products that have an expiry date. In this case, the product with the closest expiry date moves out first.

How Batch Tracking works in Marello

To understand how Marello allows for inventory batch tracking, let’s take a look at how inventory is tracked:

  • Each product has an inventory item
  • Each inventory item has one or more inventory levels

Inventory levels are tracked in real-time and determine how many products are available in warehouses. Inventory batches add an extra layer to inventory levels.

  • Each inventory level is subdivided into inventory batches

Working with Inventory Batches

Enabling Inventory Batches

For each inventory item, batch tracking can be enabled. Once batch tracking is enabled, it cannot be reversed.

Enabling Batch Inventory on an Inventory Item

Tracking Batches

Inventory batches are updated in real-time. Each time inventory moves, inventory levels in batches will shift. It is possible to see which inventory batches are available in each of your warehouses.

Purchase Orders and Inventory Batch Numbers

Inventory Batch numbers are assigned each time new inventory comes in. When inventory is moved to a new location (replenishment), batch numbers will remain assigned to the moving inventory. When the batch number is already known at the new location, the moved inventory batch will be merged. Inventory movements may either come in through automated processes, by importing files, or by manually adapting inventory batch data.

Batch Information

Each batch has its own distinct information. This includes a batch number, purchase price, purchase date, and expiry date.

Setting Inventory Strategies in Marello

How to allow for inventory strategies such as FIFO, LIFO, and FEFO in Marello?

Warehouse Fulfillment Allocation Rules

Marello includes a comprehensive workflow engine, in which fulfillment rules can be set. In Marello, these are called “WFA Rules” or “Warehouse Fulfillment Allocation Rules”. These rules determine which conditions should be taken into account when assigning inventory to fulfill an order. To allow for FIFO, LIFO or FEFO, rules can be set according to conditions such as “receive date” or “expiry date”. In that way, Marello will always calculate the right inventory to use to fulfill orders, tailored to your preferred strategy.

It is also possible to extend your LIFO, LIFO or FEFO strategy with rules such as first choosing the nearest warehouse and checking the batches in the chosen warehouse.

Some examples of inventory strategies in which Marello checks:

  • all available inventory and chooses to fulfill an order with inventory that came in last (LIFO)
  • all available inventory and chooses to fulfill an order with inventory that came in first (FIFO)
  • all available inventory and chooses to fulfill an order with inventory that has the closest expiry date (FEFO)
  • what warehouse is closed to the customer, whether the inventory to fulfill the order is available, and then selects the right inventory according to LIFO, FIFO or FEFO
  • what warehouse is capable of fulfilling the whole order (no split-shipment), and then selects the right inventory according to LIFO, FIFO or FEFO
  • what warehouses are needed to fulfill the whole order (split-shipment), and then selects the right inventory according to LIFO, FIFO or FEFO in those separate warehouses

Working with Inventory Batches in Marello 

Understanding Warehouse Fulfillment Allocation (WFA)

Working with WFA rules in Marello

Updated on April 23, 2020

Was this article helpful?

Related Articles

Leave a Comment