Is there a possibility to automatic Update of Analisys View

easy-navi
easy-navi Member Posts: 31
edited 2009-06-08 in NAV/Navision Classic Client
Hello,
Is there any possibility to Update the Analisys View Card using an automated job (and run it at night)???

The problem is that our customers often needs to change the dimension values at the posted
documents. So we have made for them such a modification.
The problem is only with Analisys view entry table, beacause to the only way (i know) to refresh it is to delete the entries and than re-create it. Navision have such a job but it rather long-runnig job. So my question is to automate that process and run that job at night (for example). Is it possible somehow??
Nav=4.03
SQL= mssql 2005

Jack, Poland
http://www.reinwestuj.pl Inwestuj w nieruchomości. Condohotele, aparthotele.

Comments

  • jannestig
    jannestig Member Posts: 1,000
    Have you considered changing your modification so that upon change it triggers the automatic update such as when the original document is posted. Otherwise setup the codeunit to run overnight.

    Why does the customer need to update posted documents anyway? It may be better to find out the reasons they post with the wrong dimension in the first place or if they need a verification step before post
  • themave
    themave Member Posts: 1,058
    We run it in the job scheduler every nigh, have you tried it.

    it is easy to do.
  • ara3n
    ara3n Member Posts: 9,258
    I suggest to not update during posting. Main reason is performance and locking. As mentioned above, do it overnight.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • easy-navi
    easy-navi Member Posts: 31
    themave wrote:
    We run it in the job scheduler every nigh, have you tried it.

    it is easy to do.

    Themave -
    I mean you do it using the Navision Application Server??
    Or there is some easier way??
    http://www.reinwestuj.pl Inwestuj w nieruchomości. Condohotele, aparthotele.
  • themave
    themave Member Posts: 1,058
    easy-navi wrote:
    themave wrote:
    We run it in the job scheduler every nigh, have you tried it.

    it is easy to do.

    Themave -
    I mean you do it using the Navision Application Server??
    Or there is some easier way??
    in version 4.0 there is a job schedular that is part of the service module, it is not ran with the application server, that is what we use.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    themave wrote:
    easy-navi wrote:
    themave wrote:
    We run it in the job scheduler every nigh, have you tried it.

    it is easy to do.

    Themave -
    I mean you do it using the Navision Application Server??
    Or there is some easier way??
    in version 4.0 there is a job schedular that is part of the service module, it is not ran with the application server, that is what we use.

    And this can be quite easily ported to later versions.
    David Singleton

Categories