Category Archives: NAV2013

Search an entire NAV database with 10 lines of code

So a friend and I talked about how to search for data in NAV across all tables, and I said, I can do that in 10 lines of code 🙂

That’s a “Show Up or Shut Up” moment. So here goes:

Here presented in an older version of NAV, just to show that this works in most versions:

The idea is simple:
1. Loop through all tables
2. For each table, create a RecordRef
3. Loop through all records in the RecordRef
4. Do a text search with STRPOS inside the FORMAT(RecordRef) text string.

The secret here is that the FORMAT command, when used on a Record or a RecordRef returns a TAB separated string with all the fields from the record.

If you want case in-sensitive search, use LOWERCASE on the SearchValue and the output of the FORMAT command.

This is not fast, optimized or anything other that very complete and only 10 lines of code 🙂

Dynamics NAV2013 and NAV2013R2 are no longer supported

CU51 for 2013R2 and CU58 for NAV2013 will be the last updates. both versions are no longer under support.

“Cumulative Update 51 for Microsoft Dynamics NAV 2013 R2 will be the last release for Microsoft Dynamics NAV 2013 R2 as it by January 9, 2018 will be out of mainstream support period.”

Cumulative Update 51 for Microsoft Dynamics NAV 2013 R2 has been released

https://pbs.twimg.com/profile_images/676792894813024256/N7zqcEMg.png

If you’re using these versions, you should consider to upgrade to a new release, either by a real update, or just during a runtime upgrade.

 

Another Month – Another batch of Cumulative Updates

Silently during the parties at Directions EMEA a new batch of CUs saw daylight, get them here:

CU11 for NAV2017 https://www.microsoft.com/en-us/download/details.aspx?id=56038

CU24 for NAV2016 https://www.microsoft.com/en-us/download/details.aspx?id=56037

CU36 for NAV2015 https://www.microsoft.com/en-us/download/details.aspx?id=56036

CU48 for NAV2013R2 https://www.microsoft.com/en-us/download/details.aspx?id=56039

CU55 for NAV2013 https://www.microsoft.com/en-us/download/details.aspx?id=56035