Food, chemical, and pharmaceutical warehouses track lots for a reason: expiration dates. A count that finds stock under the wrong lot number has to fix more than the quantity. If the lots expire on different dates, the expiration date has to follow the stock. In Microsoft Dynamics 365 Business Central, this came up as a question in a recent webinar on inventory counts.
How the reclass handles expiration dates
Advanced Inventory Count can turn offsetting lot differences into reclass entries instead of negative and positive adjustments. For example, you count 20 of lot one instead of 20 of lot two in the same bin. The reclass changes the lot number to match.
The question was whether the reclass also adjusts the expiration date. Yes. If the lot number has a different expiration date, the reclass adjusts that expiration date as well.
Expiration dates on the count sheet
You can enter expiration dates on count sheet lines, along with lot, serial, and package numbers, on the scanner or in Business Central.
What you can’t do is have different expiration dates for the same lot number in Business Central. One lot carries one expiration date.
Positive adjustments
Sometimes a count leads to a positive adjustment for a lot rather than a reclass. Then Advanced Inventory Count uses the latest expiration date it finds for that lot.
Why this matters at count time
Without automatic reconciliation, fixing a lot mix-up means working out by hand which lot is short, which is over, and what dates apply. The standard physical inventory journal asks you to enter the lots that need adjusting, not the lots you counted.
With Advanced Inventory Count, the count sheet records the lots you actually found. The reconciliation works out the differences, and the reclass keeps quantities, lots, and expiration dates aligned when you post.
A good practice
Review lot differences before you transfer the count to the journals. The difference review can show lot, serial, and package number issues sorted by value, so you can send questionable lines to a recount sheet first. Recounts keep an audit trail of the original count and every recount.
Relevant Tools
Advanced Inventory Count is the main tool for this question. It reconciles lot, serial, and package numbers automatically and creates reclass entries that carry expiration dates with the stock.
Warehouse Insight captures lot and serial numbers on handheld devices during scanner counts, including lots printed as text on supported devices.