NAV 2013 Inventory Reports Broken

Jeff_G

Inventory Valuation R10139 and Inventory to G/L Reconcile R10138 both error out with:
System.OutOfMemoryException

I have filed an incident with MS (Back in MARCH) and been bugging them to no avail. ](*,)
This is happening in both of our 2013 upgrades.
Any suggestions?

tdburger

Were you ever able to resolve this issue? I am getting the same message after an upgrade.

Alex_Chow

Apply the latest NAV2013 hotfix released as of July 19th, 2013.

tdburger

Thank you very much

Johannes_Nielsen

Mark the thread as solved - bottom right corner.

tdburger

that didn't actually work. I ended up having to redesign the reports based on these guidelines http://blogs.msdn.com/b/nav/archive/201 ... n-rtc.aspx

tpbrophy

I applied rollup 5 to NAV 2013 and am still experiencing the same outofmemory.exception error. I ran report 10138, Inventory to G/L Reconciliation, in two segments. The first segment was 15 pages and the second segment was 4 pages without any errors. When I combined them the error occurred (19 pages). Ran report 10019, G/L Register, which produced over 300 pages, and no error occurred. The error seems to occur when the report is being rendered.
How much memory do you have on your server running the NST?

davmac1

I redid the report for a customer with that problem.
Since they do not use variants, I changed it to only pass the summary item lines to the report and changed the grouping lines to support it.
It now runs in a reasonable amount of time as well.
The best solution is to use ara3n's SQL solution, but if that is not possible in your environment, then use NAV's new report guide and only send the necessary rows to the report. (Necessary = rows that will actually print.)