Ask any NAV developer and they can tell you exactly what an RDLC brain cramp feels like. It is a pain behind the eyes that causes you to want to stare into space for hours, and bite the heads off innocent gummy bears. This intense pain is preceded by hours wasted searching one forum after… Continue reading Microsoft Dynamics NAV 2013 RDLC Reporting RBC Attacks: Part 1 of 10
Category: Platform & Process
Avoiding Hard Coding and Creating Setup Reports for Projects
Part 1: I try not to hard-code things The other day, I was writing an import for a customer where they needed to take a file from their payroll processor, pull it into their system, and consolidate data from different fields in the file by department into a multitude of G/L accounts in a General… Continue reading Avoiding Hard Coding and Creating Setup Reports for Projects
Get the CarFax Report for Microsoft Dynamics NAV ISV Software
I recently had to purchase a new car for my son. He’s 23 and had driven the same 1994 Nissan Altima I’d given him as a first car at 16. He drove it throughout high school and now into his senior year of college. But finally “Alti” took her last gulp of gas, let out… Continue reading Get the CarFax Report for Microsoft Dynamics NAV ISV Software
Spicing Up Your NAV 2013 Pages
Editor’s note: The following blog was originally posted on January 3, 2014. Two of the graphics were incorrect. The blog is being reposted with the correct graphics. We apologize for any inconvenience. If you have any questions, please contact ArcherPoint at emartin@archerpoint.com. I recently had to make a lot of chili. I mean, I made… Continue reading Spicing Up Your NAV 2013 Pages
The User Story Has Not Been Accepted and I am Thinking Crazy Thoughts
I constantly ask teams why user stories were not accepted during their previous sprints. Often, the teams are not sure, sometimes it is because the product owner was unaware that the story was available for review, and at times it is because the team just did not get around to finishing the work. I next… Continue reading The User Story Has Not Been Accepted and I am Thinking Crazy Thoughts
Beware the Third Parameter of MODIFYALL
The C/AL keyword MODIFYALL is tempting to use when a certain value must be changed for every record matching the current filtered recordset. One may or may not be aware of the third optional parameter for this keyword: TRUE/FALSE. FALSE is the default. If set to TRUE, the OnModify() trigger is executed when the record… Continue reading Beware the Third Parameter of MODIFYALL
TableData 2000000001 does not exist.
This NAV 2013 error may result if the user is attempting to connect to a NAV database using the Developer Client and the SQL permission dbowner has not been granted for the user at the database level. This resource reports the SQL permission dbowner is required in order for a user to manage NAV… Continue reading TableData 2000000001 does not exist.
Virtually There
A lot of companies, ArcherPoint included, are allowing employees to work remotely. Webinars and other virtual events are more common than ever (nearly all ArcherPoint’s events are remote, and with employees throughout the country, remote communication is part of our culture). Today, both public and private high schools and colleges are offering online classes –… Continue reading Virtually There
NAV Web Services – Pages vs. XMLports
There are two major methods for publishing complex NAV functionality as a web service: publishing a Page object, and publishing a Codeunit object with a function that uses an XMLport as a parameter. Which one should you use? Like Obi-Wan Kenobi and Captain America here, Pages and XMLports are both awesome, but they should be… Continue reading NAV Web Services – Pages vs. XMLports