Important DataTypeArray in AL visual studio code for Dynamics 365 Business Central

Dear Readers ,

This blog will tell you about new datatypes available in AL language for MS Dynamics 365 business Central.

Arrays :

Arrays are complex variables that contain a group of variables, with the same data type. An array is declared as a variable with:

• An identifier
• A data type
• Elements
• An index
• A dimension

An array holds multiple values, and these values are stored in the elements of an array. You can access these values by using the index. The index can also be a value stored in another variable. With this you can create a loop where you increment a certain variable, to loop trough every element in an array.

By using the dimension property, you can define how many dimensions your array will hold.

One-dimensional and multi-dimensional array

When creating a variable of the array data type, you must define upfront how many elements you will have in your array. The most used is the one-dimensional array. This is just a list of elements with the same data type.

We can represent an array as a row of values:

To create an array, we can use the following code:

To access an element in an array you will need to use the array element syntax:

In the example above, SaleAmount is our identifier, and we are accessing the fifth element in the array. We are setting the value 0 in the fifth element. This would result in:

Because there is only one element between the square brackets, this indicates that we are using a one-dimensional array. If we want to have a multi-dimensional array, you would use a comma separated list between the brackets.

A multi-dimensional array can be represented as a table of values:

To create an array, we can use the following code:

To create an array, we can use the following code:

To access an element in an array, you will need to use the array element syntax:

In the example above, we are accessing the fifth row and the third column in the array. We are setting the value 0. This would result in:

How to Start customising AL Extension for Dynamics 365 business central?

Dear Readers ,

This post is related with my AL development. Lets start to dive in Business Central to get a real idea.

Step 1. Open Visual Studio Code and Goto View-Command Pallette.

1. Select AL:GO
2. Type the project Name : Social Media
3. Change the Launch.json  file as shown in screen if you are using windows Authentication.

4. Download the Symbol from View and Command Pallete by typing AL:Download Symbol

5.Once your Symbols are downloaded you can start with real development.

6. Delete Hello World.AL file and create 1 folder with name  Tables to put all tables and create 1 file in it with name SocialMediaExtension.al as shown in screen.

How to Extend existing tables via AL Code in Visual Studio?

1. Type ttable to use code snippet. And change the file as shown in screenshot.

2. Create one more folder Page and Add one more file for SocialMediaCard.al Pages. Publish the Extension to view your ready Extension. If you need some guidance to Publish the extension you can follow my last point of blog LINK.

3. After the Publish you can check your Extension Management Page.

4. Install the Extension and check your Customer Card PAge with new fields where you can enter records for your cutomers.

I hope this blog will help to understand AL Extension and coding link with your projects.

API communication in MS Dynamics NAV 2018 Now Business Central.

Hi All ,

Once again I am getting stuck with calling of API in MS Dynamics NAV in my Germany office so I

thought why not get a dive into the sea of API. And lets check what it is in reality.

What is an API ?

Google says API is an Application Programming Interface. A way which provides us a facility to get 

data from another server.

But I cant understand now also. So lets get some diagrammatic view of an API.

I have a requirement from customer whenever a payment is done by a customer we need to check 

whether the customer has a credit balance to buy the article if no then send the notification to 

customer please contact the owner to increase your credit balance.

So here we were suggested to come with a solution of API we need to create one API which will be 

used by Paypal developers to checks whether this transaction is allowed or not.

I hope you got the point that what is an API.

API is generally a program written to say outer world that we will give you your data just send me 

the url for this requirement. In our example , my developed API will take the parameter of customer 

No. and will check in our customer table below points :

1. Customer Exist or Not.

2. If Exist , check the credit balance and proceed.

I hope concept is clear and requirement is also clear.

So what NAV developers will do now , we will create codeunit and will check the conditions and 

expose it to web service. But now we want to interpret with Paypal and they suggested API.

How to use API in NAV 2018?

First we will see how we can use then we will create API also.

Requirement from NAV Side :

1. Enable your NAV 2018 Admin for Soap and Odata Url.

If you want to go in more deep about API follow this video.

2. Search for API Setup page. Open it and click on Integrate API function it will populate all API present in NAV in Table API Web Service.  This is new system table.

3. We can check the data in Page but we need to create one page for this , as I had created this page on table API Web Service.

Please check how to create page on this table if you dont know in NAV from MSDN.

Lets Run this page.

You can create a web service for this page and check the data for this on browser.

The result of the data will be in JSON Format.

These are the following APIs provided by NAV 2018.

How to call API of NAV?

This is the URL provided by MSDN:

 http://<<Server Name>>:<<OData Port>>/<<Service Name>>/api/beta

For me its :

http://localhost:7048/DynamicsNAV110/api/beta

Hint : If you are not familiar with the url just open web service page and click on URL fields. There are 3 fields

ODATA V4 URL

ODATA URL

