# Field Sell-by date is required MRP - Error when completing Manufacturing Order

**URL:** <https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745>\
**Category:** PM modules\
**Tags:** Issue, Help\
**Created:** [December 18, 2024, 11:57pm UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745 "2024-12-18T23:57:56Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![gustavoc](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/76d3ee/32.png) [@gustavoc](https://www.dolibarr.org/forum/u/gustavoc)\
**Post date:** [December 18, 2024, 11:57pm UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/1 "2024-12-18T23:57:56Z")

</div>

I am using Version 20.0.1

I have created a product where I selected fields

Use lot/serial number  
Sell-by date or Eat-by date is mandatory

I created a BOM and then a Manufacturing Order, when I try to Complete my order by pressing “COMPLETE CONSUME ALL” on the manufactured product I cant add the Sell-by nor Eat-by date, only lot number is available. However when I try to save the order I get the error “Field Sell-by date is required MRP”

 ![ErrorDolibarr](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/3/3f6ecdc65b33e1dde4495e0b50eb75e782a05ac3.png)

I created an [order](https://demo.dolibarr.org/mrp/mo_production.php?id=1187) ([Login @ 20.0.1](https://demo.dolibarr.org/mrp/mo_production.php?id=1187)) on the demo site where this can be replicated, just click on COMPLETE AND CONSUME ALL BUTTON and you can add LOT number field but not Eat-By nor Sell-By fields for manufactured product.

---

<div class="post-metadata">

**Author:** ![SalsaTolomei](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/s/3bc359/32.png) [@SalsaTolomei](https://www.dolibarr.org/forum/u/SalsaTolomei)\
**Post date:** [January 18, 2025, 10:08pm UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/2 "2025-01-18T22:08:14Z")

</div>

I have the same problem and I don’t understand how to solve it. did you manage?

---

<div class="post-metadata">

**Author:** ![gustavoc](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/76d3ee/32.png) [@gustavoc](https://www.dolibarr.org/forum/u/gustavoc)\
**Post date:** [January 19, 2025, 4:07pm UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/3 "2025-01-19T16:07:13Z")

</div>

Hello,

I am still working on it, will try via the API to validate if the problem comes from the UI. Will let you know.

---

<div class="post-metadata">

**Author:** ![gustavoc](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/76d3ee/32.png) [@gustavoc](https://www.dolibarr.org/forum/u/gustavoc)\
**Post date:** [January 20, 2025, 4:21pm UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/4 "2025-01-20T16:21:47Z")

</div>

Still the error on newest version of the demo.

Steps to reproduce

1. I created a product (to be manufactured) with serial number, Exp Date and Sell By Date.
2. Create a List of Materials for that product
3. Create a Manufacturing Order for the product
4. When trying to produce all and close order still same error “Field Sell by date and Exp Date are required”

There is no field for entering dates on the Manufacturing order, only field for serial number in the “Items to Produce Table”

 ![dolibarrError](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/f/fe40f51de36f0d0b7da02722a0a0dec2c92adc20.png)

You can check the Order at

[https://demo.dolibarr.org/mrp/mo\_card.php?id=1261](https://demo.dolibarr.org/mrp/mo_card.php?id=1261)

If you try to “PRODUCE ALL” and save you will get the error

---

<div class="post-metadata">

**Author:** ![SalsaTolomei](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/s/3bc359/32.png) [@SalsaTolomei](https://www.dolibarr.org/forum/u/SalsaTolomei)\
**Post date:** [January 22, 2025, 12:19pm UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/5 "2025-01-22T12:19:47Z")

</div>

thank you so much gustavoc for following up on my request. I finally solved it, it was a date issue.  
I deactivated the deadline on the item and activated batch management on the item master data.

---

<div class="post-metadata">

**Author:** ![gustavoc](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/76d3ee/32.png) [@gustavoc](https://www.dolibarr.org/forum/u/gustavoc)\
**Post date:** [January 22, 2025, 3:15pm UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/6 "2025-01-22T15:15:32Z")

</div>

Thanks for the update, so are you able now to enter the Sell By and Expiration Date when you close the Manufacturing Order? Because I still can close the order, I keep getting the error.

---

<div class="post-metadata">

**Author:** ![SalsaTolomei](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/s/3bc359/32.png) [@SalsaTolomei](https://www.dolibarr.org/forum/u/SalsaTolomei)\
**Post date:** [January 25, 2025, 4:53pm UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/7 "2025-01-25T16:53:01Z")

</div>

yes I solved it by deactivating the expiration dates from the item master data and inserting them in the batch management. try to do a check too

---

<div class="post-metadata">

**Author:** ![nev3rmi](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/9de0a6/32.png) [@nev3rmi](https://www.dolibarr.org/forum/u/nev3rmi)\
**Post date:** [January 31, 2025, 6:01am UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/8 "2025-01-31T06:01:20Z")

</div>

Thanks you but 90% this is a bug, it missing a field for adding dates in LOT when create MRP

---

<div class="post-metadata">

**Author:** ![vasile.panciuc](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/vasile.panciuc/32/9322_2.png) [@vasile.panciuc](https://www.dolibarr.org/forum/u/vasile.panciuc)\
**Post date:** [September 14, 2026, 3:30am UTC](https://www.dolibarr.org/forum/t/field-sell-by-date-is-required-mrp-error-when-completing-manufacturing-order/29745/9 "2026-09-14T03:30:15Z")

</div>

Hi,

I came across a similar limitation while working with batch and expiry workflows.

For cases where expiry dates and lot information need to be managed more explicitly, I am developing BatchSafe Pro, a standalone web application focused on material and batch lifecycle management.

It includes:

- Batch / lot identification

- Expiry date tracking

- Material and batch status

- Stock information

- QR-based identification

- Search and filtering

- Role-based access

The application does not replace Dolibarr MRP or its native lot management. The idea is rather to provide an additional structured layer for environments where batch status, expiry and traceability need closer control.

I am also evaluating closer integration with Dolibarr, especially for manufacturing and laboratory workflows involving expiry-controlled materials.

If useful, I can share some screenshots of the current workflow.

Best regards,

Vasile

PanciucSoft
