Inventory Valuation - Rendering Error

Brimstar
Brimstar Member Posts: 14
edited 2014-03-03 in NAV Three Tier
Running the stock inventory valuation report is giving the following error: "Rendering output for the report failed and the following error has occurred : An error has occurred during report processing."

Error occurs trying to do anything (print, preview, export to PDF/Excel/Word).

It's obvious it's an issue with the amount of data because if we add filters it works fine. It's only trying to run for the full inventory. Our parent company requires us to run this as part of our month end procedures as part of their audit process.

Suggestions?

Comments

  • davmac1
    davmac1 Member Posts: 1,283
    1) in NAV - add code to the report to only pass the summary data to the layout.
    If you look at the layout itself, it does not have a detail line, just group data. Decide what level you need to group at and do the summary in the C/AL code.
    (This report violates the NAV recommendation of limiting the data in your dataset.)

    2) use one of the SQL alternatives for providing the same information - there are at least 2 of them out there. The older one was published by ara3n a few years ago and there have been at least one published in the NAV 2013 era.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Rob_Hansen
    Rob_Hansen Member Posts: 296
    We sell an optimized inventory valuation report for NAV that addresses these sorts of issues (bulk of data, terrible performance, result failing). Information is available at http://epimatic.com/products/fastinventoryvaluation. The product is available for the RTC only, but that is generally where the most significant problems are encountered.
    Rob Hansen
    http://www.epimatic.com

Categories