Adjust Cost Item Entries Takes Too Long

Hi there,

We have a manufacturing and fabrication customer that heavily uses the Manufacturing functional area of NAV 2009 Classic. One of their biggest challenges right now is that as their Item Ledger (and consequently their Value Ledger) grows, their Adjust Cost Item Entries (ACIE) routine takes a long time to process completely. In recent months not even a full 24 hour run cycle is getting it done. Couple that with the fact they run their plant 24/7, and the frustration of not getting this report to run successfully starts to mount.

In another topic someone mentioned that it might be worthwhile to add a COMMIT to the adjust cost routine after each item is processed in order to atomize the transaction, so that if the routine must be killed not all the work is lost (and consequently avoid the dreadful transaction log rollback). I'm not too sure where the COMMIT should be added, but I did insert it into the Inventory Adjustment codeunit in the following function:

MakeSingleLevelAdjmt(VAR TheItem : Record Item)
LevelNo[1] := LevelNo[1] + 1;

UpDateWindow(LevelNo[1],WindowItem,WindowAdjust,WindowFWLevel,WindowEntry,0);

TheItem.SETCURRENTKEY("Low-Level Code");
IF TheItem.FINDLAST THEN
  TheItem.SETRANGE("Low-Level Code",TheItem."Low-Level Code");

WITH Item DO
  IF TheItem.FINDSET THEN BEGIN
    REPEAT
      Item := TheItem;
      GetItem("No.");
      UpDateWindow(WindowAdjmtLevel,"No.",WindowAdjust,WindowFWLevel,WindowEntry,0);

      REPEAT
        LevelExceeded := FALSE;
        AdjustItemAppliedCost;
      UNTIL NOT LevelExceeded;

      AdjustItemAvgCost;
      PostAdjmtBuf;
      UpdateItemUnitCost;

// After adjustments are made on that particular item, commit to the database
      COMMIT;
    UNTIL (TheItem.NEXT = 0) OR LevelExceeded;
  END;

I need to get this done for the client, but first I'd like to ask the community if this is the proper place to put it in, and if there are any concerns I should be aware of due to this commit.

Your feedback is appreciated.