Item Filter in Adjust Cost

slmaluwa

Hi all
Is there a way to filter the Items to run the adjust cost item entries? We have found a situation where one company didnt run it for a long time and now its going to take days to complete. This would disrupt normal activities by way of locking tables.

I am trying to find a way to run it for a group of items each day during the night until all completed.

Thank you

ara3n

viewtopic.php?f=23&t=18943&hilit=filter+item+adjust+cost

slmaluwa

Thank you Rashed
I found this and done the modification.

http://www.mibuso.com/forum/viewtopic.php?t=18943

[EDIT]The same one you suggest. Great! [/EDIT]

slmaluwa

Hi
What should be the right place in Inventory Adjustment codeunit, if we are to add a COMMIT to save the completed Item when an error or a Cancel occurred?

TIA

ara3n

create a new processing report to call the std nav report. The new report will loop through the item table and call the std nav report filtered on one item.

Then in this new report add a commit after each item.

slmaluwa

Thank you Ar3n
It is working.
By the way, is it Ok to filter Item for "Cost is Adjusted = No" in processing only report to minimize the number of items?

ara3n

Yes.