Microsoft Dynamics 365 Business Central EOL

Find Unsupported Dynamics 365 Business Central Installations

Formerly known as Dynamics NAV and Navision, in 2018, the product was rebranded to Dynamics 365 Business Central. This enterprise resource planning (ERP) system from Microsoft is designed to help small to medium businesses (SMB) with their finance, manufacturing, customer relationship management, supply chains, analytics, and electronic commerce operations. The product has both a SaaS version and an on-premise version, however, for this specific end of life, we'll be focussing on the on-premises version. The 2021 release wave 1, version 18.x will be going end of life on October 11, 2022.

You can read more about the Microsoft Dynamics AX lifecycle in our Microsoft Dynamics EOL blog post.

Updates:
2022/11/29: EOL date Version 21.X added

Microsoft Dynamics 365 Business Central EOL Query

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.Version As OSVersion,
tblAssets.SP,
subquery1.Software,
subquery1.Version,
subquery1.Publisher,
subquery1.EOLDate,
Case
When GetDate() < subquery1.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery1.EOLDate) As NVARCHAR) + ' days remaining'
End As [Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When GetDate() > subquery1.EOLDate Then '#ffadad'
When GetDate() >= DateAdd(month, -1, subquery1.EOLDate) Then '#ffd152'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select tblSoftwareUni.softwareName As Software,
tblsoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Case
When Cast(ParseName(tblsoftware.softwareVersion, 4) As int) < 13 Then
'EOL'
When tblsoftware.softwareVersion Like '13.%' Then '2020-04-14'
When tblsoftware.softwareVersion Like '14.%' Then '2025-10-14'
When tblsoftware.softwareVersion Like '15.%' Then '2021-04-13'
When tblsoftware.softwareVersion Like '16.%' Then '2022-04-12'
When tblsoftware.softwareVersion Like '17.%' Then '2022-04-12'
When tblsoftware.softwareVersion Like '18.%' Then '2022-10-11'
When tblsoftware.softwareVersion Like '19.%' Then '2023-04-12'
When tblsoftware.softwareVersion Like '20.%' Then '2023-10-10'
When tblsoftware.softwareVersion Like '21.%' Then '2024-04-14'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where
tblSoftwareUni.softwareName Like
'%Microsoft Dynamics 365 Business Central%' And
tblSoftwareUni.SoftwarePublisher Like '%Microsoft%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where subquery1.Software Like '%Microsoft Dynamics 365 Business Central%' And
subquery1.Publisher Like '%Microsoft%' And tblState.Statename = 'Active'

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting