Posted inDynamics NAV & BC Tips & tricks

Configuring the PowerShell Console

In the previous post we started using PowerShell. It’s interface looks much like the Windows Commandline with a blue background. Those looks are not the most ideal ones for everyone. So, today we will take a look how we can change the PowerShell interface. Luckily you…
Posted inDynamics NAV & BC Tips & tricks

Getting started with PowerShell

When you work in IT you probably have heard about PowerShell. I guess you have even seen people use it at work or during presentations. Because Dynamics NAV also offers more and more support for PowerShell, I decided to start writing about PowerShell. Bron : CompGEEK…
Posted inDynamics NAV & BC Tips & tricks

Caution! The merge cmdlets might merge incorrectly!

NAV2015 introduced new object merge functionality to ease upgrading of NAV databases dramatically. For information about the cmdlets you could start here: http://blogs.msdn.com/b/nav/archive/2014/10/03/merging-application-objects-using-windows-powershell-in-microsoft-dynamics-nav-2015.aspx I reported an issue to Microsoft back in the middle of December 2014, and after more than one month of e-mails back and…
Posted inDynamics NAV & BC Tips & tricks

Create any graph in NAV using Excel

Variables ExcelApp Automation 'Microsoft Excel 15.0 Object Library'.Application ExcelBook Automation 'Microsoft Excel 15.0 Object Library'.Workbook ExcelSheet Automation 'Microsoft Excel 15.0 Object Library'.Worksheet ExcelRange Automation 'Microsoft Excel 15.0 Object Library'.Range ExcelChart Automation 'Microsoft Excel 15.0 Object Library'.Chart GraphFile File MemStream InStream OStream OutStream Customer Record Customer CREATE(ExcelApp,…