Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Prerequisites to allow cancelling a packing slip for WHS items

We’re very happy to announce that in AX 2012 R3 CU12 you are now able to reverse loads, cancel packing slip updates for sales orders and product receipts for purchase orders. This means you are now able to reverse the loads even when these updates have been done. This change will come through KB 3196554… Read more

How to use inventory value report: part 4

In this part, we will discuss how to use inventory value report to do inventory reconciliation. Firstly, let’s imagine a company who has two item groups: Bike and Accessory. The inventory GL account for Bike is 140100. The inventory GL account for Accessory is 140200. Then we have a total GL inventory account 149999. In… Read more

Inventory value report doesn’t show some inventory dimensions.

Normally, we use inventory value report to view the inventory value and quantity. Sometimes, we cannot see some inventory dimensions in the report. To make the inventory dimensions showing in the report, you need to make sure: 1) Go to USMF/Inventory management/Setup/Inventory/Inventory value reports, select the inventory value report ID which you use to view… Read more

How to utilize the Last Match Status field for Vendor Invoices to automatically approve Vendor Invoices tied to Purchase Orders involving Charges

I have recently worked with customers whom leverage Workflow for Vendor Invoices so that when a Vendor invoice is received and entered into Dynamics AX, the Vendor Invoice needs to be routed through a Workflow process before it can be posted. This customer also utilized Three-way matching for Vendor Invoices against Product Receipts. However, some… Read more

How to use Serial Sales picking with Warehouse Management processing in Dynamics AX 2012

With the introduction of hotfix KB # 3072929 in Dynamics AX 2012 R3, you now have the ability to utilize picking of Sales serial items with Warehouse Management processing. This functionality allows you to enable serial numbers for use only in the Sales process without actually capturing the Serial number on the Inventory transactions themselves…. Read more

How to use Subcontracting in Lean Manufacturing in AX 2012

I have worked with several partners and customers inquiring on how to setup and configure the possibility of Subcontractor processing with Lean Manufacturing in Dynamics AX 2012. Based on these conversations, I’ve taken the time to document an example of a scenario of using Subcontractor processing with Lean Manufacturing in Dynamics AX 2012. In the… Read more

How to use DIXF to import an Inventory counting journal into AX 2012 from an Excel source file

I have recently worked with customers whom are using DIXF to import Inventory counting journals into AX 2012 as part of their monthly Inventory counts. As a result of this, I documented an example of how you can use DIXF to import an Inventory counting journal into AX 2012. NOTE:  In this example, the items… Read more

How to configure Bulk items into a Formula for a Packed Item and have MRP generate Planned orders for both

I’ve recently worked with customers whom are attempting to create Bulk item conversions into the Formula configuration for a Packed Item and have MRP have the capability to generate Planned Orders for both the Pack and the Bulk Item. As a result of this, I’ve documented the overall setup\configuration, as an example, in order to… Read more

Intermittent Inventory On Hand Performance Issues

A few customers have reported intermittent performance issues involving inventory on hand related queries on the InventSum, InventDim and/or WHSInventReserve tables, due to bad query plans regarding the table joins. This not only applies to on hand inquiries necessarily, but anything else dependent on it, e.g. inventory related posting processes, e.g. purchase invoicing. So based… Read more

Key Clean up Features for InventSum and InventDim Tables

Author: Arnold van Wageningen Please find below a summary of the clean-up features we currently offer in regards to InventSum and InventDim tables which can be found under the menu: Inventory management > Periodic > Clean up. The Inventory Dimensions cleanup shows the following help text: “The ‘Clean up unused inventory dimensions’ batch process deletes… Read more