Monday, 21 May 2018

Dynamics 365 Business Central Training Session in Ahmedabad

Another Dynamics 365 Business Central in-class training provided for Intech Systems, Ahmedabad on May 19, 2018.

They have a certified Dynamics NAV add-on and willing to create it as an app for Dynamics 365 Business Central Appsource.

They have all the required details and Visual Studio Code knowledge now and ready to create the app and submit to Microsoft.

Good Luck and hope to see your app soon in Appsource.

Thank you Nilesh Gajjar (Team Lead, Intech System) for initiating the discussion regarding training.

Thank you Anuja Parikh (President, Intech Systems) for approving for the training.
Hope to see you soon again.

Thank you, Intech Systems NAV team
Jignesh Dhandha, Nilesh Gajjar, AbhayKirshnan Pillai, Sweta Vyas, Vishnu Goyanka, Akshay Patel, Suraj Patel, Nishit Patel, Preet Gor, Murari Jangid

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.