web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Transfer Lot Controlle...
Small and medium business | Business Central, N...
Answered

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

(0) ShareShare
ReportReport
Posted on by MahGah 15,511

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 

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,035 Moderator 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,511 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 1,035 Moderator 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,899 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,444

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,304

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans