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
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156