Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

How can I speed up pick list generation?

Posted on by 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

  • Battery Boy Profile Picture
    Battery Boy 445 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans