BC Friday Tips #44 Changing Production Order Status

When a Production Order status changes in Business Central, the system inserts a new record and deletes the old one rather than modifying it. Understanding this behavior helps avoid errors when subscribing to Insert, Modify, or Delete triggers on Production Orders.

Key points

Changing Production Order status creates a new record and removes the old one instead of updating the existing record
This behavior occurs in the TransProdOrder procedure in codeunit 5407
Subscriptions to Insert, Modify, or Delete triggers on Production Orders may encounter unexpected results without awareness of this mechanism
Extra trigger logic can cause errors if not accounting for this record replacement pattern

Quotes

“You can see this in the TransProdOrder procedure inside codeunit 5407 “Prod. Order Status Management”.” (Points developers to the exact location in the codebase where this behavior is implemented)

AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

codeunit 5407 “Prod. Order Status Management”

Context

Features: Production Order status changes, record insertion and deletion

Source: That NAV Guy, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.