How can I speed up pick list generation?

(0) Share

Report

Posted on by Battery Boy

445

We are finding pick list generation in Dynamics AX 4.0 very s-l-o-w.

I'm presuming this is because of the amount of orders with back order lines currently on our system (several hundred). Looking at the code it seems to get a list of all orders in open status, then get the lines. We currently filter on warehouse, delivery date, and filter out invoiced and delivered lines.

Has anybody else experienced any problems with this? Are there any amendments to indexes or code that might help?

*This post is locked for comments

All responses (2)

Answers (1)

Battery Boy 445 on at

Like (0)

Report

Re: How can I speed up pick list generation?

Thanks, I have turned off the credit check and now we are more on top of the open orders it does seem to be quicker
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: How can I speed up pick list generation?

Usually the slowest part of the pick list generation is the credit limit check. So the fastest way to speed things up is to adjust the posting parameters – this can be done in Accounts receivable / Setup / Parameters / Credit rating. In your case I presume that credit limit type check is set to Balance+All, so you might want to try with Balance+Packing slip (Balance+Delivery note), or set to None to turn it off completely.

Take care that credit limit checks can be tricky, depending on company policy and associated risks (e.g. you don’t want to end up with shipping the goods to customer that should be blocked). If you want to speed the things up while still doing the full credit checks, you might need to modify default methods in CustTable and SalesTable, or do some database and index optimization.