Design details: reservation, order tracking, and action messaging

The comprehensive reservation system includes the interrelated and parallel features of Order Tracking and Action Messaging.

At the core of the reservation system, is the linking of a demand entry and a corresponding supply entry, either through reservation or order tracking. A reservation is a user-generated link, and an order tracking record is a system-generated link. An item quantity entered in the reservation system is either reserved or order tracked, but not both at the same time. How the systems handle an item depends on how the item is setup.

The reservation system interacts with the planning system by creating action messages on planning lines during planning runs. An action message can be considered an appendage to an order tracking record. Action messages, whether created dynamically in order tracking or during the planning run, provide a convenient tool for efficient supply planning.

Note

Reserved quantities are ignored by the planning system, that is, the hard link that is made between supply and demand cannot be changed through planning.

The reservations system also forms the structural foundation for the item tracking system. For more information, go to Design Details: Item Tracking.

Reservation

A reservation is a firm link that connects a specific demand and a specific supply to each other. This link directly affects the subsequent inventory transaction and ensures the proper application of item entries for costing purposes. A reservation overrides the default costing method of an item. For more information, go to Design Details: Item Tracking.

The Reservation page is accessible from all order lines of both demand and supply types. On this page, the user can specify which demand or supply entry to create a reservation link towards. The reservation consists of a pair of records that share the same entry number. One record has a negative sign and points to the demand. The other record has a positive sign and points to the supply. These records are stored in the Reservation Entry table with the status value Reservation. The user can view all reservations on the Reservation Entries page.

Offsetting in reservations

Reservations are made against available item quantities. Item availability is calculated in basic terms as follows:

available quantity = inventory + scheduled receipts - gross requirements

The following table shows the details of the order network entities that are part of the availability calculation.

Field in T27 Item Source table Table filter Source field
Inventory Inventory Item Ledger Entry N/A Quantity
Scheduled receipts FP Order Receipt (Qty.) Prod. Order Line =Firm Planned Remaining Qty. (Base)
Scheduled receipts Rel. Order Receipt (Qty.) Prod. Order Line =Released Remaining Qty. (Base)
Scheduled receipts Qty. on Assembly Order Assembly Header =Order Remaining Qty. (Base)
Scheduled receipts Qty. on Purch. Order Purchase Line =Order Outstanding Qty. (Base)
Scheduled receipts Trans. Ord. Receipt (Qty.) Transfer Line N/A Outstanding Quantity
Gross requirements Qty. On Sales Order Sales Line =Order Outstanding Qty. (Base)
Gross requirements Scheduled Need (Qty.) Prod. Order Component <>Simulated Remaining Qty. (Base)
Gross requirements Qty. on Asm. Component Assembly Line =Order Remaining Qty. (Base)
Gross requirements Trans. Ord. Shipment (Qty.) Transfer Line N/A Outstanding Quantity

For more information, go to Design Details: Availability in the Warehouse.

Manual reservation

When a user intentionally creates a reservation, the user gains full ownership of and responsibility for these items. This means that the user must also manually change or cancel a reservation. Such manual changes might cause automatic modification of the involved reservations.

The following table shows when and which modifications might occur:

User Action System Reaction
Decreasing the reserved quantity The related quantity fields are updated.
Changing date fields The related date fields are updated.

Note: If the due date on a demand is changed to precede the shipment date or due date of the supply, then the reservation is canceled.
Deleting the order The reservation is canceled.
Changing location, bin, variant, serial number, or lot number The reservation is canceled.

Note

The Late Binding functionality may also change reservations without informing the user, by reshuffling nonspecific reservations of serial or lot numbers. For more information, go to Design Details: Item Tracking and Reservations.

Automatic reservations

The item card can be set up to automatically reserve items based on demand, such as sales orders. In that case, reservation is made against inventory, purchase orders, assembly orders, and production orders. A warning is issued if the supply is insufficient.

