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.
Tag Archives: Calculation
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 up in case anyone else ran into it.
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.
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 using methods; Average, Exist, Count, Max and Min. In a normal SQL it is possible to use NULL to archive this result but not in NAV.
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 as identification that somewhere in time the average cost is unexpected. It helps to identify the area for deeper research of the records demonstrating unexpected values.