FEFO removal

The First Expired, First Out (FEFO) removal strategy targets products for removal based on their assigned removal dates.

Enabling the FEFO removal strategy

Lots and serial numbers differentiate identical products and track information like arrival or expiration dates. To enable this feature, navigate to Inventory ‣ Configuration ‣ Settings. Under the Traceability heading, check the box beside Lots & Serial Numbers. After Lots & Serial Numbers is enabled, the Expiration Date feature appears. Enable it to track expiration dates, best-before dates, removal dates, and alert dates.

Enable Lots & Serial Numbers and Expiration Dates in the Inventory settings.

Enable tracking by lots or serial numbers

Next, ensure the intended product is tracked by lots or serial numbers by navigating to the product form through Inventory ‣ Products ‣ Products and selecting the desired product. On the product form, open the General Information tab and select the check box next to the Track Inventory field, then select either By Unique Serial Number or By Lots.

Enable tracking by lot.

Setting dates

Next, set the Expiration Date, Best Before Date, Removal Date, and Alert Date settings for the product. In the Inventory tab of the product form, under the Traceability heading, select the Expiration Date check box. The Dates heading appears. See Removal date for more information.

Assigning lots and serial numbers

After enabling the features, assign lot or serial numbers to products using an inventory adjustment or during product reception.

Setting removal strategies

After lot or serial numbers have been assigned, set the removal strategy on the storage location or product category.

Find the Locations or Categories from the Configuration menu.

On the location

Open Inventory app ‣ Configuration ‣ Locations. Select the desired location. On the location form, under the Logistics heading, select First Expiry First Out (FEFO) from the list of removal strategies.

Set First Expiry First Out as the location removal strategy.

On the product category

Configure removal strategies on product categories by going to Inventory app ‣ Configuration ‣ Categories and selecting the intended product category. Next, in the Force Removal Strategy field, specify First Expiry First Out (FEFO).

Set First Expiry First Out as the product category removal strategy.

Important

When there are different removal strategies applied on both the location and product category for a product, the value set on the Force Removal Strategy field set on a product category form is applied as top priority.

Removal date

Products must be removed from inventory before their removal date, which is set as a certain number of days before the product’s expiration date.

The user sets this number of days by navigating to the product form’s Inventory tab. Under the Traceability section, ensure the Tracking field is set to either By Lots or By Unique Serial Number.

Next, select the Expiration Date option, which makes the Removal Date field (and other date fields) appear.

Important

The Lots and Serial Numbers and Expiration Dates features must be enabled in Inventory app ‣ Configuration ‣ Settings to track expiration dates.

The expiration date of a product is determined by adding the date the product was received to the number of days specified in the Expiration Date field of the product form.

The removal date takes this expiration date, and subtracts the number of days specified in the Removal Date field of the product form.

Example

In the Inventory tab of the product, Egg, the following Dates are set by the user:

  • Expiration Date: 30 days after receipt

  • Removal Date: 15 days before expiration date

Display expiration and removal dates set on the product form.

A shipment of Eggs arrive at the warehouse on January 1st. So, the expiration date of the Eggs is January 31st (Jan 1st + 30). By extension, the removal date is January 16th (Jan 31 - 15).

To view the expiration dates of items in stock, go to Inventory app ‣ Products ‣ Lots / Serial Numbers. By default, this report is grouped by location. If necessary, remove that grouping in the search bar and group by product. Expand the product to show its lots. Next, click the (settings adjust) icon, located on the far-right, and select the columns: Expiration Date and Removal Date.

Show expiration dates from the Lots / Serial Numbers list.

Alternatively, view these dates by clicking the Lot/Serial Numbers smart button on the product form.

Show expiration dates from the Lots/Serial Numbers list on the product form.

Workflow

Using the FEFO removal strategy ensures that products with the nearest removal date are picked first.

To understand how this removal strategy works, consider the following example below about the product, Carton of Eggs, which is a box containing twelve eggs.

The product is tracked By Lots, and the product category’s Force Removal Strategy is set to First Expiry First Out (FEFO).

LOT1

LOT2

LOT3

On-hand stock

5

2

1

Expiration date

January 8, 2026

January 15, 2026

January 22, 2026

Removal date

December 24, 2025

December 31, 2025

January 7, 2026

To see the removal strategy in action, go to the Sales app and create a new quotation.

Clicking Confirm creates a delivery order for today, December 9th, and the lot numbers with the soonest expiration dates are reserved, using the FEFO removal strategy.

To view the detailed pickings, click the Details link, located on the far-right of the Carton of Eggs’ product line, in the Operations tab of the delivery order. Doing so opens the Detailed Operations pop-up window.

In the Detailed Operations pop-up window, the Pick From field displays where the quantities to fulfill the Demand are picked from.

Since the order demanded six Cartons of Eggs, using the FEFO removal strategy, all five Cartons from LOT1, with the removal date of December 24, are picked. The remaining Carton is selected from LOT2, which has a removal date of December 31.

The detailed operations window that shows the lots to be removed using FEFO.