In addition, various planning functions automatically reserve items to keep a demand linked to a specific supply. The order tracking entries for such planning links contain Reservation in the Reservation Status field in the Reservation Entry table. Automatic reservations are created in the following situations:

  • A multilevel production order where the Manufacturing Policy field of the involved parent and child items is set to Make-to-Order. The planning system creates reservations between the parent production order and the underlying production order to ensure they process together. This reservation binding overrides the item's default costing and application method.

  • A production, assembly, or purchase order where the Reordering Policy field of the involved item is set to Order. The planning system creates reservations between the demand and the planned supply to ensure that the specific supply is created. For more information, go to Order.

  • A production order created from a sales order with the Sales Order Planning function is linked to the sales order with an automatic reservation.

  • An assembly order created automatically for a sales order line to fulfill the quantity in the Qty. to Assemble to Order field. This automatic reservation links the sales demand and the assembly supply so that sales order processors can customize and promise the assembly item to the customer directly. In addition, the reservation links the assembly output to the sales order line through to the shipping activity that fulfills the customer order.

For supply or demand that isn't allocated, the planning system automatically assigns a reservation status Surplus. This could result from demand that is due to forecasted quantities or user-entered planning parameters. This is a legitimate surplus, which the system recognizes, and it doesn't give rise to action messages. The surplus could also be genuine, excess supply or demand that remains untracked. This is an indication of an imbalance in the order network, which causes the system to issue action messages. Note that an action message that suggests a change in quantity always refers to type Surplus. For more information, go to Example: Order Tracking in Sales, Production, and Transfers section in this article.

Automatic reservations created during the planned run are handled in the following ways:

  • They apply to item quantities included in the availability calculation, just like manual reservations. For more information, go to the "Offsetting in Reservations" section in this article.

  • They're included and potentially changed in subsequent planning runs, unlike manually reserved items.

Order tracking

Order Tracking helps the planner maintain a valid supply plan by providing an overview of the offsetting between demand and supply in the order network. The order tracking records serve as the foundation for creating dynamic action messages and planning line suggestions during planning runs.

Note

The order tracking system offsets available stock as orders are entered into the order network. This implies that the system does not prioritize orders that may be more urgent in terms of their due date. It is therefore up to the logic of the planning system or the wisdom of the planner to rearrange these priorities in a meaningful way.

Note

Order tracking policy and the Get Action Messages function are not integrated with Projects. That means that demand related to a project is not automatically tracked. Because it is not tracked, it could cause the use of an existing replenishment with project information to be tracked to another demand, for example, a sales order. Consequently, you may encounter a situation in which your information about available inventory is out of sync.

The order network

The order tracking system is based on the principle that the order network must always remain balanced, ensuring every demand that enters the system is offset by a corresponding supply and vice versa. The system provides this by identifying logical links between all demand and supply entries in the order network.

This principle implies that a change in demand results in a corresponding imbalance on the supply side of the order network. Conversely, a change in supply results in a corresponding imbalance on the demand side of the order network. In reality, the order network is in a state of constant flux as users enter, amend, and delete orders. Order Tracking processes orders dynamically, reacting to each change at the time that it enters the system and becomes a part of the order network. As soon as new order tracking records are created, the order network is in balance, but only until the next change occurs.

To increase the transparency of calculations in the planning system, the Untracked Planning Elements page displays untracked quantities, which represent the difference in quantity between known demand and suggested supply. Each line on the page refers to the cause of the excess quantity, such as Blanket Order, Safety Stock Level, Fixed Reorder Quantity, Minimum Order Qty., Rounding, or Dampener.

Offsetting in order tracking

In contrast to reservations, which can only be made against available item quantities, order tracking is possible against all order network entities that are part of the net requirements calculation of the planning system. The net requirements are calculated as follows:

net requirements = gross requirements + reorder point - scheduled receipts - planned receipts - projected available balance

Note

Demand that is related to forecasts or planning parameters is not order tracked.

Example: Order tracking in sales, production, and transfers

The following scenario shows which order tracking entries are created in the Reservation Entry table as results of various order network changes.

Assume the following data for two items that are set up for order tracking.

Item Parameter Detail
Item 1 Name Component
Availability 100 units in EAST location

- 30 units of LOTA
- 70 units of LOTB
Item 2 Name Produced Item
Production BOM 1 qty. per of Component
Demand Sale for 100 units at WEST location
Supply Released production order (generated with the Sales Order Planning function for the sale of 100 units)

On the Manufacturing Setup page, the Components at Location field is set to EAST.

The following order tracking entries exist in the Reservation Entry table based on the data in the table.

Reservation entries

