Field – Page 6 – Pardaan.com

Tip #67 | Convert Option field to Enum Field

Today I was working on our ForNAV AppSource App and I decided to clean up some of the warnings that were introduced with BC16. This was about converting Options to Enums and vice versa. Converting an Enum into an Option is easy. Just add ToInteger() and…

12 May 2020

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: handling BLOB fields on APIs

I’m not a big fan of using BLOB fields on the Dynamics 365 Business Central database, but there are many scenarios where you need to handle BLOBs inside the database directly. As an example, imagine to have an application that handles different types of labels related…

29 January 2020

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: again about obsoleting fields

More than an year ago I’ve written this post explaining how to handle breaking schema changes on a production Dynamics 365 Business Central SaaS tenant. I think that every Dynamics 365 Business Central developer now knows that in a production environment you cannot remove objects or…

6 January 2020

Dynamics NAV & BC Tips & tricks

Microsoft Dynamics 365 Business Central Spring update changed “some” field lengths

For long, we (as a partner community) have been asking for longer field lengths. And this time, Microsoft seems to have delivered: about 860 field lengths were changed. Mostly from Text50 to Text100, but also from Text30 to Text50 and so on. For your convenience, I…

4 June 2019

Dynamics NAV & BC Tips & tricks

Now with the longest fields!

This is a great blog post to write. A long time ago I bitched about the artificial limit we still had, inherited from the old native database. Read it here for a quick refresher https://www.hougaard.com/nav2017s-inheritance-from-the-native-database/ Luckily for all of us, Kennie https://twitter.com/KennieNP from Microsoft actually reads…

17 April 2019

Data & Analysis

Conditional Formatting with a Text Field in Power BI

One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI. Last week, John asked me how to apply conditional formatting with a Text field (not a…

10 April 2019

Dynamics NAV & BC Tips & tricks

How To: Add a Field in an Extension in Microsoft Dynamics Business Central/NAV

This blog explains how to add a field in an extension in Microsoft Dynamics NAV or Business Central. The steps involved are: 1.Creating a table extension 2.Adding a field to the table 3.Creating a page extension 4.Placing the field on the page Bron : ArcherPoint Lees…

22 January 2019