2018 – Page 21 – Pardaan.com

User Specified Growth on an Investment using Power BI

I wrote an article earlier this year that showed how you can take a table of future growth rates (different growth rates each year) and then calculate the future value of an investment using DAX. I had a follow up question from Steve asking if it…

16 July 2018

Dynamics NAV & BC Tips & tricks

Canceling disposed fixed assets entries Dynamics NAV

The disposed entries can be canceled by using the cancel entries from the FA ledger Entry. Lets check how we can achieve this on a standard database. Bron : Manish Sharma blog Lees meer...

13 July 2018

Data & Analysis

Using Power Query for Extracting Non-Tabular Data from Web Pages

Ivan: I recently moved to Australia with my family. While searching for a place to live I had to look for a good pair of suburb and school. I found interesting data at https://www.myschool.edu.au/. However, there is no option to compare schools. It just gives some…

12 July 2018

Dynamics NAV & BC Tips & tricks

Converting an ISV solution to an extension: The Beginning

I’ve been a bit neglectful of this blog for the past couple of months, but with good reason. I’ve been jumping around multiple projects, and have now landed on a project that will involve taking a roughly 3000 object ISV solution and converting it to an…

11 July 2018

Dynamics NAV & BC Tips & tricks

CRS AL Language Extension – File Management

Time for the next round of functionality I added in my VSCode Extension (the CRS AL Language Extension) – a functionality that manages your filenames (and pre/suffix). Hold your horses – this is going to be a long one ;-). You don’t want to know how…

10 July 2018

Dynamics NAV & BC Tips & tricks

Create apps with PowerApps and Dynamics NAV

Some of you have tried to build apps using PowerApps and the connector for Dynamics NAV. For some, it turned out to be more difficult than expected, and you've asked for some guidance from Microsoft. Well, here we go: The Dynamics NAV connector requires ODataV4, and…

9 July 2018

Dynamics NAV & BC Tips & tricks

How to send Notes to the Customer from a Custom Page using an Action button in Dynamics NAV

A Custom page called Collection Module-Per User has details of Customers Transaction. This Collection Per User page is a List page. The User will select the line and Click on Notes. Notes will written and saved. The user will Click on the Action button Send Notes…

6 July 2018