How To Create Items with Different No. Series Using the Item Template in Microsoft Dynamics 365 Business Central

If you are using Microsoft Dynamics Business Central Version 18 or older, you cannot see item, customer, or vendor templates, making the job of creating a new record more manual. In later versions, after Version 18 however, you can simply search for “Item Template”, “Customer Template”, or “Vendor Template” to find any of those templates

Source : ArcherPoint
Read more…

Power BI Custom Format String Examples, Part 1: Numbers

Now that we can apply custom format strings to fields and measures in Power BI in the September 2019 release, I thought it would be useful to provide some examples of what’s possible with this very flexible new feature because the existing documentation for VBA isn’t easy to make sense of. In fact there’s so much to say I’m going to have to write a series of blog posts to cover everything! In this first post I’m going to look at formatting numbers.

Source : Chris Webb’s BI Blog
Read more…

Generate Number Series from one Company and use it in another company

When dealing with Number Series where the Intercompany Documents are created automatically using the code, using standard number series generation Codeunits cause problems. In this blog, I’ll be explaining why this issue is caused and how to resolve such issues.

Read more…

Count the Number of Records in NAV/Business Central

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
Lees meer…

Converting Decimal Numbers To Hexadecimal In Power Query M

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
Lees meer…