Hi All,
I am running the item Cost adjustment on Nav 4 sp1 i have modified the codeunit 5895 such that my the process runs based on item category.. so when i run the process for the category with the least entries in ILE still its taking 1.5 days and nt complete the process... There are in all 12 entries in the ILE for that category.. Plz suggests me some way out...
Regards,
Aman
Aman Kumar Gupta
0
Comments
Are you sure there are no bugs in your modification? Have you tried running the process without any modifications and see how long it ran?
FYI, the adjust cost process has been improved in version 5.0 so you can run adjust cost per period. That should cut up your batches into a more managable size.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
I have just made a small change in the function
MakeSingleLevelAdjmt() stated below
***********************************************************
MakeSingleLevelAdjmt()
LevelNo[1] := LevelNo[1] + 1;
Window.UPDATE(1,LevelNo[1]);
WITH ItemLedgEntry DO BEGIN
SETCURRENTKEY("Item No.");
// Modify
SETRANGE("Item Category Code",'Alloy');
// Modify
IF FIND('-') THEN
REPEAT
GetItem("Item No.");
Window.UPDATE(2,Item."No.");
SETRANGE("Item No.",Item."No.");
REPEAT
LevelExceeded := FALSE;
AdjustItemAppliedCost;
UNTIL NOT LevelExceeded;
AdjustItemAvgCost;
PostAdjmtBuf;
UpdateItemUnitCost;
FIND('+');
SETRANGE("Item No.");
UNTIL (NEXT = 0) OR LevelExceeded;
END;
*************************************************************
Secondly i cannot upgrade the existing system to nav 5 so is there any other way out..
This gives same problem
With this few entries it should be a simple matter to use the debugger to see what is happening.
You may want to create a key with Item Category, Item No. then try your process again.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book