Calculation – Pardaan.com

How to extend price calculation

There is 2 to extend Price Calculation in Business Central, either by subscribing to events or by implementing an interface. Both can useable in different scenarios. Here I will make a simple example of how to do it by implementing an Interface. Source : BCDEV.TECH Read…

30 December 2022

Data & Analysis

Power BI Desktop, Sort By Column And DAX Calculations That Use The All() Function

Recently I came across a problem where a DAX measure gave different results in Excel and Power BI Desktop. It turned out not to be a bug or even a feature, but since it confused me for a few minutes I thought it was worth writing…

4 January 2016

Dynamics NAV & BC Tips & tricks

Microsoft Dynamics NAV Quick Tip: Become Speedier with Calculations

You may not know that you can perform calculations in a numeric field inside of Microsoft Dynamics NAV. Doing the math inside the cells will save you time, rather than having to go to Microsoft Excel or using a calculator. Bron : ArcherPoint Lees meer...

23 May 2014

Dynamics NAV & BC Tips & tricks

Ommit Zero in Calculation Formula

There are a few calculation methods available in for a flowfield. This is a great feature in NAV to aggregate amounts from ledger entries. I would like Microsoft to add an option to the flowfield declaration. I would like to be able to omit zeros when…

3 May 2012

Dynamics NAV & BC Tips & tricks

Simulation of Average Cost Calculation

In the scenario below there is process description for simulating the average cost calculation. This is often used when investigating costing issues related to the average costing method. It has been helpful in verifying the recognized COGS, to describe the average cost calculation or using it…

23 January 2012