Skip to main content

Notifications

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

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

Posted on by 15,426

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
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    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
    MahGah 15,426 on at
    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
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans