What’s new in CU11 for WMS and TMS

Microsoft Dynamics AX 2012 R3 Cumulative Update 11 is now available for download on Lifecycle Services, CustomerSource and PartnerSource. This release includes several improvements for warehouse and transportation management. For detailed information on the release of Microsoft Dynamics AX 2012 R3 CU11, please refer to the Dynamics AX In-Market Engineering blog.

In this post we’ll take you through some of the enhancements in SCM and specifically for WMS and TMS. The following information is also available as part of the What’s new in Microsoft Dynamics AX 2012 document found here.

In short, within SCM and for WMS and TMS the following enhancements are made available:

  • Enable multi-threading on wave execution.
  • Inserting records into InventTransOriginTransfer from the write TransferRefId method has been improved.
  • Report actual consumption for production on a mobile device.
  • Ability to round up work for raw material picking in the unit that the material is picked in.
  • Ability to mark a production order as ended when you are reporting as finished on a mobile device.
  • Ability to report items that have an active serial number as finished by using a mobile device.
  • Receive a pallet that has mixed source document line, and register it by using one license plate (LP).
  • Locate put-away locations, based on LPs for mixed LP and LP receiving processes.
  • Associate LPs with a container type.
  • New functionality has removed the need for the message that states that the load line is not valid when you try to release a load that is a partial quantity.
  • All first expired, first out (FEFO)  batch reservation sales lines that are created have the same item.
  • You can now change the unit of measure during sales order picking
  • The Adjustment in and Adjustment out mobile device menu items now have the option to show or hide inventory status.
  • You don’t need to enter the return merchandise authorization (RMA) for every line that is being returned when you process a return through a mobile device.
  • The ability to allow negative physical and financial inventory for specific warehouses is now controlled by the LogisticsBasic configuration key.
  • Combine sales orders and transfer orders on the same outbound load.
  • Accrual posting of inbound freight charges at the time of product receipt
  • The printed master bill of lading (BOL) gives summarized information for all attached underlying BOLs.
  • You can go directly to the BOLs for a load from the Load planning workbench.
  • Until now, it has been mandatory to use different items for the parent and child product. Otherwise, the user receives a warning message from the BOM check that circular reference is not allowed. If this warning is ignored, MRP might fail. This warning was caused by the fact that the level check and the BOM level calculation were done per item.
  • Issues with multithreading, bill of materials (BOM) level calculation, and processing of items that have no demand cause high MRP run times.

The following shows an excerpt from the What’s new in Microsoft Dynamics AX 2012 document on a more detailed list of the enhancements for CU11 in SCM and for warehouse and transportation management.

Description of issue or change request  Description of enhancement
Enable multi-threading on wave execution. Multiple waves can now be processed in parallel for the same warehouse, which enables a single wave to process allocations in parallel to improve performance of wave allocation.
Inserting records into InventTransOriginTransfer from the write TransferRefId method has been improved. Inserting records into InventTransOriginTransfer from the write TransferRefId method is slow because the query plan that was implemented affect the performance of work creation during WHS wave release. The functionality has been improved to help guarantee that the select statement is split into two, so that SQL Server can use a better query plan.
Report actual consumption for production on a mobile device. There is a new mobile device menu item for registering material consumption.
Ability to round up work for raw material picking in the unit that the material is picked in. You can now round up work for raw material picking to the nearest unit that the material is picked in. The Lines section of the location directive has a new field that you can use to set the round-up
criteria. The field is enabled only if the line is restricted by a unit. For more information, see the Microsoft Dynamics AX Manufacturing blog.

For example, 510 pounds of a raw material are required in order to produce 4,475 pounds of finished goods. The raw material is stored in the warehouse in 50-pound bags. If the requested quantity of 510 pounds is picked for the order (order picking), the warehouse worker must pick ten 50-pound bags, plus an additional 10 pounds. In some scenarios, the warehouse worker will pick the ten bags and weigh the additional 10 pounds in the warehouse (for example, at a special location where bags are opened). In another typical approach, the material is not weighed at the warehouse location but on the shop floor, near the operation that consumes the material. In this scenario, the warehouse worker will over-pick to the nearest 50-pound bag. In other words, for this example, he or she will pick eleven 50-pound bags.

Ability to mark a production order as ended when you are reporting as finished on a mobile device.

You can now report as finished by using End job on the hand-held device. When you report a production order as finished by using the End job option, the production order status is updated to Reported as finished. This status indicates that no more finished goods will be reported, and no more time and material will be consumed by the order. Therefore, any inventory transactions that have remaining quantities for both materials and finished goods will be cleaned up. For more information, see the Microsoft Dynamics AX Manufacturing blog.

In previous versions, this capability was available when you reported as finished from the Microsoft Dynamics AX client, but not from mobile devices. However, mobile device users can now mark End job from their device. This capability is available for reporting as finished on production orders, and also on batch orders that have co-products and byproducts. When you configure the menu item for reporting as finished, you can specify whether the End job option should be available to mobile device users.

Ability to report items that have an active serial number as finished by using a mobile device. There is a new mobile device menu item for reporting as finished by serial number.
Receive a pallet that has mixed source document line, and register it by using one license plate (LP).

Two new work creation methods for the mobile device have been introduced, so that users can receive multiple times against a single LP. For more information, see the Microsoft Dynamics AX SCM blog.

You can now use a mobile device to identify and register items on a pallet before work is created and the pallet is moved from receiving to the next location. To support this functionality, two new work creation methods have been added: Mixed license plate receiving and Mixed license plate receiving and put-away. When a mobile device menu item is set up, and one of the new work creation methods is used, an additional new field becomes available: Source document line identification method.

The source document line identification methods determine the flow that is presented to the user on the mobile device until a source document line is uniquely identified. Each of the three supported methods corresponds to a flow that is presented to users who work with mobile devices for the work creation methods: Purchase order item receiving, Purchase order line receiving, and Load item receiving.

The difference is that users can continue to register on a single LP until all items on that LP are received.

To support the new functionality, a new form has been added: Mixed license plate receiving. This form contains information about the actual state of an LP, where receiving is done by using one of the work creation methods that are listed.

Locate put-away locations, based on LPs for mixed LP and LP receiving processes.

You can now define whether the search for free locations in the location directives must include all the content on an LP and group the put into one location.

When you receive inventory via an advance shipping notice ASN/packing structure that has a mix of item numbers, you cannot control the put-away policy that always makes sure that a complete
LP is stored, unless all locations allow for unlimited capacity. In the location directives for purchase orders, you can specify whether the search for free locations must include all the content on an LP and therefore group the put-away into one location for the mixed LP receiving and LP receiving processes.

Associate LPs with a container type.

New dimensions and logic for container types have been introduced, so that you can associate container types with LPs and create location stocking limits that are based on container types. For more information, see the Microsoft Dynamics AX SCM blog.

Support for pallet types and groups for inbound flow in WHS is now included.

New functionality has removed the need for the message that states that the load line is not valid when you try to release a load that is a partial quantity. You can now add less than the full quantity of an order to a load and release it to the warehouse, without receiving an error message. In previous versions, when you try to release a load that is a partial quantity, you receive the following error message: “The load line is not valid. It cannot be updated.”
All first expired, first out (FEFO)  batch reservation sales lines that are created have the same item. In previous versions, if a sales order consists of multiple sales lines for the same item, the automatic reservation during release to the warehouse batch does not consistently apply FEFO logic for batch reservations. The first sales line takes the FEFO batch correctly. However, the next sales line takes the next FEFO batch, even though first FEFO batch still has an available quantity. Every sales line is now put into a single transaction when a sales order that has multiple sales lines is automatically released to the warehouse. These changes will help guarantee that reservation that is based on FEFO logic have no differences between multiple sales lines.
You can now change the unit of measure during sales order picking

You can now change the unit of measure during sales order picking, even if quantity confirmation is set up. All units in an item’s unit of measure sequence group can be used. It is difficult for a mobile device user to convert between the work quantity and the quantity at a location if the units of measure differ.

For example, if there is a work order for one pallet, and there are three cases on the pallet in the work location, it might be impossible for the user to know whether three cases are the equivalent of one pallet. You can now display all units of measure in an item’s unit of measure sequence group when quantity confirmation is set up for the pick on a mobile device menu item.

The Adjustment in and Adjustment out mobile device menu items now have the option to show or hide inventory status.

A new parameter for displaying inventory status has been added to the Adjustment in and Adjustment out work creation methods.

When you process an inventory adjustment, quality departments might not want warehouse personnel to be able to adjust the inventory status. In this case, the Display inventory status check box must be added to the Adjustment In and Adjustment Out work creation menu items.

You can now use a new option on the Adjustment In and Adjustment Out warehouse menu items to restrict the user’s ability to change the inventory status.

You don’t need to enter the return merchandise authorization (RMA) for every line that is being returned when you process a return through a mobile device.

