Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Lot Tracking and FIFO issuing without Expiry Date

(0) ShareShare
ReportReport
Posted on by 2,486

Hi All

I know in advanced warehousing there is an option to FEFO issuing of items. We have lot numbers but no expiry date. Is there any way to set the system so the first CREATED lot number gets allocated on a warehouse pick list? Will FIFO as a costing method help in this scenario? Basic requirement is to create (ideally automatically) lot numbers when receiving and then issue the first created lot first.

Thanks

  • Samantha73 Profile Picture
    Samantha73 2,486 on at
    RE: Lot Tracking and FIFO issuing without Expiry Date

    Awesome.. Thanks guys. Tested and worked well..set date calculation to 0D so expiry date acts as the creation date

  • Verified answer
    Guy McKenzie Profile Picture
    Guy McKenzie 1,330 on at
    RE: Lot Tracking and FIFO issuing without Expiry Date

    Thanks for the mention mahgah.

    You are already looking in the right area.

    Set the pick policy for locations to ‘Pick according to FEFO’

    On the Item Tracking card, set the Use expiration date to true but make sure ‘Strict Expiration Posting’ and ‘Require Expiration Date’ are false.

    On the item card set an expiry date calculation. It can be anything you like. Either a long time in the future or 1D would be my suggestion. 

    Business Central will always apply the same calculation of expiry date upon receipt so expiry dates will naturally reflect the relative age of goods.

    The key thing is that you have set the expiry date on the item tracking to not be an expiration policy so BC doesn’t actually care what the dates are. BC just uses them to suggest the oldest stock (first expiring) on the pick.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Lot Tracking and FIFO issuing without Expiry Date

    Hi Samantha

    Looks like FEFO is required for Bin to work with FIFO logic and automation. Otherwise it will not work. I hope Ben Baxter  or Guy McKenzie  can provide more info. 

    Below section of blog mention this:

    www.olofsimren.com/.../

    See below topic for the same conversation and possible development solution for this request

    community.dynamics.com/.../fifo-bin-replenishment-fifo-picking---not-possible

    And below for more info. See  Steven's comment

    community.dynamics.com/.../fifo-functionality

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans