May 2016 – Pardaan.com

Understanding Let Expressions In M For Power BI And Power Query

When you start writing M code for loading data in Power Query or Power BI, one of the first things you’ll do is open up the Advanced Editor for a query you’ve already built using the UI. When you do that you’ll see a very scary…

31 May 2016

Dynamics NAV & BC Tips & tricks

Costing Issue in Microsoft Dynamics NAV

I was surprised to find this major error in one of our client’s Microsoft Dynamics NAV instance. It came about when they converted an Item from produced to purchased. They changed the replenishment system field from Prod. Order to Purchased. They had left the BOM and…

30 May 2016

Dynamics NAV & BC Tips & tricks

Implementing a subscription solution in Dynamics NAV as an extension

Extensions in Microsoft dynamics NAV have the huge benefit that no standard objects are changed - meaning that the application code is left untouched – whilst still being able to implement a tailor-made solution in Dynamics NAV. Bron : Aphorisms about Microsoft Dynamics NAV Lees meer...

27 May 2016

Dynamics NAV & BC Tips & tricks

OnAfter table event subscriber patterns and antipatterns

The purpose of events is to simplify business logic customization while not impeding upgradeability and general extensibility. However, there is one particular class of events that may cause troubles: OnAfter* table events. There are four of them: OnAfterInsert, OnAfterModify, OnAfterDelete, and OnAfterRename. Bron : Vjeko.com Lees…

27 May 2016

Dynamics NAV & BC Tips & tricks

Writing off items to different G/L accounts in Dynamics NAV 2016

Figuring out which accounts are used when adjusting the inventory in Dynamics NAV has always been a bit of a puzzle. The inventory batch will determine the account based on the type of adjustment made. This means that the account will be different depending on which…

26 May 2016

Dynamics NAV & BC Tips & tricks

RDLC Report and Performance in Microsoft Dynamics NAV 2015 and 2016

The main focus of my dissertation now is based on the improvement made with Microsoft Dynamics NAV 2015 and 2016 related to report performance. I would encourage you to post your comments and thoughts, as usual. Have a good read. Bron : Dynamics NAV Team Blog…

26 May 2016

Dynamics NAV & BC Tips & tricks

Printing from extensions in Dynamics NAV

Did I mention in my last blog post that it is not possible to print reports from extensions? Well I just remembered that we had the same problem printing from web services in Dynamics NAV 2013 R2. We got around that by creating a Job Queue…

25 May 2016