Category: On-Premises Dynamics

Blog Microsoft Dynamics Gp User Experience

Steps to Modify an Existing GP Word Template

These steps are specific to modifying an existing Word Template.  If a report is printed and Microsoft Word automatically opens up to display the report, then a Word Template is being used. IMPORTANT NOTE:  Even though the end result appears in Word, the Dynamics Report Writer (DRW) report is still being used to pass the…
LEARN MORE

How to Create a Dashboard Report in Dynamics NAV 2013 R2

Microsoft Dynamics NAV 2013 R2 has the added visualization benefits of a dashboard style reporting system so that you can see at a glance, important pieces of information about your business processes. It is necessary to understand all of the new features within Dynamics NAV 2013 R2 to be able to take advantage of all…
LEARN MORE
Datadriven Growth Scaled

How to Save User-Specific DEX.INI Settings to the SQL Database

With the release of GP 2013, I was faced with another client choosing to deploy Microsoft Dynamics GP in a Terminal Server environment to save on the overhead of maintaining client installations. With their first request to have their users point to different locations for their Word Template files, I went old school and created…
LEARN MORE

4 Steps to Creating a Great Dataset for NAV Reports

Mainstream Support ended for Dynamics NAV 2018 on January, 10 2023. This means the five-year countdown has begun for Dynamics NAV with all Navision extended Support ending on January 11, 2028. Velosio offers a range of services designed to extend the life and enhance the functionality of Dynamics NAV. Choosing to continue with Dynamics NAV…
LEARN MORE

Excel Cube Functions: Exclude a Single Member from a Set

I’ve talked previously about how one can use MDX to create sophisticated cube sets in Excel, but I was recently stumped by a questions from one of my clients. The question seemed simple enough (“How do I create a cube set that includes all of my customers except one that I identify?”) but the best…
LEARN MORE

Using Cube Functions in Excel to Create MTD

Cube Functions inside Excel are really powerful tools for cube reporting, especially when you realize that you can leverage MDX within the functions to make some very useful calculations. Today, I will describe how you can use the CUBESET function to calculate Month To Date values, even when there are no MTD defined measures. First, let’s…
LEARN MORE