Posted inDynamics NAV & BC Tips & tricks
Calculate recurrence in AL, an alternative to CalcDate
I stumbled over an interesting codeunit in Business Central to help calculate recurrences. Check out the video: Source : Hougaard.com Read more...
Posted inDynamics NAV & BC Tips & tricks
How DO I – Calculate Working and Nonworking Day
In Last article we understand how to setup Base Calendar in #MSDynNAV & #MSDyn365bc. In this article we will see how we can utilize base calendar to check Working and Non-Working Days based on Calendar. Source : Saurav Dhyani Read more...
Posted inData & Analysis
Filtering a Column via a Visual AND CALCULATE
Sometimes, just when you think you are getting the hang of the DAX language, something happens that completely baffles you. Such events can cause you to doubt your own learning and progress. But let me assure you – this happens to EVERYONE at sometime or another.…
Posted inDynamics NAV & BC Tips & tricks
How Average Cost is Calculated in Microsoft Dynamics NAV
We often get questions on how Dynamics NAV calculates Average Cost and have created a simple example below to illustrate. The explanation below comes from a white paper entitled, “Dynamics NAV 5.0 Inventory Costing.” Bron : ArcherPoint Lees meer...
Posted inDynamics NAV & BC Tips & tricks
Calculating COGS in NAV
Generally COGS (Cost of Goods Sold) is an unknown parameter that must be recorded and calculated. We have (or we can have) exactly information about Beginning Inventory and Net Purchases, but COGS depends of Costing Method: Bron : Totovic NAV Blog Lees meer...
Posted inDynamics NAV & BC Tips & tricks
How To Calculate Difference Between Two Dates in Navision 2013 R2 and Higher ?
It was always been a trouble to calculate Difference Between Two Date Time Variables. With Microsoft Dynamics NAV 2013 R2, Dotnet Variable are available which make life easy in so many situations. Today we will discuss one of the Dotnet Component for calculation Difference between days.…
Posted inDynamics NAV & BC Tips & tricks
Using Query Object to Calculate the Cue Data
Today we will learn to create a query to update Cue data. Creating a Query for Calculating the Cue Data First, we will create a query object to calculate the number of open sales invoices from table 21 Cust. Ledger Entry. Bron : Ashwini Tripathi Lees…