Sunday, March 29, 2020

Learning Business Central Development From Scratch: FLF license files

By Steve Endow

As I mentioned in my prior post in this series, I'm starting from absolute scratch when it comes to learning Dynamics 365 Business Central development.  I'm clearly not an expert at this point, so if you find any information in the post that is inaccurate, please let me know.

I've spent months learning how to install and configure Business Central Docker containers, including the many, many quirks of that process.  I've been trying to create a blog post and video on that for months, but given all of the details I want to cover, it's very tedious to prepare and still not complete.

So in the meantime, I thought I would write about one specific detail that I learned while trying to setup a Business Central Docker container.  This post is one of those asides.

As a result of my "newness" (ignorance), I'm running into small issues that are probably obvious to any experienced NAV and Business Central developers, but cause me to stop what I'm doing and spend 15 minutes, 30 minutes, or perhaps several hours to figure out.

The Business Central FLF license file is one of those issues.  Coming from the Dynamics GP world, I know nothing about NAV or BC licenses or license files or how licensing works in BC, other than the user-based licensing for BC SaaS.

If you are going to be working with Business Central Docker containers and include automated testing (which you should!), I suspect you'll need to know about FLF license files.

NAV Container Helper - Include Test Toolkit

Above is a sample call to the NavContainer Helper PowerShell script.  Notice the parameter on the last line:  includeTestToolkit.

Saturday, January 25, 2020

Learning Dynamics 365 Business Central Development From Scratch: Introduction

By Steve Endow

If you've never done any NAV or Business Central development, but would like to, join me on this journey to learn how to develop in Dynamics 365 Business Central.

I've never used Dynamics NAV and don't even know what C/AL looks like.  I don't know what a "code unit" is.  Until a few months ago, I had never used Docker.  And although I've used Visual Studio for years, I don't really know how to use VS Code.  I know that Business Central uses a language called "AL", but I can't write a single line of AL.

Based on my experience so far trying to learn the Business Central application and Business Central AL development, I expect this will be a long journey for me.  Because I am still working mostly with Dynamics GP customers and projects in my day job, I have to learn Business Central in my "free time", so it isn't something I'll be able to pick up in just a few months.  A year ago, I gave myself 2 years to be "minimally competent" with the Business Central application and development.  Well, work gets busy and life gets busy, so I think I'm currently well behind on that 2 year timeline, and need to catch up.

Even though I have over 15 years of experience working with Dynamics GP and .NET and SQL Server, Business Central is a completely different world to me.  My fundamental knowledge of ERP software and software development is somewhat helpful as background, but it seems all of the specifics are completely different.  I want to learn Business Central and AL development and have the same comfort level that I have with Dynamics GP and .NET.  That will take time, and will require some pretty intensive learning.

So I'm starting from scratch.  Learning from scratch.  This is the start of that journey.

Wednesday, July 24, 2019

Dynamics GP: Does GL batch size affect posting performance? Yes, it does.

By Steve Endow

If you need to post 50,000 journal entries in Dynamics GP, should you create one batch with 50,000 JEs?  Or should you create 5,000 batches with 10 JEs each?

If you have the option to import 10,000 JEs with 2 lines each, or a single JE with 20,000 lines, which should you choose?

These are the exciting questions that I ask myself on a regular basis.

I imported a truckload of standard GL journal entries into Dynamics GP to test performance and record some posting benchmarks to understand how GL batch size and JE size affects Dynamics GP GL posting performance.

I was surprised at the results.

Note:  My tests were performed on the TWO / Fabrikam sample database.  In theory, tests on TWO should be reasonably valid and should extrapolate to larger production databases. But in reality, there could be production databases that exhibit very different behavior than what I found with TWO.  For example, any customizations, triggers, or third party products could dramatically change the results.

If you just want the results, here's the TL;DR:  GL batches with more JEs posted at a rate that was 2-3 times faster than batches with fewer JEs.  And journal entries with more lines also posted at a rate that was up to 50% faster than JEs with fewer lines (up to 300 lines per JE).

Wednesday, July 10, 2019

C# and SQL and Dynamics GP: Sending a List to a Stored Procedure

By Steve Endow

This is a discussion of how to send a list of values to a SQL stored procedure parameter.

Specifically, how can a .NET application send a comma delimited list of values to a stored procedure to be used in an "IN" operator in a WHERE clause.

Using a parameter with a WHERE clause IN operator

TL;DR: If you want to jump straight to the solution, read this excellent post on Arrays and Lists in SQL Server by legendary SQL Server MVP Erland Sommarskog.

If you crave to learn about all of the exciting details, read on...

Friday, May 31, 2019

Business Central: Change Log feature

By Steve Endow

Let's talk about the Business Central Change Log feature!

Just Search for Change Log

The Back Story

While poking around Dynamics 365 Business Central recently, I discovered that you can very easily change the main ID, or Number, of master records.

I can just open the Customer Card page, select a customer, type a different value in the Customer No. field, and just like that, Business Central will update (what appears to be) the primary key for the customer and all related records.  Whoa.

The same trick works for Vendors, Inventory Items, and even GL Accounts!  Just open the card page and change the Number field.  No biggie.  Apparently.

Coming from the Dynamics GP world, this is wild.

Thursday, May 30, 2019

How should phone numbers be entered or formatted in ERP and CRM systems?

By Steve Endow

While reviewing the Dynamics 365 Business Central Customer record, I noticed that Business Central allows numbers and symbols, but does not allow any letters in the Phone number field.

This got me thinking...  (ya, I know, dangerous things happen when I think...)

1. How should phone numbers be entered in ERP and CRM systems?

2. How should a system support global phone number formatting?

3. How should a system support phone number extension prefixes (e.g. "x") or notes?

4. How should a system format phone numbers to help support VoIP dialing?

Below are some examples of a few systems to which I have access, and I show how phone numbers can be entered into those systems.

While reviewing how these systems handle phone numbers, I was thinking about my questions above.  I additionally wondered:

What should the minimum length be for phone number fields?  How should users enter phone numbers with extensions?  Should you allow letters in a phone number field?  Should users be able to enter brief notes, like in my examples below?

Initially, I would have thought that restrictions on the phone number values and formats are not required, and users should be able to enter whatever they want / need.  However, if you consider the potential need for VoIP dialing, free form text phone numbers might complicate things.

Wednesday, May 29, 2019

Dynamics 365 Business Central vs. Dynamics GP: Customer Record

By Steve Endow

This is the third post in a series comparing Dynamics 365 Business Central and Dynamics GP, and follows on the post Dynamics 365 Business Central vs. Dynamics GP: Customer Navigation.

In this post, I am going to compare the Customer records of both Business Central and Dynamics GP.

There are hundreds of details of Customer records that can be analyzed, but I'm going to discuss a handful of the things I happened to observe as a long time user of Dynamics GP, but a brand new user of Business Central.

Dynamics GP

I've spent so much time in the Dynamics GP Customer Maintenance window that I no longer notice the details.  As a result, I'm going to have to review it more carefully to try and point out some details that make it unique, along with a few quirks.

How many digits can a Business Central Amount field actually support?

 by Steve Endow (If anyone has a technical explanation for the discrepancy between the Docs and the BC behavior, let me know!) On Sunday nig...