Skip to main content

Posts

Showing posts from September, 2019

Change in URLs for Business Central Tenants

Change in base URLs for Business Central SaaS Tenants. I have noticed the Business Central links for Tenants have changed. For Production the URL in use will be https://businesscentral.dynamics.com/<Tenant ID>/Production whereas earlier the URL https://businesscentral.dynamics.com/<Tenant ID>/ For Sandbox the URL in use will be https://businesscentral.dynamics.com/<Tenant ID>/Sandbox whereas earlier the URL was the same as current URL This changes are mainly to distinguish between the multiple Production Tenants coming up in October with the 2019 Wave 2  Release. For now, both the Old and New Production Tenant URLs are operational. If you login through  https://home.dynamics.com/   or through Admin Center it will redirect you through the New URL. I will keep you posted as soon as notice an updates. #msdynbc #msftadvocate #businesscentral #changeinurls #msdyn365bc

Record Deletion Tool in Business Central

Introduction: After a successful Go-Live in Business Central, we somehow need to delete a record from Backend. There is no way of doing this until you write a code to delete the specific record. I also had a word with Microsoft Support Team who recommend taking this approach. Thus I have created a Generic Record Deletion Tool where you have to put your Table Number and Primary Keys to delete the specific record. Record Deletion Tool :  https://github.com/olisterr/Data-Deletion-Tool/blob/master/Report%2050199%20DataDeletionReport.al Pre-requisites: Microsoft Dynamics Business Central Books & References: https://forum.mibuso.com/discussion/6922/how-to-setrange-and-find-a-record-with-recordref-datatype Demonstration: NOTE: This tool is available for free without any warranties. Use it at you own risk. 1. Global Search for the Tool: Searching for the Record Deletion Tool 2. Filter records by Table No. and Primary Keys: Filling in the Table No. and Primar

Understanding and How to use APIs Business Central - 2

Introduction: In my last blog post ( Business Central API -1 ) on Creating API in Business Central, we discussed all the commonly used properties of the page, query, and controls like field and data-item. In today's blog, we will be diving deeply into the validation of the data passed through the API endpoint, how it enters into the source tables and is manipulated to be inserted/modified into single or multiple tables. Also, I will be demonstrating how APIs are to be used. Pre-requisites: Microsoft Dynamics Business Central (SaaS) VS Code( https://code.visualstudio.com/download ) AL Language Extension( https://tinyurl.com/yyvzxwkb ) API V1 from Business Central On-Premise DVD Books & References: API V1 from Business Central On-Premise DVD API(V1.0) for Business Central ( Click Here ) API(Beta) for Business Central ( Click Here ) Theory: Understanding API in Business Central 1. BINDSUBSCRIPTIONS: Use to trigger IntegrationEvent for the Codeunit stated

Bug in NAV / Business Central when Cancelling Posted Sales Credit Memo

Introduction: With the evolution of Microsoft Dynamics 365 Business Central from Microsoft Dynamics NAV, many of us did not get the chance to completely explore Business Central to its entirety. One such bug that I found in Business Central is when you Cancel a Posted Sales Credit Memo, system throws an error. Let take a closer look at the bug. Pre-requisites: Microsoft Dynamics 365 Business Central Microsoft Dynamics NAV Demonstration: When Cancelling a Posted Sales Credit Memo, the error I get is  ' The General Posting Setup does not exist. Identification fields and values: Gen. Bus. Posting Group='DEFAULT',Gen. Prod. Posting Group='' ' When I created a General Posting Setup with Gen. Business Posting Group as 'DEFAULT' and Gen. Prod. Posting Group as '' I get an error  ' Gen. Prod. Posting Group must be filled in. Enter a Value. ' This in not only related to Posted Sales Credit Memo but all the Fi