Skip to main content

Posts

Showing posts from 2023

New way of Developing Promoted Action Categories in Business Central

Introduction:  We know about the PromotedActionCategories and how Promoted action looks and feels in Business Central. In this blog, I will explain the new action bar-related changes in Business Central AL Development and how to create new promoted action categories. Pre-requisites:  Basic Understanding of  Promoted Action Categories Books & References:  https://yzhums.com/20903/ Demonstration:  Currently, there are two ways to have Promoted Action Categories Microsoft has introduced a new action area feature in Business Central which makes adding Promoted Actions easy on the Action bar. Earlier, we used to create the Promoted Action Categories by defining them in Page Property and using the PromotedCategories in action. Refer link in References This will be allowed but moving forward, we will need to use the new way. 1. Create Action: You will create the actions as usual with the area as processing or creation page 50100 Test {     PageType = Ca...

Business Central Copilot Edition Developer Insights

Introduction:  In this blog, let's explore the Business Central Co-Pilot Edition in Business Central. This blog is regarding the Business Central integration with Open AI(ChatGPT) from Microsoft. Pre-requisites:  Business Central v22(Copilot Preview) Books & References:  https://learn.microsoft.com/en-us/dynamics365/business-central/ai-preview-getstarted https://learn.microsoft.com/en-us/dynamics365/business-central/ai-overview Demonstration:  1. Setup Business Central Co-pilot Edition: Before the release of Business Central v22, a co-pilot preview was released. This edition provided the AI tools used by Business Central to do the basic marketing texts and reporting. You could earlier create a preview for Copilot. But with BC v22, you will get it included. Below is the Business Central version with a co-pilot edition 2. How to use: Open the Item Card, and you will see the Marketing Text. This will generate the Marketing Text based upon the attributes present in I...

Resolving Error - 'Invoke-NAVApplicationDatabaseConversion: An unexpected error occurred after a database command was cancelled.'

Introduction: While doing Data Migrations from BC14 to BC22, there was an error ' Invoke-NAV ApplicationDatabaseConversion: An unexpected error occurred after a database command was cancelled.' in Business Central in the Database Conversion. I confirmed the DB connectivity is working fine and failed only at Invoke-NAVApplicationDatabaseConversion. Pre-requisites: 1. Understanding of BC Data Migrations 2. Basic understanding of SQL versions Demonstration: As you know that while upgrading NAV / Business Central, you are requested to run the Application Database Conversion. In this case, I was directly trying to convert from BC14 to BC22 and I ended up with this error. To confirm this I checked the Upgrade compatibility matrix  https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-v14-v15-compatibility  and then there was an unexpected error. I tried to do the steps again and seem to receive the error again. After checking the Event Viewer it w...

Resolution to Cloud Migration Error - Enable Change Tracking in DB

Introduction: While I was trying to upgrade BC14 On-Premise to BC22 Saas, I noticed the following error in Cloud Migration Setup. Business Central Cloud Migration Error " Change tracking must be enabled in the source database with a recommended retention period of at least three days" This blog provides a step-by-step guide on how to resolve this issue. To know how to setup Cloud Migration follow the link -  Cloud Migration Setup Pre-requisites: Understanding of Cloud Migration Business Central v14 On-Premise Business Central Saas Subscription Books & References: https://www.olisterr.tech/2022/03/migrating-data-from-business-central-on.html https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server?view=sql-server-ver16 Demonstration:  1. Error scenario: While setting up the Cloud migration with BC On-premise to BC Saas, I got the error  Change tracking must be enabled in the source database with a recommended retention p...

Business Central Office Hours Calls - On Demand Recordings

What is Business Central Office Hours call? The Business Central office hours call is your opportunity to learn more and connect with the Business Central engineering team. At each call, Microsoft presents a current topic related to the development. The presentation is followed by a Q&A session, where you can get answers to general questions related to the topic. How to register for a Business Central Office Hours call? Click on the link below and register for the sessions listed. https://info.microsoft.com/WE-NOGEP-CATALOG-FY22-06Jun-09-DKWC045-Business-Central-Office-Hours-Calls-SRDEM116158_Catalog-Display-Page.html Where are the recordings for Business Central Office Hours Call? You can access the recordings by clicking on the link below. For simplicity, I have listed them below. https://aka.ms/BCOfficeHoursRecordings Date Topic Link 16-05-2023 Business Central administration overview DKWC045 Business Central administration overview | Watch Now...

Universal Code Error and Resolution

Introduction: On Friday, May 12th, 2023, the Business Central On-Premise Production Environments started throwing universal code errors as follows. This occurred to every customer on a lower version of BC 19,20 and 21 irrespective of their localization, customization, and license. Pre-requisites:  Understanding of Technical Upgrade in Business Central On-Prem References: BC20 On prem. Universal Code requirement error after installing customer's license. - Dynamics 365 Business Central Forum Community Forum (40) Yammer : Dynamics 365 Business Central Development : View Conversation Root Cause: The certificate that signs Microsoft Base Application was expired. Errors started occurring if you Uninstalled, Installed Extensions, Restart Server Instances or for some even out of random started popping out. We first thought could be a license issue as we had fixed that before but this did not solve the issue. Resolution: Microsoft identified the issue and posted the following update The mi...

Copy Data from Companies Using Configuration Worksheet.

Introduction: In the earlier version of Business Central, the only way to copy data between companies was either to copy the company or upload the data through Configuration Packages or Rapid Start. Microsoft introduced Copy Data from Companies to copy data from specific tables in companies to your respective table in your company. In this blog, I will be sharing my experience in copying data from other companies into my current working company. Pre- requisites : Microsoft Dynamics 365 Business Central(On-premise / SaaS) Demonstration: 1. Setup Configuration Worksheet: Configuration Worksheet is a page through which you can copy the data from other companies to your working company. You can search on Tell Me to search for Configuration  Worksheet. You can go ahead and add the table for which data you want to copy. For CRONUS, the default Configuration Worksheet looks as per the screenshot below. 2. Run Copy Data from the Company: In the actions, you will have the ability to click o...

Data Search in Business Central

Introduction:  In this blog, I will be sharing my insights on Business Central. The Data Search extension is created by Microsoft to search for Data in Microsoft Dynamics 365 Business Central. Pre-requisites:  Microsoft Dynamics 365 Business Central Data Search Extension Books & References:  https://learn.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/search-company-data-preview Demonstration:  1. Understanding the Feature: Microsoft has recently introduced a feature(through extension) known as Data search. The overall flow of  Data Search is that you can do a Tell Me Search > Data Search > Input your Search String and you will get where the Data is present. You can navigate to a specific record by clicking on the result. You can also make the job easier by selecting which tables you want this search job to look for the string. In Actions, you can see all the tables you want to include in Data Search. 2. Explori...

Microsoft Loop - First Glance

Introduction:  In this blog, we will explore Microsoft Loop App. We will learn about the basics of the Loop App and how it can become one of the best productivity tools. Pre-requisites:  Enable Loop App for your Organization Books & References:  Enable Loop for your Organization Details on Loop Demonstration:  1. Signup / Sign-In: You will need to visit  aka.ms/loop  to get started with Loop Setup. Once you open the link, you can click on Sign In  Once, you select the Users to Login Once you are logged in with User , you will be able to view the Loop App. If your organization has not enabled, you can enable the access using  Enable Loop for your Organization I tried to create a new signup with a different trial account. Hit get started with Loop. Once the Get Started button is clicked,  you will b redirected to main loop page.   After hitting Get Started with Loop, you will get a message to wait and immediately redirected to the loop...