Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : mWtY2AupkEPnQ561XeMmbV
Small and medium business | Business Central, N...
Answered

Transfer Lot Controlled Item to not Lot Controlled Item based on expiration date

Like (0) ShareShare
ReportReport
Posted on 17 Nov 2022 18:34:02 by 15,435

Hi

This is kind of strange case. We have some "lot controlled" items but we have "alternative" items for them that they are not lot controlled items. We only sell "none lot controlled" items. At the moment we sort "lot controlled" items based on their expiration date. Then we use Item Journal and take them out of inventory. Than we add them back as "none lot controlled" items. Then sell them. 

I am struggle for the method that let us to handle this situation better. 

Any suggestion here will help. 

Also, any method or ISV or Power Automation to automate our current process if we have no other way except our current process?

Thanks 

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,005 Moderator on 17 Nov 2022 at 19:58:01
    RE: Transfer Lot Controlled Item to not Lot Controlled Item based on expiration date

    So basically they use the lot handling only for the physical handling of the inventory.

    pastedimage1668715013436v1.png

    So can't you just define that the sales transactions does not require lot no.

    Then they can sell without assigning lot no. and the inventory will be reduced according to the fifo method?

  • MahGah Profile Picture
    15,435 on 17 Nov 2022 at 19:37:22
    RE: Transfer Lot Controlled Item to not Lot Controlled Item based on expiration date

    Thanks NorthW

    That was my question. These are "plant" products. the only purpose of LOT is to reflect their age and not other purposes. Hence, when they sell "lot" has no value and they can mix of lots" But "lots" utilized to keep track of expire date to know these products are mature enough to sell (close to expire date means they are mature). In one SO they can sell 100 lots which is really time consuming to enter them all. They convert all lots to one none-lot for this purpose.

    I hope this makes sense.  

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,005 Moderator on 17 Nov 2022 at 19:09:51
    RE: Transfer Lot Controlled Item to not Lot Controlled Item based on expiration date

    The obvious answer here i guess would be to sell the lot controlled item directly but exempt the sales transaction from being lot controlled if that is the issue.

    But why can you not or don't you want to use lot control through the whole business process?

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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,435 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,567 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading complete