How to convert date time to date in Microsoft Dynamics Navision.

We use FORMAT function for convert any date format Ex. FORMAT("Bank Account Ledger Entry”. “Posting Date",0,' <Day,...

How to put drop down list in report request page in Microsoft DynamicsNavision.

First we create the report which is display the drop down list of the vendor, so user can select vendor and     generate report and ap...

The .NET Framework object Microsoft.Office.Interop.Excel.ApplicationClass cannot run on this client.

Try to set ServicePrincipalNameRequired  =TRUE in ClientUserSettings file for this user GO  TO path : "C:\Users\xxxxx\AppData\Roamin...

How to find value from table in Microsoft Dynamics Navision

For   getting the specific value from the table based on some condition, we use setrange and find function, for example we have to ...

The value of DELSTR parameter 2 is outside of the permitted range. The current value is: -2147483648. The permitted range is: from 1 to 1024.

This problem is generating when you use format address code unit function. So if you use. FormatAddr.Company(CompanyAddr,CompInfo); ...

The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.

Go to list and right click on its row and go to Row Group >> Row properties as show in image it will open new window.   ...

How to convert amount in words in Microsoft Dynamics Navision.

For converting the valid numeric value to words, follow below process. -Create new codeUnit and define two variable as shown below. ...

Extra row problem in table in Microsoft Dynamics Navision report.

In Navision report we you use table control with grouping then it will create problem some time, its display some extra row with blan...

How to select behind control in sql report builder

In SQL report builder there is no an type of facility for select the any report control from properties drop down list because in SQL Repo...

How to add new instance in Microsoft dynamics Navision Administration.

For adding the new instance in NAV server follow below steps. a. Open the Microsoft Dynamics NAV administration server b. Cl...

How to create simple report in Microsoft Dynamics Navision.

Report is one type of data representation in NAV , report is use to display data from the database to outside user. Here we make simpl...