Write Adjust Cost routine as a SQL Query?

nverma
nverma Member Posts: 396
edited 2023-03-29 in NAV/Navision Classic Client
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?

Answers

  • bbrown
    bbrown Member Posts: 3,268
    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.

    There are no bugs - only undocumented features.

Categories