Dynamics Community Forum Thread Details

Catch Weight Serialized Item Performance

AX Version: Dynamics AX 2012 R2 CU1

We are having a performance issue on mass registering and picking an item which is defined as catch weight and serialized.

The scenario is that an item, say gasoline drum, is defined as catch weight as below:

Nominal: 50
Minimum: 49
Maximum: 51

As we need to track each individual drum so we have also enabled batch + serial tracking, the serial control is enabled.

So we purchase drums in bulk and then sell. At the time of purchase when we input quantity more than 20 pcs and try to register it takes too much time, we have taken readings on different servers and machines for the below quantities:

5 readings of 100 pcs, average time taken 26.17 sec
5 readings of 250 pcs, average time taken 1 min 3.54 sec
5 readings of 500 pcs, average time taken 2 min 57.79 sec
5 readings of 1000 pcs, average time taken 8 min 46.9 sec

You’ll notice that upon doubling the quantity time just doesn’t get double but it gets increased up to 3 to 4 times.

The same issue we observe when we try to pick items on Packing Slip of Sales Order, Movement Journal, Inventory Adjustment Journal and Transfer Order Picking & Registering.

Please note that we also tried to do the same thing on AX 2012 R2 CU6 and AX 2012 R3 and observed the same behavior.

Kindly help us to improve performance.

Quick Links

Leaderboard