the record that you tried to open is not available nav 2013 r2

Business Central/NAV Developers Forum
1

Hi

I have an issue. I am trying to open a page in RTC and came across this error - ‘the record that you tried to open is not available’ and the page will be closed automatically. I comment off the filtering on the OnOpenPage trigger and try to run again, but the error keeps on coming out. Please advise.

Thanks

2

Hi ha101,

Looks like there’s an update for that error in the BE version of the database, referenced here http://nav.dk/content/marts-2014-overview-released-application-hotfixes-microsoft-dynamics-nav-2013-r2, and mentioned here http://www.mibuso.com/forum/viewtopic.php?t=57590 without a clear solution.

Hope that’s helpful

3

Check the table record(s) and make sure no record exist with the value of the (primary) key null or blank. It sounds strange that the key field would allow a null or blank value.

4

which page do you want do open ?
for sure a code bug, a data bug can cause that behavior.
but, if you want to open e.g. a warehouse shipment and your user is not added to the warehouse employees for that location, you also get that error.