Entry No. Positive Item No. Location Code Quantity Reservation Status Description Lot No. Source Type Source ID Binding
8 - COMPONENT EAST -70 Tracking Component - 5407 101004 -
8 Yes COMPONENT EAST 70 Tracking Component LOTB 32 - -
9 - COMPONENT EAST -30 Tracking Component - 5407 1001004 -
9 Yes COMPONENT EAST 30 Tracking Component LOTA 32 - -
10 - PRODUCED ITEM WEST -100 Reservation Produced Item - 37 1001 Order-to-Order
10 Yes PRODUCED ITEM WEST 100 Reservation Produced Item - 5406 101004 Order-to-Order

Entry numbers 8 and 9

For the component need for LOTA and LOTB respectively, order tracking links are created from the demand in table 5407, Prod. Order Component, to the supply in table 32, Item Ledger Entry. The Reservation Status field contains Tracking to indicate that these entries are dynamic order tracking links between supply and demand.

Note

The Lot No. field is empty on the demand lines because the lot numbers are not specified on the component lines of the released production order.

Entry number 10

From the sales demand in table 37, Sales Lines, an order tracking link is created to the supply in table 5406, Prod. Order Line. The Reservation Status field contains Reservation, and the Binding field contains Order-to-Order. This is because the released production order was generated specifically for the sales order and must remain linked, unlike order tracking links with a reservation status of Tracking, which is created and changed dynamically. For more information, go to the Automatic Reservations section in this article.

At this point in the scenario, the 100 units of LOTA and LOTB are transferred to WEST location by a transfer order.

Note

Only the transfer order shipment is posted at this point, not the receipt.

Now the following order tracking entries exist in the Reservation Entry table.

Reservation entries

Entry No. Positive Item No. Location Code Quantity Reservation Status Description Lot No. Source Type Source ID Binding
9 - COMPONENT EAST -30 Surplus Component - 5407 1001004 -
10 - PRODUCED ITEM WEST -100 Reservation Produced Item - 37 1001 Order-to-Order
10 Yes PRODUCED ITEM WEST 100 Reservation Produced Item - 5406 101004 Order-to-Order
12 Yes COMPONENT WEST 70 Surplus Component LOTB 5741 1011 -
14 Yes COMPONENT WEST 30 Surplus Component LOTA 5741 1011 -
15 Yes COMPONENT OUT.LOG. 70 Surplus Component LOTB 32 - -
16 Yes COMPONENT OUT.LOG. 30 Surplus Component LOTA 32 - -

Entry numbers 8 and 9

Order tracking entries for the two lots of the component reflecting demand in table 5407 are changed from a reservation status of Tracking to Surplus. The reason is that the supplies that were linked to before, in table 32, are used by the shipment of the transfer order.

Genuine surplus, as in this case, reflects excess supply or demand that remains untracked. It's an indication of an imbalance in the order network, which generates an action message by the planning system unless it's resolved dynamically.

Entry numbers 12 to 16

Because the two lots of the component are posted on the transfer order as shipped but not received, all related positive order tracking entries are of reservation type Surplus, indicating that they aren't allocated to any demands. For each lot number, one entry relates to table 5741, Transfer Line, and one entry relates to the item ledger entry at the in-transit location where the items now exist.

At this point in the scenario, the transfer order of the components from EAST to WEST location is posted as received.

Now the following order tracking entries exist in the Reservation Entry table.

Reservation entries

Entry No. Positive Item No. Location Code Quantity Reservation Status Description Lot No. Source Type Source ID Binding
8 - COMPONENT EAST -70 Surplus Component - 5407 101004 -
9 - COMPONENT EAST -30 Surplus Component - 5407 1001004 -
10 - PRODUCED ITEM WEST -100 Reservation Produced Item - 37 1001 Order-to-Order
10 Yes PRODUCED ITEM WEST 100 Reservation Produced Item - 5406 101004 Order-to-Order
17 Yes COMPONENT WEST 70 Surplus Component LOTB 32 - -
18 Yes COMPONENT WEST 30 Surplus Component LOTA 32 - -

The order tracking entries are now similar to the first point in the scenario before the transfer order was posted as shipped only, except entries for the component are now of reservation status Surplus. This is because the component need is still at EAST location, reflecting that the Location Code field on the production order component line contains EAST as setup in the Components at Location field. The supply that was allocated to this demand before was transferred to WEST location and can't be fully tracked unless the component need on the production order line is changed to WEST location.

