Tuesday, October 13, 2015

Simple Tool to clear the data from the field in Navision

tool-78016_1280

It is quite often during the implementation or re-implementation projects that there is a need to change a field data type or delete the field after it was added. The issue is if that field has the data, then in order to change the data type or to delete the field we have to clear the field value otherwise you will get the error. Below is an example of such error

image

If you have multiple companies in the database then you to have to clear the data in all the companies before you make the change, normally I create a process report to clear the data and run that in each company but it is a tedious task if you have many companies. I have come across this situation many times, so I have created a simple tool called Clear Fields, this is a process report with option to filter on the table and the field you want to clear, it also has the option to clear the data in all the companies, so you don’t have to change company and run this in each company.

image

As of now this is only designed to clear one field at a time and it handles any field type, in the future I plan to extend this and add more options to it. I have uploaded the .fob and .txt objects in the below location, it also has a word document which will explain the above the request page options

Download Objects: http://1drv.ms/1Mwrzum

Please leave your comments, feedback or any suggestions you have for me to improve me my blog and also if you have any questions, feel free to post..

Share:

7 comments:

TomHedegaard_DK said...

Why not use the new UpgradeCodeunits to clear fields and such ?
It will then automatically be executed for all Companies.

Just a suggestion :)

Suresh Kulla said...

Thank you for the suggestion, similar comment was made one of my colleague earlier, i have not used those CU's earlier, i have to check them to see if they can be used for this purpose. I will look into it.

Thank you
Suresh

Eminent It Info said...

I have read your blog its very attractive and impressive. I like it your blog.
Power BI training in marathahalli bangalore

Praylin S said...

Remarkable post! I really liked the reading experience. Do share more such posts. Keep us updated.
Ionic Training in Chennai
Ionic Course in Chennai
Spark Training in Chennai
Spark Training Academy Chennai
Embedded System Course Chennai
Embedded Training in Chennai
Ionic Training in Tambaram
Ionic Training in Velachery

Joe said...

Extra-Ordinary piece of work. Interesting concepts to read. Very much informative. Thanks for sharing. Waiting for your future posts.
Tableau Training in Chennai
Tableau Course in Chennai
Tableau Training
Primavera Training in Chennai
Primavera Course in Chennai
Node JS Training in Chennai
Node JS Course in Chennai

Mariam Ahmed said...

Very useful information, Keep posting more blog likes this, Thank you.
Aviation Academy in Chennai
Air hostess training in Chennai
Airport management courses in Chennai
Ground staff training in Chennai
Aviation Courses in Chennai
cabin crew training institute in Chennai
airlines training Chennai
Ground staff training in Chennai

nadiya said...

Very informative blog. Got more information about this technology.
Ionic Training in Chennai
Ionic Training Institute in Chennai
pearson vue test center in chennai
IoT Training in Chennai
Xamarin Training in Chennai
Node JS Training in Chennai
Ionic Training in Anna Nagar
Ionic Training in T Nagar