Dave's Blog

Book Review (well nearly): Implementing Microsoft Dynamics NAV 2013

Authors: Laura Nicolàs Lorente , Cristina Nicolàs Lorente Publisher: PACKT ISBN: 9781849686020 Published: February 2013 I’ve written a few book reviews for the myriad Dynamics NAV books out there, and usually I start by reading the book. In this case...

Published 04-07-2013 1:44 p.m. by David Roys

Filed under: Book Review, Book News, NAV 2013

Need to restart NAV Server to get new objects

Have you ever had a situation where you need to restart your NAV Server in a three-tier setup in order to get it to pick up new FOBs after importing? In this blog post, I’ll look at some of the reasons why this can occur and give you some techniques for...

Published 02-27-2012 10:36 p.m. by David Roys

Filed under: Gotcha, NAV 2009 SP1, NAV 2009, Tip, NAV 2009 R2

Ridiculously Cheap E-book

This blog post is not about Dynamics NAV, so if you are only interested in Dynamics NAV. Stop reading now. Still here? Phew! I wrote a novel. It took me ages (around two years). You can buy it if you want. I’d really like you to. It’s ridiculously cheap...

Published 02-19-2012 10:17 p.m. by David Roys

Filed under: Programming, Book News, Writing

PACKT Dynamics Books Mayhem

Packt have published more Dynamics books than you can shake a stick at.and in a fit of February craziness they’re offering up to 30% off Dynamics books, ebooks, and subscriptions. I feel like a used-car salesman. You can find out more at http:/...

Published 02-16-2012 10:09 p.m. by David Roys

Filed under: Book News

Config File Gotcha

I came across something that was a bit weird in an implementation where every user in a Citrix deployed RoleTailored client suddenly connected to the TEST system instead of the LIVE system. I thought I’d share this gotcha to save others from making the...

Published 02-03-2012 11:08 p.m. by David Roys

Filed under: Gotcha, NAV 2009 SP1, Tip, NAV 2009 R2

Service Tier and Classic Client Monstrous Nightmare with FieldRef

I came across an error today that was a monstrous nightmare to track down. First of all, it worked in the Classic client but not in the RoleTailored client. Sigh. Don’t you just hate that? It means going through the pain of debugging the RoleTailored...

Published 08-12-2011 9:49 p.m. by David Roys

Filed under: Programming, Gotcha, Tip, NAV 2009 R2

Creating New Windows Logins in NAV Through a SQL Sproc

If you’ve been following my on-going battle against the pigs, you’ll be pleased to know that I now have attained three stars on all of the levels in Angry Birds Seasons, Angry Birds, and Angry Birds Rio, so with no more pigs to kill until the next update...

Published 07-23-2011 9:02 p.m. by David Roys

Filed under: Programming, NAV 2009 SP1, NAV 2009, Tip, SQL, NAV 2009 R2

Make me squeal

If God had wanted me to work, he wouldn’t have given me Angry Birds. I figured it was about time I wrote something about Dynamics NAV again, so setting my continuing mission to get three stars on all levels to one side, I’ve finally taken time...

Published 06-20-2011 10:07 p.m. by David Roys

Filed under: .NET, Programming, Gotcha, Tip, SQL, NAV 2009 R2

20-30% Discount on Dynamics Books During May 2011

Those people at PACKT have been busy making more and more books on Dynamics covering GP 2010, NAV 2009, AX 2009, and Sure Step, so whichever flavour of Dynamics you prefer, there’s something for you to get your teeth into. To celebrate the recent publication...

Published 05-17-2011 7:25 p.m. by David Roys

Filed under: Book News

Execute SQL Command using .NET Interop

OK, I’ll admit it, I’m obsessed with the .NET Interop features in NAV 2009 R2. My last two blog posts have been on this and now here’s another one. Today I wanted to see if I could use the .NET Interop features in NAV 2009 R2 to execute...

Published 04-13-2011 10:12 p.m. by David Roys

Filed under: .NET, Programming, SQL, NAV 2009 R2

.NET Interop—I’m Lovin’ It!

If this was a blog about grammar, I might be asking whether a verb like “to love” can be conjugated in a progressive tense to give us the phrase “I’m Lovin’ It”. But it’s not, it’s a blog about Dynamics NAV and I’m writing about .NET Interop in Dynamics...

Published 02-16-2011 9:33 p.m. by David Roys

Filed under: .NET, Programming, NAV 2009 R2

Regular Expressions in NAV

A friend of mine recently asked if there was a standard NAV function to find the first alphabetical character in a string. STRPOS comes close but you can't say "tell me the first position for any one of these characters in this string" because...

Published 02-02-2011 8:32 p.m. by David Roys

Filed under: .NET, Programming, NAV 2009 R2

Book Review: Microsoft Dynamics NAV Administration

Authors: Sharan Oberoi, Amit Sachdev Publisher: PACKT ISBN: 978-1-84719-876-1 Published: September 2010 Once upon a time you couldn’t get books on Dynamics NAV for love nor money, then in October 2007 PACKT published David Studebaker’s book Programming...

Published 12-31-2010 4:18 p.m. by David Roys

Filed under: Book Review

Is there anybody out there?

Way way back in July I ran a competition to give away 2 Microsoft Visual Studio 2010 Ultimate with MSDN subscription cards. I said I would announce the winners in September, but didn’t. You see the thing is, the response was pathetic. Only one entry who...

Published 11-28-2010 11:07 a.m. by David Roys

Book Review: Microsoft Dynamics NAV 2009 Programming Cookbook

Author : Matt Traxinger Publisher : PACKT ISBN : 978-1-84968-094-3 Published : October 2010 Long ago when I was co-writing Implementing Microsoft Dynamics NAV 2009 one of my colleagues said to me, “You don’t want to write a book like that, you want to...

Published 11-28-2010 10:34 a.m. by David Roys