Function – Page 7 – Pardaan.com

Dynamics NAV PowerShell: Creating an enhanced Get-NAVServerInstance function

Between the many hours of preparation of all the conventions (there are a few surprises I can only talk about after Directions EMEA – but is eating up a lot of time ..), let’s make time for this tiny little function that I tend to use…

29 September 2015

Dynamics NAV & BC Tips & tricks

How to use FINDSET function in Dyamics NAV?

So, do you know how to use FINDSET function? Of course you do… you always use it like IF FINDSET THEN REPEAT UNTIL… right? You have it in your blood. You have used it so many times… you can’t even remember when was the first time…

11 September 2015

Dynamics NAV & BC Tips & tricks

Database function

EXPORTDATA Function (Database) Exports data from the Microsoft Dynamics NAV database to a file. The data is not deleted from the database. Syntax [Ok:=] EXPORTDATA(ShowDialog, FileName[, IncludeApplicationData][, IncludeGlobalData][, CompanyRecord]) Parameters ShowDialog Type: Boolean Specifies if you want to display a dialog box where the user can…

31 August 2015

Dynamics NAV & BC Tips & tricks

NAV Report – How To Use Excel SUMIF Function?

I think most of us know SUMIF Function IN Excel, Those who don't know below is a sample. Suppose I Export my Item Ledger Entries Data in Excel. Now I want to see the Total Quantity Sum where Entry Type Is Sales or Purchase. Bron :…

3 June 2015

Dynamics NAV & BC Tips & tricks

Tips & Tricks – Single Parameter Function Shortcut & Gotcha

Recently I discovered (quite by accident) this neat little feature in Dynamics NAV (not sure which version this became available in to be honest). The basic overview is this. If you have a function that takes a single parameter, you can assign the value to the…

19 February 2015

Dynamics NAV & BC Tips & tricks

How-to: Jump to a Function from C/AL Globals

So here is me picking up blogging again. Haven't been doing that a lot lately and can't say my list of subjects diminished. You know it's not only time that helps this list to grow. Performing C/SIDE courses, which I have been doing a lot lately,…

12 June 2014

Dynamics NAV & BC Tips & tricks

Function Return Value Types

Programmers skilled in other languages may have some difficulty understanding why C/SIDE doesn’t allow all of its data types to be used as function return value types. I guess it is a limitation that you and I have learnt to work around, or even use to…

7 April 2014