Skip to content

ArcherPoint Dynamics NAV Developer Digest – vol 32

The ArcherPoint technical staff—made up of developers, project managers, and consultants – is constantly communicating internally, with the goal of sharing helpful information with one another.

ArcherPoint’s technical staff pose questions, find answers, and share new discorveries about Microsoft Dynamics NAVAs they run into issues and questions, find the answers, and make new discoveries, they post them companywide on Yammer for everyone’s benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this group—so we thought, wouldn’t it be great to share them with the rest of the Microsoft Dynamics NAV Community? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from the ArcherPoint staff. We hope these insights will benefit you, too.

Faithie Robertson on printing Canadian Checks:

Just so no one ever has to go through this again.....I had a client today that had checks printing "CA Dollar" on the check amount description line. The Company Info setup looked fine, the Vendor setup looked fine, the MICR stuff on the bank account looked fine. While debugging it, I got lost in the language codes. There's actually a virtual table 2,000,000,045 "Windows Language" that starts with a setting of 4105 (Canada). Here's the kicker: If you leave your Bank Account Country/Region code blank, you get Canadian checks. This is true on check report 1401. Function SetCheckPrintParams does not switch the language code to 1033 when the code is blank. (Another tell-tale sign is the date format is date-month-year.)

Tri Luong also had a question about check printing in NAV:

Has anyone seen this before? Navision put extra '.00' at the end of the check amount.

Bad value on check amount

Faithie Robertson

Some of the check formats have two fields that are stacked in the RDLC for the Check Amount Text field. They are made visible based on some sort of code - cannot remember what. Could it be showing two different fields (maybe one is an expression calculating ".00"), or does it show in the dataset with the extra ".00"?

Jon Long

...or the currency code is set to .00. Some clients set it to CAD, for instance, to highlight foreign currency. Look on the Bank Card>Posting fast tab and see if the Currency Code is set to ".00"

Krista Swanson asked about the recommended number of shortcut dimensions in NAV 2015:

Does anyone know the maximum recommended number of shortcut dimensions for Nav 2015? A client is considering going up to 14 shortcut dimensions. We are concerned about transaction overhead as a result. Any thoughts?

Kyle Hardin

I would think that the combination of dimension sets, and making sure that Analysis Views don't automatically update when posting documents would minimize the performance impact. That having been said, some clients are unaware of other slice and dice concepts, like item categories, variants, locations, different posting groups, or even separate companies as options. I'd try to find out a bit more of the Why.

Follow-up to last week’s discussion on Database errors:

Faithie Robertson

I recently ran into this problem. The issue I found was that the client had two services set up on the database. I had to go to a different server (the one with the service I was using) and make the table change there for it to compile. I was also adding a field. I was also not able to sync on the other server, but had to do that on the server with the service. I hope this helps.

Suresh Kulla on a series of HOW DO I videos  for Microsoft Dynamics NAV 2015:

There are several HOW DO I Videos released today for NAV 2015 in the Microsoft Dynamics Community:

Microsoft Dynamics NAV Videos

  • How Do I: Use the Application Merge Utilities in Microsoft Dynamics NAV 2015
  • How Do I: Work with Schema Synchronization in Microsoft Dynamics NAV 2015
  • How Do I: Add Help to my Microsoft Dynamics NAV Tablet Client in Microsoft Dynamics NAV 2015
  • How Do I: Compile using the Development Shell in Microsoft Dynamics NAV 2015
  • How Do I: Create and Manage Electronic Payments in Microsoft Dynamics NAV 2015
  • How Do I: Create Application Pages for the Tablet Client in Microsoft Dynamics NAV 2015
  • How Do I: Get Started with Application Merge Utilities in Microsoft Dynamics NAV 2015
  • How Do I: Know About Developing for Microsoft Dynamics NAV for Tablets in 90 Seconds
  • How Do I: Merge Version Lists Using the Application Merge Utilities in Microsoft Dynamics NAV 2015
  • How Do I: Prepare and run Upgrade Toolkit Step 1 in Microsoft Dynamics NAV 2015
Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube