Thursday, 3 May 2018

Tenant Customization Rules in Dynamics 365 Business Central

As I mentioned in my previous training session here,
we came across below error while Uploading Tenant Customization App in production environment.

Publish operation failed with code PackageValidationFailed. Details: Extension validation failed. View the error details for more information.

There are certain rules that needs to be followed while developing tenant customizations.

1.   If we have created PageExtension object then we have to make sure that all Page fields, parts and action controls have ApplicationArea property set.

2.   If we have created new Table object then we have to make sure that
·       Object ID must be in free range.
·       Field ID must be in free range.
·       We have to create new Permission Set with new table created. (I have attached sample permission set format below, these permission sets to be included in folder where we are developing)

3.   If we have created Page Object then we have to make sure that all Page fields, parts and action controls have ApplicationArea property set.

4.   If we have created Report Object then we have to make sure that Report request page field controls have ApplicationArea property set.

5.   Functions must not subscribe to CompanyOpen events.

6.   Property 'target' should not have ‘Internal’ in app.json file.

7.   Encryption key functions must not be invoked.

8.   Test assertion functions are not allowed in a non-test context.

Wednesday, 2 May 2018

Dynamics 365 Business Central Training Session in Mumbai

I have provided one day in-class training session on Dynamics 365 Business Central in Mumbai last Saturday (28th April, 2018) at CloudFronts office.

It was nice meeting NAV team of Cloudfronts and working with them.

They are working on a tenant-based customization app for Dynamics 365 Business Central and having some doubts/issues related to how to move forward and fix them.

They were able to publish and install their tenant-based app in sandbox environment but having issues while publishing and installing same app to Production environment using Upload Extension action.

I will write a separate blog about those issues.

Once again Thank you Anil (CEO, Cloudfronts) for contacting me and arranging the session.

Thank you Mahima (HR, Cloudfronts) for taking time to meet me on Holiday. It was nice meeting you.

Thank you NAV team, Cloudfronts
Olister Rumao, Chris D'silva, Me, Amol Bhad, Sunil Dhing and Anil Shah.

Do you want to learn about Dynamics 365 Business Central or having any issues? Please don’t hesitate to contact me at

I am also presenting a session at Hyderabad, Microsoft India office regarding Dynamics 365 Business Central on May 6th. Please register here.

Friday, 27 April 2018

Dynamics 365 Business Central Event in Hyderabad, Microsoft India

I am happy to announce that I am conducting an event on Microsoft Dynamics 365 Business Central in Hyderabad, Microsoft India office on May 6th from 11 AM to 12 PM.

The event will be totally free and targeted for NAV community.

It is all about Dynamics 365 Business Central.

If you would like to take part in Dynamics 365 Business Central event, please fill in your details in the form below and you will be automatically registered.

NOTE: If you want to know more about Dynamics 365 Business Central in your location/office then please contact me at

Wednesday, 18 April 2018

Tuesday, 13 March 2018

Upgrade Steps from NAV 2017 CU4 to NAV 2018 CU2

Upgraded one of our customers from NAV2017 CU4 to NAV2018 CU2.
Steps are:

1.     Take backup of your NAV2017 CU4 database from SQL
2.     Upload Partner License and restart service
3.     Open Extension management page in NAV2017
Uninstall standard extensions

4.     Run this command to unpublish from powershell (example)
Unpublish-NAVApp -Name "Sales and Inventory Forecast" -ServerInstance dynamicsnav110
5.     Delete records of Debugger breakpoint table from database using SSMS
6.     Stop NAV2017 CU4 service
7.     Open current NAV 2017 CU4 database in NAV 2018 CU2 environment and do the convert.
8.     Delete all objects except Tables.

NOTE: I have created all fob of NAV2018 with customizations before.

I have manually merged customizations as there are only less than 20 objects modified.
You can use power shell merge commands if there are lot of customized objects.

9.     Import all objects fob file with Replace all option from Import Work Sheet. (With Later Option in Synchronize Schema)
10.Import Upgrade toolkit fob (With Later Option in Synchronize Schema)

11.Start NAV 2018 CU2 service
12.Sync-NAVTenant in Powershell
13.Compile all objects with Validation
14.Run data upgrade from Tools->Data UpgradeàStart (you can do it from Power shell also)
15.Following objects, you have to delete from converted database.
Pending Company Rename
Change Global Dimensions
Office No Company Dlg
Assisted Setup Part
Extension Marketplace
Sales Cycle Stages List
Data Source List Part
New Page Patterns List Part

16.Delete Upgrade related objects. (Version List UPG*)
Only Publish below app, don’t install
17.Publish extensions from NAV2018CU2 DVD and install if required
Publish-NAVApp -Path "C:\Install\Dynamics NAV\NAV2018CU2\Extensions\SalesAndInventoryForecast\SalesAndInventoryForecast.navx" -ServerInstance dynamicsnav110

18.Upload Customer license and restart service

Friday, 16 February 2018

February Preview - Whats New

Here is the one of the new things of February preview of extensions 2.0

If you have any issues in object/file then then it will show in red color with no. of issues in it.

Thank you, Microsoft.

Tuesday, 9 January 2018

Dynamics NAV 2013 and Dynamics NAV 2013 R2 end of mainstream support

Mainstream support for Dynamics NAV 2013 and Dynamics NAV 2013 R2 ended today. Microsoft recommends customers using this version to upgrade to a newer version of Dynamics NAV in order to ensure supportability.
Customers who are currently on a service plan can continue to access the following benefits through CustomerSource:
  • Previously released Upgrades, Updates, Service Packs, Fixes and Regulatory/Tax Updates
  • Self-Help Support through Knowledge Base articles and online content
  • Unlimited Online Training