How To make Field Editable on condition in MS Dynamics NAV 2016?

How To make and Field Editable on Boolean Condition?

In this blog post I am going to define and do an requiremnet for my client who needs to restrict the Field on boolean condition in Microsoft dynamics NAV 2017.

Applying conditions :-

basically these are the conditions which are used according to the requirement.

This is the Editable property on which you can set up the boolean field and it will only be editable when a user checks the Boolean field and tries to edit or enter something. Once you again untick the boolean field 

it will refreshes the field value.

To check you can refer these screen.

You can also refer to MSDN website here :-

MSDN Link

I hope I had Explained the steps clearly if you like the post and it helped you then please share our post and subscribe to our blog post.

Thanks.

How To save excel File in MS Dynamics NAV From Excel Buffer? Anand Blog

How To save excel File from Excel Buffer in Dynamics NAV 2016?

This article is about the steps required to save an excel which was generated from Excel Buffer in Microsoft Dynamics NAV 2016.

Step 1 . 

In this article I am taking my preferred Location To Save the Excel File the location is at a Setup table.So you have to create some new functions in your excel Buffer Table. Please see the reference screen.

Copy Paste the Standard Function :- 

Named CreatebookandOpenexcel and create a new Function SaveExcel

You can also copy paste the code

CreateBookAndSaveExcel(FileName : Text;SheetName : Text[250];ReportHeader : Text;CompanyName2 : Text;UserID2 : Text) CreateBook(FileName,SheetName); WriteSheet(ReportHeader,CompanyName2,UserID2); CloseBook; Saveexcelby;

THREE Fundamental Rules not to Ignore XMLport Properties.

Use of XMLPORT :-

An XML document is a well-structured hierarchy of nodes which at the same time contain the data, and also describe the nature of the data in the document.

What is XMLPORT?

Designing an XMLport is actually designing the structure of the external file, whether it is an XML document or a text file. This primarily involves setting various properties in the XMLport objects, such as XMLport properties and Node properties.

Working of XMLPORT :-

When an XMLport is used to import data, records that are read from the external file are inserted into the table that corresponds to the table node in the XMLport. You can examine the records before inserting them, specify whether records are inserted automatically, and decide whether records already in the database are overwritten or updated when a record with the same primary key is read from the external file. You can also determine to completely skip records from import.

Important Properties in NAV Xmlport

Node Properties for Import
When Node Type is set to Table, there are three more properties that specify the behavior of the XMLport during import operations: AutoSave, AutoUpdate, and AutoReplace.

AutoSave :- Specifies whether imported records are automatically written to the table. AutoUpdate :- Specifies whether a record in the database that has the same primary key as a record in the import file is updated with values from the imported record.Values of database fields that are not present in the import file will not be modified by the XMLport. AutoReplace :- Sets whether imported records automatically replace existing records with the same primary key.Values of database fields that are not present in the import file will be reset to their initial value,according to their InitValue property.

For More Information :-

MSDN Link

MSDN Link 2 
Complete Xmlport Description