The performance of Intercompany On-Hand form with WHS doesn't meet market expectations for performance


Symptoms


The performance of Intercompany On-Hand form with WHS doesn't meet market expectations for performance

Resolution


When we call the API from the intercompany on-hand form the skip doing the whs related on-hand calculations and postpone the cost until the user actually displays the values.

I tested with an item with batch below and 100 different batch numbers on hand.

If we open the on-hand form viewing on-hand per warehouse (which is the reported scenario) we drop from 106 SQL calls to WHSInventReserve to 3.

More information


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.