Skip to content
Import Export PowerTool app iconImport Export PowerToolImport

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

  1. Prepare an item journal import file with the journal template, batch, item, location, quantity, and lot or serial number for each line.
  2. Mark the fields to validate with an asterisk.
  3. Import the file with Import Export PowerTool; the lot and serial number entries are created with the journal lines.
  4. Review the journal and its item tracking in Business Central.
  5. Post the item journal.
Video thumbnail: Import items, item journals, and sales history with Import Export PowerTool
Import items, item journals, and sales history with Import Export PowerTool For partners and administrators who need to bring opening balances, serial numbers, and history into Business Central from another system. Transcript and details →

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.

Import Export PowerTool app icon

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.

Ask a product question

Product Questions