No longer able to access temporary tables outside the licenc

Miklos_Hollender

ed range.

I have found that the old trick of using not licenced tables as tempt tables no longer works in NAV 2013 (R2).

I found it the ugly way - I had Excel Buffer, then outside the licenced range Classic Excel Buffer and ClosedXML Excel buffer and then BOOM.

It seems you also need to move your own implementation of the GroupBy table into the licenced range.

(I don't know how you call it, but most developers sooner or later make a table that is only used as a temp table. It typical has fields like Code1,Code2,Code3,Code4,Code5,Text1,Text2,Dec1,Dec2,Dec3... and simply used for grouping stuff. So if you need a report of sales per tariff number you insert or modify one record per tariff number in it. This programmatic grouping is generally easier and more reliable & more flexible than others ways of doing it. If you are doing this for a couple of years, you have a table like that How do you call it? Mine is simply called GroupBy.)

Rob_Hansen

I hit this issue in NAV 2013 and submitted it to Microsoft. Initially they said this was by design (intended), but once I pushed the issue they realized it WASN'T by design. A hotfix was released to update it, and after that it worked fine (we have NAV 2013 solutions for a couple customers that uses this approach). If the error is coming up in NAV 2013 R2, either Microsoft messed up or you're on an older build. Have you made sure you're on the latest cumulative update?

Rob_Hansen

Did you get a fix for this Miklos? I see a fix was included in the latest cumulative update for NAV 2015 at least. I didn't check NAV 2013 / R2.