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:

2. Filter records by Table No. and Primary Keys:

3. During Record Deletion:

4. After Record Deletion:

Conclusion: This Record Deletion Tool I have added as an extens…

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 DVDAPI(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 in parameters whenever the function calling BI…

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 Financial Documents that do not use Gen. Produ…