Lot and Serial Number Import for Microsoft Dynamics 365 Business Central
Opening inventory for lot- and serial-tracked items is slow to load, because each journal line needs item tracking entered before it can post. Import Export PowerTool creates the lot and serial number entries automatically when you import item journal lines that carry them. This is a completely free app from Insight Works for Business Central.
How Lot and serial number import works in Import Export PowerTool
- Prepare an item journal import file with the journal template, batch, item, location, quantity, and lot or serial number for each line.
- Mark the fields to validate with an asterisk.
- Import the file with Import Export PowerTool; the lot and serial number entries are created with the journal lines.
- Review the journal and its item tracking in Business Central.
- Post the item journal.

Key capabilities
Tracking from the file
Add the lot number or serial number as a column on each item journal line in the import file. Import Export PowerTool creates the matching item tracking entries as it imports the lines.
Opening inventory in one pass
Item, location, quantity, and tracking all come from the same file, so an opening balance for tracked items loads without entering tracking line by line.
Validation on the key fields
Mark fields such as the item number and quantity with an asterisk so Business Central validates them and fills in the related fields. See Field Validation.
Posted through the journal
The lines land in an item journal batch, and the journal is posted in Business Central, so ledger and value entries are created by standard posting.
See Lot and serial number import on screen
Real screens from Import Export PowerTool, shown with demo data.
Details that matter on the floor
One serial number per line
For serial-tracked items, each journal line in the file carries one serial number with a quantity of one, as the sample import file shows.
Review before posting
Because the lines land in a journal, the opening balance can be checked in Business Central before anything posts.
Who uses Lot and serial number import
Business Central consultants
Load opening inventory for tracked items at go-live.
Inventory and warehouse leads
Check the imported journal and its tracking before it posts.
Data migration specialists
Bring lot and serial balances across from a legacy system.
Questions about Lot and serial number import
Can I import lot and serial numbers into Business Central?
Yes. With Import Export PowerTool, item journal imports that include lot or serial numbers create the item tracking entries automatically, which is the intended path for an opening inventory load.
Do I still post the journal?
Yes. The import creates journal lines with their tracking; you review and post the item journal in Business Central.
Does this work for both lots and serial numbers?
Yes. Lot numbers and serial numbers are both created automatically on item journal imports.
Related Import Export PowerTool features
All Import Export PowerTool features →Part of Import Export PowerTool
Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.
Have a question about Lot and serial number import?
Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
