Slow performance in the "Arrival overview" dialog box when you set the setup name to "Return order" in Microsoft Dynamics AX 2009.

November 8, 2010 <1 min read

There was a hotfix released for a performance issue with the Arrival Overview form. However some people may still experience performance issues when going to Inventory Management > Periodic > Arrival Overview and changing the setup name to return order. This has been seen when you have a lot of backorders. To resolve this you can add the following line to the buildOverviewQueryReturnOrder method of the WmsArrivalOverviewGeneration class.

dsSalesLine.addRange(fieldnum(SalesLine, SalesStatus)).value(SysQuery::value(SalesStatus::Backorder));

Depending on your data you may need to add additional filters or indexes to assist in optimal performance on this form.

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!

Slow performance in the “Arrival overview” dialog box when you set the setup name to “Return order” in Microsoft Dynamics AX 2009.

Tags