Write Adjust Cost routine as a SQL Query?

nverma

Is it possible to write adjust cost routine as a SQL query?

Adjust cost routine takes about 2 to 2.5 hours to run. We run it nightly at 1 AM. It causes tons of locks/blocks. The client that I work for, runs 24X7.

I was wondering, if is it possible to convert the adjust cost report to a SQL query. Has anyone been able to do that?

bbrown

Adjust Cost is much more than just a single SQL statement. While it would be technically possible to recreate it as a process external to NAV, it would be much more involved than just writing a SQL query. You would need to understand and replicate the complete functionality of the process. In the long run, it may create just as many locks and take just as long. Since it still needs to do all the same work.

I would rather suggest focusing effort on improving performance of the current process.