Hello, this topic is just to share my experience. May be it can be helpfull for someone else. O:)
Navision Version 4.1
SQL Server 2000
We have experienced a great performance issue of our Cost Adjustement Routine (Report 795). Suddenly it move from 2 hours normal runtime to over 50 Hours during a week-end !
The reason was that for any productionorder value entry the routine goes thru the Item Journal Line table. This one was full of hundreds of Inventory transactions ready to be posted.
Our Solution Partner gave us the new code for the function "Checkwarehouse" in Codeunit 21 , Version 5.0. That didn´t only solve the actual problem but the cost adjustment is much faster now.
0
Comments
It means that the rest of the function is skipped if called from Adjustment... :-)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.