Cost Adjustement Batch , Performance in 4.1

ouredp · 2007-10-17

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.

kine · 2007-10-18

The cahnge of the speed is obvious. The function in NAV 5.0 begins with:

      IF (ItemJnlLine.Quantity = 0) OR
         (ItemJnlLine."Item Charge No." <> '') OR
         (ItemJnlLine."Value Entry Type" IN
           [ItemJnlLine."Value Entry Type"::Revaluation,ItemJnlLine."Value Entry Type"::Rounding]) OR
         ItemJnlLine.Adjustment
      THEN
        EXIT;

It means that the rest of the function is skipped if called from Adjustment... :-)

Cost Adjustement Batch , Performance in 4.1

Comments

Categories