Skip to main content

Posts

How to find the the root cause of Business Central not being accessible and resolving it - Part 1

Introduction:In this blog, I will be discussing the approach of handling the Business Central downtime from an End User's perspective. I will be addressing how to debug and understand what could be a possible source of error which is could be causing the downtime of Business Central Production & Sandbox.

Pre-requisites:1. Microsoft Dynamics Business Central2. Access to Business Central Admin Center 3. Access to Office 365 AdminProcedure:1. Check if you have a license assigned to your user: If you get the licensing error like the below, you need to confirm if you're getting logged in with the correct user and your license is correct.



You can go to home.dynamics.com to verify the user logged in.
To be sure if this is not a license issue, kindly contact your Administrator or a friend who has access.
In Tell Me key in 'Users' > Select the User At this point, if your Administrator says that there is a License assigned to you in Office then you need to ask them to refresh th…

Announcement: Support for unlimited number of Production & Sandbox coming soon!!

ANNOUNCEMENT:

September 1st, 2020 Microsoft has informed the existing Business Central customers through their Admin Center with the below message. Microsoft will be updating the Release Plan, Licensing Guide, and CSP Pricelist by 7th September 2020.Link to Release Plan
Value Proposition:As you know that the maximum of 3 Production Environment can be created, Microsoft has decided to provide the option of adding unlimited Production Environments. These Production Environments can be purchased through CSP separately.

Along with these Production Environments how many Sandbox environments will be available is NOT YET FIXED. Tentatively this ratio is for every 1 Production there will be 3 Sandboxes available.

Also, as per my understanding, the Database Space(80 GB) is allocated separately for Production and Sandbox. Hence, the 80 GB size will be shared between multiple Production and similarly for Sandbox as well.

With every Production Environment extra 4GB Database Capacity will be added. It …

Exposing Dimension and Dimension Values in General Ledger Entries

Introduction:Ever felt a need to expose Dimensions on G/L Entries? Wouldn't it be simple to check-in G/L Entries or perform a Pivot in Excel directly?Well, that is exactly what I'm planning for.

Use Case: Add the 2 Global Dimension  & 6 Shortcut Dimension to G/L Entries Table in Business Central. These fields should be downloadable in Edit in Excel.

Pre-requisites:Microsoft Dynamics 365 Business CentralVS CodeAL Language Extension Procedure: 1. Adding fields to the Page: I will be creating 8 variables on the G/L Entry Page of the Type Code[30] and add the variables as fields to the page.
2. Adding Logic to fetch data into the fields: The fields that were recently created needs to be filled in with values for each and every record. Dimension Set Entries table consist of Dimension Set ID (Integer) and Dimension Code which will be getting from General Ledger Setup. 


Output:



Exporting to Excel:



Conclusion: I hope this helps you in generating some sort of reporting & analysis directly …

How to bypass Multi-Factor Authentication or Email Authentication issue for Office 365 / Microsoft 365 Emails

Problem Statement:When MFA has introduced a couple of months ago in Office 365 / Microsoft 365 or made mandatory for a certain set of accounts, Microsoft Dynamics 365 NAV / Business Central had issues sending email through SMTP Email.
Pre-requisites:Office 365 / Microsoft 365 AccountEnabled OutlookMicrosoft Dynamics 365 Business Central Demonstration:1. Creating App Password for Multi-Factor Authentication based Accounts:After you have set up MFA, Microsoft 365 allows you to create a One-Time password to login to the corresponding apps. This password cannot be viewed again so copy it somewhere. Follow the process below.









2. Enabling Authenticated SMTP in Office 365 / Microsoft 365 Admin Center:
After you have a password created, you need to check if you Mail Apps have the access to your email. Follow the process below to enable. After this, you just have to use your  Email and App password created in Step #1 in SMTP Setup and run the Test Email.


Conclusion:That's all and I'm happy th…

How to Transfer Files through API using Base64 Stream to Business Central

Introduction:
Transferring data from Business Central Tables through API is one of the latest version of transferring data from or to Business Central using the API Page Objects or  Web Services. Well, it gets a little difficult to transfer file blobs using the Media.ReadLinks and Media.EditLinks JSON field.

Pre-requisite:
Understanding of Business Central APIUnderstanding how Blobs are accessible to Business CentralAL Language ExtensionVS CodeUnderstanding of JSON Data Types References: https://www.olisterr.tech/2019/09/understanding-apis-in-business-central.htmlhttps://demiliani.com/2020/01/24/dynamics-365-business-central-handling-blob-fields-on-apis/https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/jsonobject/jsonobject-data-type
Solution:

1. Using Business Central API to Pass Data from  BLOB to Base64 String:
Whenever you have a file in a BLOB field and want to transfer as a Base 64 string to API - POST Request.



2. Reading the API into Business …

Wave 2 2020 Release Plan for Business Central Review - 1

Announcement: Wave 2 2020 Release Plan for Business Central is available! Yesterday, 8th July 2020 at 5PM IST Microsoft Officially release the Wave 2 2020 Release Plan and a list of upcoming features.
Source: https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/planned-features
In this blog, I will highlight all the upcoming features and explain them in detail and how they help us.

Abbreviations:  GA - General Availability PP - Public Preview  N/A - Not Available
Administration:
1. Deprecation of Legacy Dynamics NAV Help Server Component:
PP - N/A; GA - Oct 2020 Since the ages of NAV, we are given an option to install the NAV Help Server Component.As a part of Business Central On-Premise  we still do get the documentation although it hasn't changed much. Also, SaaS version has the help server preinstalled on the App Service as well.Microsoft is planning to deprecate the Legacy version of the help server and replace it with web hosted help.Micr…

Announcement: Microsoft Dynamics Accountants Hub is retiring and will be upgraded to Business Central Extension!!

Announcement: Microsoft Dynamics Accountants Hub is retiring and will be upgraded to Business Central Extension!!

Yesterday I received an email from the Microsoft Accountant Hub's Team. An email has been sent to me because one of my Tenant had an active Accountant's Hub Subscription with Business Central. Moreover, the Accountant's Hub was under public preview for countries such as  US, Canada, UK and Denmark for approximately a year. New sign-ups to Accountant's Hub has been disabled as on July 1st 2020 and will be retiring as Accountant's Hub through Dynamics Home.

A new extension will be released in Business Central to handle the Accountants Hub's functionality as on October 1st 2020 i.e Microsoft Dynamics 365 Wave 2 2020 Release.

Existing Users of the Accountant's Hub will have the access to their Accountant's Hub Tenant till October 1st 2020. Microsoft has not provided any details regarding migrating users from Accountant's Hub to the Business Centra…

Microsoft Dynamics - Business Central 16.3 is out!!

Update 16.3 for Microsoft Dynamics 365 Business Central 2020 Wave 1 (Application Build 16.3.14238, Platform Build 16.3.14195) is out!!

To Upgrade  you Business Central, please visit https://www.olisterr.tech/2020/04/how-to-upgrade-your-business-central.html
Source:https://support.microsoft.com/en-us/help/4563407/update-16-3-for-microsoft-dynamics-365-business-central-2020-release-w For the list of updates released for Business Central 16.2 visithttps://www.olisterr.tech/2020/06/microsoft-dynamics-365-business-central.html
Key Features / Hotfixes / Updates
Platform Hotfixes IDTitle353587The application programming interfaces (APIs) that use another API as sub-entity make API Service unavailable (HTTP 500).360090Columns get misaligned and the list is scrolled when you press the TAB key.359296HttpClient HEAD calls are blocked even if the real size of the content is very small because NavHttpClientMaxResponseContentSize checks content-length parameter for this Call method.361386The return code …