At this point in the scenario, the Location Code on the production order component line is set to WEST. In addition, on the Item Tracking Lines page, the 30 units of LOTA and the 70 units of LOTB are assigned to the production order component line.

Now the following order tracking entries exist in the Reservation Entry table.

Reservation entries

Entry No. Positive Item No. Location Code Quantity Reservation Status Description Lot No. Source Type Source ID Binding
10 - PRODUCED ITEM WEST -100 Reservation Produced Item - 37 1001 Order-to-Order
10 Yes PRODUCED ITEM WEST 100 Reservation Produced Item - 5406 101004 Order-to-Order
21 - COMPONENT WEST -70 Tracking Component LOTB 5407 101004 -
21 Yes COMPONENT WEST 70 Tracking Component LOTB 32 - -
22 - COMPONENT WEST -30 Tracking Component LOTA 5407 1001004 -
22 Yes COMPONENT WEST 30 Tracking Component LOTA 32 - -

Entry numbers 21 and 22

Since the component need changed to WEST location, and the supply is available as item ledger entries at WEST location, all order tracking entries for the two lot numbers are now fully tracked, indicated by the reservation status of Tracking.

The Lot No. field is now filled in the order tracking entry for table 5407 because the lot numbers were assigned to the production order component lines.

Action messaging

When the order tracking system detects an imbalance in the order network, it automatically creates an action message to notify the user. Action messages are system-generated calls for user action that specify the details of the imbalance and suggestions on how to restore balance to the order network. They display as planning lines on the Planning Worksheets page when you choose Get Action Messages action. In addition, action messages on planning lines are generated during the planning run to reflect the planning system's suggestions to restore balance to the order network. In both cases, the suggestions are run on the order network, when you choose Carry Out Action Message action.

An action message addresses one BOM level at a time. If the user accepts the action message, this might give rise to additional action messages at the next BOM level.

The following table shows the action messages that exist.

Action message Description
Change Qty. Changes the quantity on an existing supply order to cover a changed or new demand.
Reschedule Reschedules the due date on an existing order.
Resched. & Chg. Qty. Reschedules the due date and changes the quantity on an existing order.
New Creates a new order if demand can't be fulfilled by either of the previous action messages.
Cancel Cancels an existing order.

The order tracking system always attempts to resolve an imbalance in the existing order network. If this isn't possible, it issues an action message to create a new order. Following is the prioritized list that the order tracking system uses when it determines how to restore balance. If an additional demand enters the order network, the system seeks to order track through the following checks:

  1. Check for any excess supply in the existing order tracking record for this demand.
  2. Check for planned and scheduled receipts in order of receipt date. The latest possible date is selected.
  3. Check for available stock.
  4. Check if a supply order exists in the current order tracking record. If so, the system issues an action message of type Change to increase the order.
  5. Check that no supply order exists in the current order tracking record. If so, the system issues an action message of type New to create a new order.

An open demand passes through the list and offsets the available supply at each point. Any remaining demand is always covered by check 4 or check 5.

If a decrease in demand quantity occurs, the order tracking system attempts to resolve the imbalance by performing the previous checks in reverse order. This means that existing action messages could be modified or even deleted, if necessary. The order tracking system always presents the net result of its calculations to the user.

Order tracking and planning

When the planning system runs, it deletes all existing order tracking records and action message entries and recreates them as planning line suggestions according to supply/demand pairs and priorities. When the planning run finishes, the order network is in balance.

Planning system versus order tracking and action messaging

The following comparison shows the differences between the methods that are used by the planning system to create planning line suggestions and the methods that are used by the order tracking system to create order tracking records and action messages.

  • The planning system deals with the entire supply and demand pattern of a particular item, whereas order tracking deals with the order that activated it.

  • The planning system deals with all levels of the BOM hierarchy, whereas order tracking deals with one BOM level at a time.

  • The planning system establishes links between demand and supply according to the prioritized due date. Order tracking establishes links between demand and supply according to the order entry sequence.

  • The planning system takes planning parameters into account, whereas order tracking doesn't.

  • The planning system creates links in a user-activated batch mode when it balances demand and supply, whereas order tracking creates the links automatically and dynamically as the user enters orders.

See also

Design Details: Central Concepts of the Planning System
Design Details: Supply Planning

Find free e-learning modules for Business Central here