SOAP URL

With this you will get the desired URL for your system I followed the same.

After some time the result is as in Screen.

Now if its an API URL it should be present in POSTMAN. Lets check there also the result of our API  data is it available to other world.

For this I will write a new POST.

But I get 1 point now Microsoft is going to Business Central to a next Level of Data Library.

How To Setup VAT Value Added Tax in MS Dynamics NAV 2017 ?

Dear All,

As we Know GCC countries are soon going to implement VAT Taxation System in their countries so

I just want to share some important steps for you all.

This is a summarised step and I hope it will help you out all for successful implementation and

upgrade your system to access VAT in MS Dynamics NAV 2017.

What is VAT Value Added TAX?

The Esteem Included Expense, or VAT, in the European Union is a general, comprehensively 

construct utilization impose surveyed with respect to the esteem added to merchandise and ventures.

 It applies pretty much to all products and enterprises that are purchased and sold for utilize or 

utilization in the European Union. Subsequently, merchandise which are sold for fare or 

administrations which are sold to clients abroad are regularly not subject to VAT. Then again imports 

are saddled to keep the framework reasonable for EU makers so they can contend on square with 

terms on the European market with providers arranged outside the Union. 

Esteem included duty is 

a general duty that applies, on a fundamental level, to all business exercises including the generation 

and dissemination of products and the arrangement of administrations. Be that as it may, if the yearly 

turnover of this individual is not as much as a specific point of confinement (the limit), which 

contrasts as per the Part Express, the individual does not need to charge VAT on their deals.

How to Setup VAT in MS Dynamics NAV 2017 ?

Step 1.

Create a new vendor.

Define gen. bus. posting group, VAT BUSINESS Posting Groups For Customer And Vendor

and Vendor Posting Group.

Step 2.

Create an item,Gen. Product Posting Group,Vat Product Posting Group,Inventory Posting Group.

Step 3.

Create Purchase Invoice and now Setup VAT Posting Setup,

Create new Code and define VAT & Percentage define Accounts also for sales and purchase.

Step 4.

Create a customer and define

Gen. Bus Posting Grp

VAT Bus. Posting Grp

Customer Posting Group

 Step 5.

Create a sales Invoice and post the invoice.

Step 6.

Check for VAT Entries.

Step 7.

Now check for Reporting VAT

You have to search for VAT Statement in search bar.

Create a new statement

EDIIT VAT Statement

Row No.

Setup For Sales And Purchase VAT Statement here

Now run this batch report to settle VAT amount in Chart of Accounts.

Report Name

Calc. and Post VAT Settlement

No Start Date

Enter Ending Date

Posting Date

Provide a document No.

Provide a Settlement No.

Run this report.

Step 8.

Check VAT Entries.

Some imporant points Summary Post 2 Tables from

Hi,

You can have a look for Tables in MS Dynamics NAV from the below link. I am summarising the

concept below. If you like then do comment and subscribe to my blog post.

Tables by microsoft.

Note 1.

RECORDID Datatype :- It Stores RECORD ID and Primary key values.

Note 2.

ExtendedDataType property

When you select the Phone No. field without closing the No. -

Property window, notice that now the Phone No. – Property window is shown.

By selecting a value in the ExtendedDataType property, you will change the layout

and behavior of controls on a page. Use the value to add an icon next to an input

field to indicate whether the field relates to a phone number, email address, or URL.

Note 3.

Why we use Field Groups in Navision?

Note: If you do not define any Field Groups for the drop-down control, by

default, you will only see data from two fields in the source table: the primary key

and description fields, because these are indexed automatically.

Note 4.

Up to 40 keys can be associated to a table, and the first on the list is the primary

key. All other keys are secondary keys and optional.

The primary key is composed of up to 20 fields in a record. The combination of

values in fields in the primary key makes it possible for Microsoft SQL Server to

perform a unique identification of each record. The primary key determines the

logical order in which records are stored, regardless of their physical placement on

a disk.

Secondary keys are used to view records in an order that differs from the one in

which they are sorted, according to the primary key fields.

Note 5.

Note: The field ID that is specified in the TableRelation property must be in

the primary key of the table that is specified by the table ID in the property. If the

specified field is not the first field in the primary key, the other fields that are listed

before it in the key must be filtered to one value.

Note 6.

7 types of flowfields Sum, Average,Lookup,Exist,Min, Max,Count

Note 7.

SumIndexFields

A SumIndexField is a decimal field that can be attached to a key definition. This is

the fundamental feature of the Microsoft Dynamics NAV that constructs the basis

for FlowFields. SumIndexFields enable fast calculation of numeric columns in

tables,

Note 8.
Each key can have at most 20 SumIndexFields. During database design, a decimal field can

be associated with a key as a SumIndexField.

The type of SumIndexField must be numeric (Decimal, BigInteger, Integer or Duration).