Item Journals
Business Value
Allows you to import Item Journals with item tracking information (lot and serial number information), which is very handy on your initial inventory take-on.
Feature Details
The Import from Excel action can be found in the following journals:
| Journal | Details |
|---|---|
| Item Journal | Use Excel Importer to import opening entries for new companies in Business Central or perform bulk item adjustments. |
| Reclassification Journal | Use Excel Importer to import bulk reclassification journals. Many customers use this feature to change expiry dates or to change inventory to different variants if there are quality issues. |
| Revaluation Journal | You can use Excel Importer to revalue specific Item Ledger Entries. |
| Output Journals | Used to import output when this is not recorded directly in Business Central. |
| Consumption Journals | Used to import consumption when this is not recorded directly in Business Central. |
info
Output and Consumption journals are only available with the Premium experience in Business Central.
Item Tracking (Lot and Serial Number)
This import supports importing lot and serial tracking details for items that require item tracking.
Document Numbers
You can import your own document numbers or you can specify a number series for the batch and let Business Central assign the numbers for you.