mibuso.com
Home› NAV/Navision Classic Client

Cost Adjustment Report takes too long.

nvermanverma Member Posts: 396
edited 2014-05-13 in NAV/Navision Classic Client
Hello,

We have a client that is having issues running their adjust cost item entries routine. The report takes way too long to run. I ran the report on Friday (may 2nd), and until today (monday - may 5th) it was still running.

Any idea why it might take so long to run and what can be done to speed it up. Or if someone else had the same problem; how did you resolve it.

Answers

  • kinekine Member Posts: 12,562
    At first, you must be sure that there is no never ending loop. Check the numbers. If they are still repeating, there is loop in the entries (in most cases indirect) which will never ends. E.g. in some older versions of NAV 5 there were possible to consume output of prod. order A in PO B, and output of PO B consume in PO A. This create infinite loop in the adjustment. In later hotfixes this was solved by inserting check in posting routine which is preventing that.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • lvanvugtlvanvugt Member Posts: 774
    I recon you refer to the Adjust Cost - Item Entries Batch Job.
    If so, the qeustion is when this report was run the past time. It can take very long if you have a lot of items that have a lot of ledger and value entries and for which this report has not been run (for a long time).
    Currently I am working at an end-user where we have over 200.000 items for which actually this report has never been run. We have done some test and concluded that running this report would take more than a week.
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • DenSterDenSter Member Posts: 8,307
    Add a loop to run the routine for each item individually, do a COMMIT after each item, it will speed up.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • SilverXSilverX Member Posts: 134
    Please, please, please, before adding a COMMIT, make sure, make really really sure, you know, at which Position in Adjust Cost CU you are adding the COMMIT and think about the logic. Remember there are different Levels for the same Item!
    Cheers
    Carsten


    ==> How To Ask Questions The Smart Way
    This post is my own opinion and does not necessarily reflect the opinion or view of my employer.
  • DenSterDenSter Member Posts: 8,307
    Yes, that's why I said AFTER each item.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • nvermanverma Member Posts: 396
    After looking a bit more into the issue, it seems that the report is getting stuck in an endless loop.

    Then I found this article from Microsoft --http://support.microsoft.com/kb/979232
    I applied 4 patches that deal with the issue and tried executing the report again and the outcome is still the same.

    In the Adjusting Value Entries.. dialog box, the Item No. is blank, Entry No. is stuck at 511 and Adjmt. Level is closed at 6 million. I am not really sure if this will help diagnose the problem.

    Anyone ever faced a similar issue???
  • nvermanverma Member Posts: 396
    The Ajust Cost - Item Entries run into endless loop and the Adjmt. Level field keep increasing. This problem can occurs to Navision 4.0 and 5.0.The easiest thing you can check is to Open your Item Card. Press F5 to open the Item List form. Scroll to the first record to check whether you have an item witn blank No. or not. If you found a record with blank No. field, you can safely delete this record.

    I ran the report after deleting the empty Item No. record and it worked. :D \:D/

    I hope this simple fix will help other people.
Sign In or Register to comment.