Design Details: Item Tracking Design

Item tracking in Business Central started with Dynamics NAV. The item tracking functionality is in a separate object structure with intricate links to posted documents and item ledger entries, and it is integrated with the reservation system, which handles reservation, order tracking, and action messaging. For more information, see Design Details: Reservation, Order Tracking, and Action Messaging in the Supply Planning design details.

This design incorporates item tracking entries in total availability calculations throughout the system, including planning, manufacturing, and warehousing. Serial and lot numbers are applied on the item ledger entries to ensure simple access to historical data for item tracking purposes. With 2021 release wave 1, item tracking in Business Central includes package numbers.

With the addition of serial, lot, and package numbers, the reservation system handles permanent item attributes while also handling intermittent links between supply and demand in the form of order tracking entries and reservation entries. Another different characteristic of serial or lot numbers compared to the conventional reservation data is the fact that they can be posted, either partially or fully. Therefore, the Reservation Entry table (T337) now works with a related table, the Tracking Specification table (T336), which manages and displays summing across active and posted item tracking quantities. For more information, see Design Details: Active versus Historic Item Tracking Entries.

The following diagram outlines the design of item tracking functionality in Business Central.

Example of item tracking flow.

The central posting object is redesigned to handle the unique subclassification of a document line in the form of serial or lot numbers, and special relation tables are added to create the one-to-many relations between posted documents and their split item ledger entries and value ledger entries.

Codeunit 22, Item Jnl. – Post Line, now splits the posting according to the item tracking numbers that are specified on the document line. Each unique item tracking number on the line creates its own item ledger entry for the item. This means that the link from the posted document line to the associated item ledger entries is now a one-to-many relation. This relation is handled by the following item tracking relation tables.

Field Description
Item Entry Relation (T6507) Relates shipped or received lines to item ledger entries
Value Entry Relation (T6508) Relates invoiced lines to value entries

For more information, see Design Details: Item Tracking Posting Structure.

See Also

Design Details: Item Tracking

Business Central on Microsoft Learn