Lot and Serial Count Reconciliation for Microsoft Dynamics 365 Business Central
Counting lot- and serial-tracked items is only half the job. The adjustment then has to say which lots or serial numbers were short or over, and working that out by hand from hundreds of lots is slow and easy to get wrong. Advanced Inventory Count reconciles lot and serial number differences automatically and sets the item tracking lines for the adjustment.
Advanced Inventory Count runs on its own for counts entered in Business Central, and works with Warehouse Insight or WMS Express, Insight Works' mobile warehouse apps, for counting on handheld barcode scanners.
How Lot and serial count reconciliation works in Advanced Inventory Count
- Count sheets are generated, with expected lot or serial numbers where the setup allows.
- Counters record each lot or serial number they find, on paper or by scanning.
- The supervisor reviews lot-level differences in the difference reports.
- With Set Item Tracking Lines on, Copy Count to Journals adds the item tracking lines and any lot reclassifications.
- Accounting runs the journal test report and posts the adjustments.

Key capabilities
Set item tracking lines
With Set Item Tracking Lines turned on, Copy Count to Journals adds the lot and serial numbers each adjustment needs. Nobody keeps a separate list of which lots were counted.
Shortages worked out for you
If Business Central expects 100 lots and 80 are counted, the adjustment needs the 20 that were not found. Advanced Inventory Count works that out from the lots that were counted.
Lot swaps as reclassifications
When the right quantity is counted under a different lot number, such as lot 2 instead of lot 1, the count can post a reclassification from one lot to the other instead of a shortage and an overage. A reclassification journal batch is set on the count card for this.
Expected lots on the sheet
Where the Business Central setup allows, count sheets show the lot or serial numbers expected in each bin, so counters confirm them or add new ones.
Lot detail in the reports
The difference reports break each tracked item down to lot number shortages and extras, so problems are visible at lot level before posting.
Tracking in every configuration
Lot and serial reconciliation works with or without bins and with directed put-away and pick, whether or not warehouse lot tracking is on. See Counting With or Without Bins.
See Lot and serial count reconciliation on screen
Real screens from Advanced Inventory Count, shown with demo data.
Details that matter on the floor
Count what is there
Counters record the lots and serial numbers they find. They do not have to work out which ones are missing, because the reconciliation does that.
Fewer adjustments that cancel out
Posting a lot mix-up as a reclassification keeps the inventory value unchanged and records what happened, instead of a write-off on one lot and a write-on on another.
Who uses Lot and serial count reconciliation
Inventory managers
Reconcile lot- and serial-tracked stock without manual tracking entry.
Quality control managers
Keep lot and serial traceability accurate after every count.
Financial controllers
Post adjustments that carry the right item tracking.
Questions about Lot and serial count reconciliation
Does Advanced Inventory Count reconcile lot numbers automatically?
Yes. With Set Item Tracking Lines turned on, it sets the lot and serial numbers on the adjustments when the count is copied to the journals.
Do we have to enter the lots we did not find?
No. Advanced Inventory Count works out the missing lots and serial numbers from the ones that were counted.
What happens if we count the right quantity under the wrong lot number?
The count can post a reclassification from one lot to the other, using the reclassification journal batch set on the count card, instead of a shortage and an overage.
Does it need warehouse lot tracking turned on?
No. Lot-level differences are shown whether or not warehouse lot tracking is turned on.
Related Advanced Inventory Count features
All Advanced Inventory Count features →Part of Advanced Inventory Count
Finish inventory and cycle counts sooner in Business Central with barcodes and multi-user entry.
Have a question about Lot and serial count reconciliation?
Send us a note and the Advanced Inventory Count team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
