Visual Studio Not Displaying NAV Report Layout Properly

We found this issue when using Visual Studio 2015 Community Edition with NAV 2016*, but it’s possible that you may encounter this with other editions and versions of Visual Studio as well.

Issue: When designing a Report object from the NAV Development Client and viewing the Layout in Visual Studio, Report.rdlc is rendered as an XML file instead of a “visual” layout with fields, controls and boxes.

clip_image001

Continue reading “Visual Studio Not Displaying NAV Report Layout Properly”

How to Duplicate a Report in NAV

I wouldn’t have thought of dedicating a post to this, but an old friend of mine asked me today if I could explain how to duplicate a report in NAV. He wanted to take an existing report, save it with a new object number and make modifications to the “new” report.

The process is quite simple:

  1. In the NAV Classic Client, go to the Object Designer.
  2. Click on Report, and find the desired report. Click Design (for example, Report 50025)
  3. Go to File > Save As, and in the window that appears, enter the object number for the new report (for example, 50035) in the ID field. In the Name field, enter a new name (Report names must be unique, so you cannot have two reports with identical names).
  4. Click OK, and it will take a few seconds to save this new report.
  5. Once it is saved, I do not recommend making changes right away. To be safe, close out this report by clicking the X icon (i.e., exit the Report Designer)
  6. From the Object Designer, find your new Report (for example, Report 50035), click Design, and now you can begin making your changes.

Additional note:

In step #3 above, I mentioned that each report’s name must be unique. However, there is no such requirement for the Caption associated with each report – so multiple reports can have the same Caption.

Is the State code missing on printed documents for Canadian customers?

The other day, one of our clients reached out to us because an invoice they mailed to a Canadian customer was returned due to missing State/Province code. They checked other invoices that were printed from NAV and noticed that the State codes appeared on invoices to US customers but not the Canadian ones.

Once I got over the initial surprise that the Canadian postal service couldn’t figure out the Province from the Postal/Zip code which was clearly printed out, I set about “addressing” the issue:

  • Did the Sell-To and Bill-To address contain the State code/name? Check
  • Did we affect something when we modified the Format Address Codeunit for the client? Hmmm, could be, but let’s check the simple stuff first.
  • What are the address formats for US and Canada in the Country/Region table? Aha!

Continue reading “Is the State code missing on printed documents for Canadian customers?”