Monday, November 30, 2020

#msdyn365bc - How to access SQL database inside docker container ?

Hi Readers,

This is one of the common questions that is asked so many times. 

Question - How can I access my database inside Docker Container in SQL Server Management Studio?

There are situations where you would like to see data stored in SQL Server that is mapped for the docker container. 

There can be multiple reasons to have access the SQL Server.

In this article we will see how easy it is to access SQL Database mapped to docker container.

Friday, November 27, 2020

#msdyn365bc - Copy journal function on Posted General Journals.

Hi Readers,

The 2020 release wave 2 delivers a set of features which are requested by customers and Partners. In this article we will discuss about one of such feature which was added in Business Central based on Idea summited.

In this article we will discuss about that feature as a process and technically. 

After this article I hope you will be able to use and also understand how to technically handle customs with respect to General Journal.

Thursday, November 26, 2020

#MSDyn365BC - Enabling Upcoming Features Ahead of Time.

Hi Readers,

With #MSDyn365bc 2020 Release Wave 2, Microsoft have enabled a New feature called "Feature Management".

In this article we will understand - 

  • How administrators can turn on new features using the Feature Management page. 
  • What we need to take care before enabling new feature in Business Central.

Wednesday, November 25, 2020

#MSDyn365BC - What's New in 2020 release wave 2 Administration?

Hi Readers,


The 2020 release wave 2 delivers a set of features that are designed to simplify and improve the way partners administer tenants, and the way administrators carry out administration tasks for licensing and permissions.

In this article, we will list down what's new in #Msdyn365bc 2020 Release Wave 2 administration is summary.

If you would like to understand more about any of the topic listed below, Please let me know as comment to this article.

Tuesday, November 24, 2020

How DO I - Calculate Working and Nonworking Day in #MSDynNAV & #MSDyn365bc.

Hi Readers,

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. 

This is actually a question during last #bcopendiscussion from Shahid Ullah.

Question - How to find the Workings Days in a month or from a given date range?

Monday, November 23, 2020

Setup Base Calendars in #MSDynNAV & #MSDyn365bc.

 Hi Readers,

In last week #bcopendiscussion we discussed about Base Calendars.

With Microsoft Dynamics NAV and Business Central one of the feature that is not much talked about is Calendars.

With this feature you can define your working and non-working days which will also help in date calculations in Business Central.  

The main task in setting up a new base calendar is to specify and define the non-working days that you want to apply.

In this article, we will discuss about steps to setup Base Calendar.

Friday, November 20, 2020

#MSDyn365BC Reduce Data Stored in Business Central Tenant - Compress Tables?

Hi all,

In Part 1 and Part 2 we discussed about few ways to Reduce Data Stored in Business Central Database that includes -

  • Delete unused companies
  • Delete documents
  • Use retention policies
  • Migrate BLOB data types to Media or MediaSet

In this article, we will understand a Compress Tables Feature with Business Central.

Thursday, November 19, 2020

#MSDyn365BC Reduce Data Stored in Business Central Tenant - Part 2?

Hi all,

In Last article we discussed about some quick ways to delete unused data from the system using standard Microsoft Batches.

I Hope you also feel in the same way as I do about cleaning up database to keep it manageable, easier to Upgrade and Upgradable to BC Online.

Clean Data also increases the performance of code. 

In this article, we will try to understand what else is in store for clean-up data in database.

Wednesday, November 18, 2020

#MSDyn365BC Reduce Data Stored in Business Central Tenant - Part 1?

 Hi all,

We all understand that our customer databases size increases as we use Dynamics NAV or Business Central. We as partners are not the right person to suggest you which data is important for your business.

At same time we understand that there is a size limit in Business Central Online.

We as customers & partners need to start thinking about data that we can remove to reduce our database sizes.

Tuesday, November 17, 2020

#MSDyn365BC 2020 Wave 2 - Data Audit System Fields.

Hi Readers,

In this series of articles we will discuss about what's new in the product with Business Central 2020 Wave 2.

With Business Central 2020 Wave 2 (V17), Microsoft have added Data Audit System Fields in all Tables.

In this article we will understand what that means and how developers can utilize these fields with AL Programming.

#MSDyn365BC #BusinessCentral

Monday, November 16, 2020

Microsoft Dynamics Navision Cumulative Update Summary For November 2020.

Hi Readers,

A New month and new cumulative updates.

Microsoft Have Released Cumulative Update for November 2020.

Please find below the details of Cumulative Updates Released for Microsoft Dynamics NAV 2016, NAV 2017 & NAV 2018.

Below are the Links to Download the Latest Cumulative Update.

#NAV2016 #NAV2017 & #NAV2018

Tuesday, November 10, 2020

Microsoft Dynamics Business Central Cumulative Update Summary For November 2020.

Hi Readers,

Microsoft Have Released Cumulative Update for November 2020 for Business central 14, 15, 16 & 17.


Please find below the details of Cumulative Updates Released for Microsoft Business Central 14, 15, 16 and 17.


Below are the Links to Download the Latest Cumulative Update.

#MSDYN365BC14 #MSDYN365BC15 
#MSDYN365BC16 #MSDYN365BC17

Tuesday, November 3, 2020

Highlights from First Ever - #DirectionsVirtual.

Hi Readers,

Today First ever #DirectionsVirtual kicked off. Due to Covid this event was switched to being virtual. 

As expected its a great session, to network and hear great about product. #directions4partners is combination of Directions EMEA and Directions Asia.

I am participating this year and trying to be presenter. During my session recording I learned that I am not a camera friendly person. 

But so much about me, lets talk about some news that is for everyone from Day 1 of Virtual Directions.

#Directions2020 #directions4partners