In previous version, when you process a return through a mobile device, you must unexpectedly enter the RMA for every line of registration.

The changes in the hotfix use the same code logic from purchase line receiving. When work is completed, the RMA number is inserted into the pass map. When the step is 0, the initialization status is also inserted into the pass map. These changes help guarantee that the display form keeps the RMA number, so that you don’t have to scan it again.

The ability to allow negative physical and financial inventory for specific warehouses is now controlled by the LogisticsBasic configuration key.

In previous versions, the ability to control whether a specific  warehouse allowed negative physical inventory is tied to the Retail  functionality, and the control was located on the Store tab.

Because of changes in the hotfix, the ability to control whether a  specific warehouse allows negative physical inventory is now tied to the LogisticsBasic configuration key. Therefore, this functionality is available for all warehouses, not just stores.

Combine sales orders and transfer orders on the same outbound load. From the Load planning workbench, you can now add transfer orders to an existing load that contains sales orders, or add sales orders to an existing load that contains transfer orders.
Accrual posting of inbound freight charges at the time of product receipt In the Miscellaneous charges form, you can now specify a charge category of Proportional for a module vendor. This functionality gives you the flexibility to set up different charge category for each miscellaneous charge in Transportation Management System (TMS).
The printed master bill of lading (BOL) gives summarized information for all attached underlying BOLs.

Currently, when you print the master BOL, the summarized information of all attached underlying BOLs is listed arbitrarily.

A new option in the TMS parameters form lets you automatically create a master BOL when there is more than one shipment on a load.

A new button that lets you create a master BOL for a selected load from the BOL form has also been added.

You can go directly to the BOLs for a load from the Load planning workbench. A load can contain multiple shipments, and if changes to the BOLs are required, it can be cumbersome to go to a menu in another module to find the correct BOLs for a given load. Additionally, the Load planning workbench lets you enter the actual gross weight for individual load lines, which can cause the BOL to be inaccurate. A button that has been added to the Load planning workbench, Load details form, and Load list page opens the BOL form and filters that form by the shipments that are on the load. Therefore, you can update the BOL more efficiently and accurately.
Until now, it has been mandatory to use different items for the parent and child product. Otherwise, the user receives a warning message from the BOM check that circular reference is not allowed. If this warning is ignored, MRP might fail. This warning was caused by the fact that the level check and the BOM level calculation were done per item.

With KB3089402, you can create one item, and use it as both parent and child in the BOM, as long as at least one product dimension differs.

Required setup

  • Inventory model: To ensure correct costing items with BOMs that include variants of the same item, you must use standard cost.
  • BOM check: The Circularity check strategy option must be set to Optimize for high complexity. The other option, Optimize for low complexity, has not been updated and will detect circularity for item variants that are produced from the same item.

Important implementation note

Make sure that the reqItemLevel table is empty before the first MRP run. Any change, such as creating or modifying an item, will generate entries to the table, and as a result, it will not be empty. The simplest way to do this is to truncate the reqItemLevel table and then run a full MRP (regenerative with no filters). Otherwise, MRP will not generate any planned orders.

Issues with multithreading, bill of materials (BOM) level calculation, and processing of items that have no demand cause high MRP run times. Multithreading during the MRP coverage phase and BOM level calculation have been optimized.
The ability to filter out items that have on-hand quantity but no demand has been added to Master planning parameters. This filtering reduces the number of planned items and is especially useful when spare parts are stocked.To enable this functionality, in the Master planning parameters form, use the Performance and Automatically filter by items with direct demand options for the pre-processing and post-processing steps of MRP.The Automatically filter by items with direct demand works as follows for the pre-processing and post-processing steps:

  • Pre-processing – MRP is a multi-step process. Before the actual planning step, which is called coverage, MRP completes a data update step. During this step, the MRP tables are populated with the data that will be operated on, in terms of both transactions (such as sales orders, purchase orders, forecasts, and safety stock) and planning parameters.
    The update step has several of substeps. One of these substeps preprocesses or preselects the items to update. Typically, not all the items that exist in inventory are sold or purchased at a specific time. Therefore, performance can be improved if the system can determine, at the start, whether there has been activity on each item. In this substep, the parameter filters items that have an on-hand quantity but do not have demand.
  • Post-processing – Before the coverage step can start, there is a pre-coverage step, where items for which BOM version requirement is set to true must be reprocessed to help guarantee that the items from the required BOM are planned. This step can lead to situations where items that were considered in preprocessing to have both on-hand quantity and demand now have just on-hand quantity, not demand, so that they can be excluded from planning.