Pages

Tuesday, June 21, 2016

How You Can Take Input From End User In Codeunit Object

How You Can Take Input From End User In Codeunit Object

Hi all,
Today i came across with different type of requirement, where someone asking for how could we input from codeunit.
This example illustrates how you can take input from end user in Codeunit Object.
And update the excel sheet from inputted data, using dotnet variables.
To achieve these requirement follow these steps:

Step 1:  Create a new codeunit.
Step 2:  Create function "CreatePopOfWindow" and  "UpdateExcelData" See the bellow screenshot].







Excel Function:



Excel Variable:




Step 3:  Save, Compile and run the newly created codeunit, See the bellow screenshot].




Scenario - 1:




Scenario - 2:







Click Here for download Object.
Note: 
    It might be changed the version of variables, so better to Re-define/declare the DotNet variables.




Tuesday, June 14, 2016

How to: Implement Location in C/AL NAV 2016

How to: Implement Location in C/AL NAV 2016
This example illustrates how you can retrieve location information. The example implements a GetLocation action on the Customer Card (page 21) that returns the GPS coordinates of the current customers address. It does not save this information to the database. Scenarios in which this functionality could be useful would be displaying a map that shows where your customer is located based on the GPS coordinates. Or, functionality to plan the next round of customer visits based on the addresses of your customers.
Important
The location information is only available on devices that run the Microsoft Dynamics NAV Universal App and have GPS capabilities. This means that location information is not available from the Microsoft Dynamics NAV Windows client or from a browser.
To implement location in C/AL
  1. In the development environment, on the Tools menu, choose Object Designer to open the Object Designer window.
  2. In Object Designer, choose Pages, select the Customer Card (page 21) and then choose the Design button.
  3. From the Page Designer window, on the View menu, choose C/AL Globals.
  4. Create the following variable:
Variable name
DataType
SubType
Location
DotNet
Microsoft.Dynamics.Nav.Client.Capabilities.LocationProvider
Important
Choose the Microsoft.Dynamics.Nav.ClientExtensions dll on the Server tab, and then choose Microsoft.Dynamics.Nav.Client.Capabilities.LocationProvider
Make sure to set the properties RunOnClient and WithEvents to Yes.
LocationAvailable
Boolean
  1. On the View menu, select C/AL Code and in the C/AL Editor locate the OnOpenPage trigger.
  2. Instantiate the Location variable by adding the following code to the OnOpenPage trigger.

Copy Code
IF Location.IsAvailable THEN
BEGIN
  Location := Location.Create;
  LocationAvailable := TRUE;
END;
             
           See the bellow screenshot of OnOpenPage Trigger



  1. Next, create the page action. Choose the View menu, and then select Page Actions. 
  1. Locate the ActionGroup named Customer and create a new action; GetLocation with the following properties.
Property
Value
Name
GetLocation
Visible
LocationAvailable
Promoted
Yes
PromotedCategory
Process
PromotedIsBig
Yes

           See the bellow screenshot of GetLocation action Trigger




  1. Now, in the C/AL Editor, on the GetLocation - OnAction trigger, insert the following line of code.
 Copy Code
Location.RequestLocationAsync;

        See the bellow screenshot of GetLocation - OnAction Trigger



  1. While still in the C/AL Editor, on the LocationChanged trigger add the following code to handle the GPS coordinates. LocationChanged is called when the device has obtained a status.

Copy Code
Location::LocationChanged(Location : DotNet "Microsoft.Dynamics.Nav.Client.Capabilities.Location")
IF(Location.Status = 0) THEN
  MESSAGE('Your position: %1 %2',
  Location.Coordinate.Latitude,Location.Coordinate.Longitude)                               
ELSE
  MESSAGE('Position not available');
Important
Location.Status can be 0 = Available, 1 = NoData (no data could be obtained), 2 = TimedOut (location information not obtained in due time), or 3 = NotAvailable (for example user denied app access to location).

           See the bellow screenshot of Location::LocationChanged Trigger


  1. Close the C/AL Editor, and then save and compile the page.
  2. You can now test the modified Customer Card page in the Microsoft Dynamics NAV Universal App from either a tablet or a phone with GPS capabilities.


LocationOptions Overview

Microsoft Dynamics NAV 2016

When implementing location from C/AL, there are some options that you can optionally pass toLocationProvider.RequestLocationAsync(options)
The options can be accessed by usingMicrosoft.Dynamics.Nav.Client.Capabilities.LocationOptions found in the Microsoft.Dynamics.Nav.ClientExtensionsdll.
For most scenarios it is not necessary to specify options.

Location Options List

bool EnableHighAccuracy
A value to provide a hint to the device that this request must have the best possible location accuracy.
int Timeout
The maximum length of time (milliseconds) that is allowed to pass to a location request.
int MaximumAge
The maximum length of time (milliseconds) of a cached location.



References:   MSDN