Vjeko, wrote some very good posts about the bad performance of COUNT function used in Microsoft Dynamics NAV. You can check them out at the end of this post.
COUNT function can be used in NAV to find out how many records with certain filters you have in the database.
Let’s take a simple example and check also what happens at SQL Server queries level when you use COUNT vs when you use a NAV Query:
Bron : Andrei Lungu
This is a very short post! A lot of people have blogged about how to convert numbers between different bases in M (see for example Maxim Zelensky’s very elegant solution for converting from binary to decimal), but today I noticed there was a very easy way to convert a decimal number to hexadecimal using the Number.ToText() function: you just need to use “x” in the second parameter.
Bron : Chris Webb’s BI Blog
I got my haircut today (pretty spiffy one too, even if I do say so myself). While I was chatting I asked my hair dresser “on average, how often should I get my hair cut”? She told me (for men) around 4-6 weeks. Then I got thinking (as I do), I wonder if I could data-mine my credit card data using Power BI and find out how often I actually get my own hair cut. It turns out I was able to do this, and this article explains the hardest part of that task – find the number of days between two transaction dates using DAX.
Bron : Excelerator BI
This blog shows how multiple number series are to be set up for a single field in NAV. The number series has to be setup dynamically on Assist-Edit of the page.
Bron : Cloudfronts
Learn how to increase productivity and efficiency by using the Document Number Formulas within the Recurring Journal feature in Microsoft Dynamics NAV.
Bron : ArcherPoint
Every developer has sometimes the issue: What is my next version number for the new object ? If there is a couple of developers working in the some database, you’ll need a kind of a version control. I’ve developed a page, which calculates the next version number for a defined version prefix.
Bron : Archer’s NAV Blog
A European law defines that unless you can prove that a company has a valid VAT registration in their country, full VAT must be charged om selling products or services between European countries.
It is therefore necessary to validate each company VAR registration number.
Bron : Aphorisms about Microsoft Dynamics NAV