skip to Main Content
1-512-829-4000 sales@adv-usa.com
Data Conversion – 10 NAV 2015 Time & Money Saving Tips
Every new installation and some upgrades of Microsoft Dynamics NAV 2015 require a certain amount…

Data Conversion – 10 NAV 2015 Time & Money Saving Tips

Depositphotos_5787204_m-640839-editedEvery new installation and some upgrades of Microsoft Dynamics NAV 2015 require a certain amount of legacy data to be loaded into NAV. The effort that is required to accomplish this depends on the data quantity and quality. While the former is self-evident, the latter is often overlooked!

 

Read More
NAV Users: New Federal Online Sales Tax Legislation Introduced
NAV Users: New Federal Online Sales Tax Legislation Introduced
It’s time to “modernize our nation’s outdated sales tax collection framework.” That’s the goal of…

NAV Users: New Federal Online Sales Tax Legislation Introduced

It’s time to “modernize our nation’s outdated sales tax collection framework.” That’s the goal of H.R. 2775, the Remote Transactions Parity Act introduced yesterday by Rep. Jason Chaffetz (R-UT) and a bi-partisan group of his colleagues in the House. Rep.…

Read More
Shinning A Light On NAV: Updating The SSL Certificate For Web Services
Shinning a Light on NAV: Updating the SSL Certificate For Web Services
One of the challenges of dealing with Dynamics NAV web services and SSL Certificates is…

Shinning a Light on NAV: Updating the SSL Certificate For Web Services

One of the challenges of dealing with Dynamics NAV web services and SSL Certificates is that they expire and therefore you must update your installation  with a new SSL Certificate periodically. Below is a step by step guide for Dynamics NAV to install a new SSL Certificate and registering the new Certificate with the appropriate Service Tier Ports.

Read More
The Man From Mars!
The Man from Mars!
Sometimes, when I’m faced with a seemingly intractable problem, I approach it like I was…

The Man from Mars!

Alien - Depositphotos_56923487_300x225Sometimes, when I’m faced with a seemingly intractable problem, I approach it like I was a man from Mars who was seeing the problem for the first time and with no preconceived notions about how the solution should look.  Now before you jump all over me, I really don’t believe there is intelligent life on Mars. And with apologies to Erich von Daniken, I also do not believe that any alien civilization that may exist that had the intellectual capacity to navigate interstellar space would need the assistance of primitive man to scratch out lines in the desert to guide their spacecraft.  I’m pretty sure they could handle something as rudimentary and fundamental as getting their craft safely onto the ground of their choosing.

Read More
Prevent Unauthorized Access Through NAV Menu
Prevent Unauthorized Access Through NAV Menu
But if you have an existing implementation, and you have customized functionality, the permissions setup…

Prevent Unauthorized Access Through NAV Menu

But if you have an existing implementation, and you have customized functionality, the permissions setup is going to be quite a challenge, which is probably why you have been postponing it :) Until you have defined those roles and permissions, there…

Read More
NAVigating NAV: Financial Reporting Using Account Schedules
NAVigating NAV: Financial Reporting using Account Schedules
You use account schedules to analyze figures in G/L accounts or to compare G/L entries…

NAVigating NAV: Financial Reporting using Account Schedules

Depositphotos_10786458_xl-557367-editedYou use account schedules to analyze figures in G/L accounts or to compare G/L entries with G/L budget entries. For example, you can view the G/L entries as percentages of the budget entries. You use the Account Schedule window to set up the rows on your account schedules. By employing user-defined rows and columns, you can decide exactly which figures you wish to compare and how. This means that you can create as many customized financial statements as you want. To get started, click “New” in the Account Schedule Names List, assign it a name and give it a Description.  Next, click Edit Account Schedule.

Read More
Jet Reports – Using Variables For Data Source And Company
Jet Reports – Using variables for Data Source and Company
Everyone has one of those days when things just do not want go your way…

Jet Reports – Using variables for Data Source and Company

783-Building_Puzzle_2_3-637120-edited-328442-editedEveryone has one of those days when things just do not want go your way and you the feel technology has let you down. Admit it…  you want to punch your computer!

After you calm down, have your coffee, chai latte or coconut water to relax, you are now ready to jump back on your cubical chair saddle and whip that metal horse back into submission. You take the time and effort to try to work through the issue only to find out when you think you have set up everything right and that it is all good, that you are back to where you started from, if not worse off…..leaving you to feel like this!

At this point,  screaming fire through your Apple or Android bullhorn, you decide to call your support provider, hoping they can put the pieces of this mysterious puzzle together and get you back on track. Well you are not alone, recently, I had a client that was using Jet Reports, Jet Essentials with many Excel reports for multiple NAV companies. Even though the reports were separated on different servers for each company and scheduled to run at different times, based on the last report that ran, that data source and company was used on the next report that was scheduled to run. That resulted in a report with blank output due to the fact that the queries in the report were pointing at the wrong data source/company.  Although the reports had the data source and company set correctly on the Jet ribbon in Excel, the last scheduled report dictated the settings for the next report.

Read More
Extending Dynamics NAV…Thinking Outside The C/AL Box
Extending Dynamics NAV…Thinking Outside the C/AL Box
For all the power that Dynamics NAV provides with its native "in the box" tools…

Extending Dynamics NAV…Thinking Outside the C/AL Box

Depositphotos_36193189_original-275291-editedFor all the power that Dynamics NAV provides with its native “in the box” tools there are times when reaching outside of the C/AL box is not only warranted but can actually save time on development, testing and deployment. Additionally, being willing to expand your technical horizons and learn some new technological tools can be very rewarding and payoff dividends in the future.

 

Read More
Back To Top
Search