Excel Item Tracking Line Toolkit

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.