Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Business Central - Assigning lots with expiry date rules

(0) ShareShare
ReportReport
Posted on by 5

Hello! 


When creating sales invoices in Business Central, I would like to set rules around assigning lots/batches to sales invoices. 

Some customers will only accept our product if there are a certain amount of days left on the expiry date when we deliver their order to them. For example, there must be 145 days left on the expiry date on the day that we deliver the order to them, otherwise they will reject the whole order.

The qty of days will be the same for all products that we supply to them. I.e. if we supply bread, cereal and biscuits, each of those items will need to adhere to the 145 days left on expiry rule. 

Is there any way I can set these rules up in Business Central, whether it's at the Customer card or Item card level? I just want to eliminate any chance of human error. It is best if Business Central will not allow an employee to assign a batch to a sales invoice if it doesn't fit within the rule. 


Thank you 

  • Suggested answer
    YUN ZHU Profile Picture
    79,097 Super User 2025 Season 1 on at
    RE: Business Central - Assigning lots with expiry date rules

    Hi, yes, a field can be added to the customer card, the number of days. For example, you can set 145 days for customer A and 120 days for customer B. If it is empty, it means that no control is required.
    In addition, if the customer has 145 days or 120 days at the same time, you can consider adding this field to the order.

    Hope this helps.

    Thanks.

    ZHU

  • Bonnie Bon Profile Picture
    5 on at
    RE: Business Central - Assigning lots with expiry date rules

    Hi Zhu

    Thanks for taking the time to check this out for me. It is definitely a point in the right direction!

    Do you know if this will be customer specific? I.e. some customers have no requirements around BB dates, some have 145 days, some have 120 days.

  • Suggested answer
    YUN ZHU Profile Picture
    79,097 Super User 2025 Season 1 on at
    RE: Business Central - Assigning lots with expiry date rules

    Hi, I feel like this needs to be customized.

    First you need to add expiry date on Lot No. Information Card.
    Then, when selecting the Lot No. on sales invoices or sales orders, the system will automatically judge whether the expiration date is within 145 days. If so, it will prompt an error and cannot be selected.

    pastedimage1670369857048v1.png

    Just an idea, hope it gives you some help.

    Thanks.

    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,207 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans