October 2017 – Pardaan.com

Ways to Import Export Data from Microsoft Dynamics NAV to Excel

In a scenario where a company uses Excel to keep the data and wants to move its ERP to Dynamics NAV. A lot of data needs to be added in NAV in order to get a full system working. Thus, copying each entry could be a…

31 October 2017

Dynamics NAV & BC Tips & tricks

3 Easy Methods to move company data between NAV databases

If there is something that changes in NAV every few releases, is how we backup and restore data (be that full backup, application data, companies data) between NAV databases. Recently I was asked how is this done in NAV 2016. Bron : NAV musings Lees meer...

30 October 2017

Dynamics NAV & BC Tips & tricks

How to Create SEPA Direct Debit Collection Entries and Export to a Bank File in Microsoft Dynamics NAV 2017

In this episode, I am going to show you how to create SEPA direct debit collection Entries and export to a bank file in Microsoft Dynamics NAV 2017. A Direct Debit Instruction is an authorization from your customer to collect future payments. The details of each…

27 October 2017

Dynamics NAV & BC Tips & tricks

How Do I: Use Visual Studio Code instead of SSMS?

Using Visual Studio Code as a replacement for Sql Server Management Studio is very easy. Once you have downloaded and installed VSCode (download it here), you need to add the mssql extension in Visual Studio Code, which you can find here. Bron : Think about IT…

26 October 2017

Data & Analysis

Exploring The New SSRS 2017 API In Power BI

One of the new features in Reporting Services 2017 is the new REST API. The announcement is here: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/10/02/sql-server-2017-reporting-services-now-generally-available/ Bron : Chris Webb's BI Blog Lees meer...

25 October 2017

Dynamics NAV & BC Tips & tricks

How to Schedule NAV Services to Restart

Recently I was asked if there is a way to schedule a NAV service to restart at a specific time, and for that I have used a small PowerShell script which I have scheduled using windows task scheduler. Bron : Kulla's Blog Lees meer...

24 October 2017

Dynamics NAV & BC Tips & tricks

Start Id(UiDOffset) in Microsoft Dynamics NAV

When you create a new table, page, report, codeunit, query, or XMLport, the elements have IDs that are offset by the Start ID (UidOffset) value that you specify. For example, you can specify a Start ID of 50000 and then create a new page. The first…

24 October 2017