Excel Item Tracking Line Toolkit
In this article
See also
📊 Excel Item Tracking Line Toolkit Introduction
The Excel Tracking Line Toolkit in 365 Cannabis provides a powerful way to manage tracking data in bulk. Instead of updating records one at a time in Business Central, this toolkit lets you export tracking lines to Excel, make changes or additions, and then re-import the data back into the system.
This tool is highly configurable and can be tailored to support different business processes, such as:
🌱 Cultivation – importing harvest weights, updating plant batches, or applying room/location changes.
🔑 Key Features
Export & Import: Move large datasets between Business Central and Excel for faster updates.
Configurable Setup: Choose which fields to include for reporting, filtering, or import.
Tracking Integrity: The Tracking ID is always the key field and must remain in the first column.
Error Handling: Import alerts highlight issues without overwriting unrelated data.
Scalability: Efficiently process thousands of records in a single import.
👉 Use this toolkit whenever you need to streamline repetitive tracking updates and reduce manual entry in Business Central.