Thursday, October 25, 2018

GOTO Focus EMEA 2018

Dive in Deep. Emerge an Expert.

Event Highlights
  • Content presented by MVPs and the best Subject Matter Experts in the market
  • Small class sizes encourage and provide the opportunity to ask questions
  • Strategic networking times to further engage and connect with peers and colleagues
EMEA 2018 Registration


Focus EMEA will take place in London 5-6 September, and Copenhagen 13-14 September. Both locations will include sessions focused on Operations and Customer Engagement Apps. In addition, each location will feature content specific to the area's major industry.
Retail | London, 5-6 September
Transform the retail space and your customer experience. Attend sessions designed to inspire, create and deliver exceptional retail customer interactions.
Manufacturing | Copenhagen, 13-14 September 
Improve efficiencies in your manufacturing environment. Attend sessions designed to help you in the manufacturing space including master planning, inventory management and more. Register to attend in Copenhagen.
What are you waiting for? Roll up your sleeves to dive in deep and emerge a Microsoft Dynamics 365 expert. Register for Focus EMEA

Monday, October 1, 2018

How to install Dynamics 365 Business Central On Premises ?

Dear All ,

After so many news and go through Microsoft has released Business Central on Premises. So we can

go directly and download the product from Partner Source Login HERE.

Product is available in below versions :-

Product Downloads

Download the appropriate files below:
Microso​​ft Dynamics 365 Business Central on premises ​
​​Note: The download links below will be available on October 1, 2018.
​​Download AU-Australia
Download AT-Austria 
Download BE-Belgium 
Download CA-Canada 
Download CZ-Czech Republic  
Download DK-Denmark 
Download FI-Finland 
Download FR-France 
Download DE-Germany 
Download IS-Iceland 
Download IT-Italy 
Download MX-Mexico 
Download NL-Netherlands 
Download NZ-New Zealand 
Download NO-Norway 
Download ES-Spain 
Download SE-Sweden 
Download CH-Switzerland 
Download UK-United Kingdom 
Download US-United States 
Download NA-North America 
Download RU-Russia 
Download W1 

Thanks to all for your time.

Anyone not having Partner Source ID can go to Waldos blog on google and directly download.

Monday, September 3, 2018

How to call stored procedure from Dotnet Variable in NAV?

Process 1.

Add These Variables.

Name                 DataType                              Subtype Length

SQLConnection DotNet                              System.Data.SqlClient.SqlConnection.'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'

SQLCommand DotNet                              System.Data.SqlClient.SqlCommand.'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'

SqlParamCycleCode DotNet                      System.Data.SqlClient.SqlParameter.'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'

SQLDbType                 DotNet                      System.Data.DbType.'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'

CAL CODE :

SQLCommand := SQLCommand.SqlCommand();

SQLConnection := SQLConnection.SqlConnection();

SQLConnection := SQLConnection.SqlConnection('Server='+'172.16.18.158'+';'+ 'Database='+'DB NAME'+';'
+ 'Uid='+'userID'+';'
+ 'Pwd='+'Password'+';');

SQLConnection.Open;

SQLCommand.CommandText('Sp_UpdateWindowsAuthenticationFromNav');

SQLCommand.Connection := SQLConnection;

SqlParamCycleCode := SqlParamCycleCode.SqlParameter();

SqlParamCycleCode.ParameterName:='@EmployeeId';

SqlParamCycleCode.DbType := SQLDbType.String;

SqlParamCycleCode.Value:=Rec.U_ID;

SQLCommand.Parameters.Add(SqlParamCycleCode);

SQLCommand.ExecuteNonQueryAsync();

SQLConnection.Close;

CLEAR(SQLCommand);

CLEAR(SQLConnection);