Inventory Valuation - Rendering Error

Brimstar

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?

davmac1

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.

Rob_Hansen

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.