Announcements
No record found.
Encountered this error possibly from reclassifying item that had no expiry date to an existing lot.
now I cannot do anything with this lot. Have tried to reclass and it gives me the same error.
any ideas would be a great help solving this
Hi,
This standard system error. You cannot assign multiple expiration in one lot.
Do one thing, Negative entry via Item Journal and then post Positive entry via Item Journal with correct Expiration Date.
Regards
Amit Sharma
www.erpconsultors.com
https://www.linkedin.com/in/amit-sharma-94542440/
Press Yes if info is useful
Thanks for the response, I have tried the warehouse item journal and then item journal but when I try post it gives me the same error.
Do one think update Expiration via AL code. Means develop one utility for updating Expiration Date directly in Posted Tables.
This is not recommended. but this is the final
www.linkedin.com/.../
Press Yes if info is useful.
Okay thank you for the answer, it’s quite surprising that this needs dev to fix for such a small problem.
What’s the best resource to learn how to do this with AL?
Refer the below website for learning D365 Functional & Technical :
Hi, have you tried Item Reclass. Journal? Can it be posted?
How to: Reclassify Lot Numbers and Serial Numbershttps://learn.microsoft.com/en-us/previous-versions/dynamicsnav-2013r2/hh168055(v=nav.71)
Hope this helps.
Thanks.
ZHU
Hi Zhu yes I have tried this but it gives me the same error.
The problem is that the inventory without expiry date is mixed in the same bin.
I am using advanced warehousing so it’s the warehouse reclassification journal.
Are You sure You reclassified all entries with that Lot No.
Seems that You might added expiration date only to part of the Lot.
Expiration dates needs to be adjusted for all items with the same Lot No. otherwise You can get stuck like now.
Try to reclassify remaining items in Lot. to the same expiration date, or zero inventory for this Lot No. and then add it back in with correct expiration date.
So i checked the items bin locations and filtered by the lot and then create the warehouse reclassification journal and made sure everything was reclassed with the same expiry date.
It does not seem to fix the issue. I still get the error that there are multiple expiry dates for the item. Also when I check availability by lot it still shows the 1 lot with no expiry date.
I am trying to build a report to update all the lot expiry dates.
So I managed to create a codeunit to update the expiry dates and it worked. Here is the code for anyone if they ever experience the same issue :
codeunit 50108 "Update Expiration Date CU" { Permissions = Tabledata "Item Ledger Entry" = rm; procedure UpdateExpirationDate() var ItemLedgerEntry: Record "Item Ledger Entry"; begin ItemLedgerEntry.Reset(); ItemLedgerEntry.SetRange("Item No.", 'YOUR ITEM NO','YOUR ITEM NO'); ItemLedgerEntry.SetRange("Lot No.", 'YOUR LOT NO','YOUR LOT NO'); ItemLedgerEntry.ModifyAll("Expiration Date",20250201D); //DATE FORMAT YYYYMMDD with D at the end end; }
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 1,850 Super User 2026 Season 1
YUN ZHU 1,045 Super User 2026 Season 1
Dhiren Nagar 959 Super User 2026 Season 1
