Tuesday, October 13, 2015

Simple Tool to clear the data from the field in Navision


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


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.


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..



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

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

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

Website said...

Nice little tool. Thanks for reviewing!

tradeimexinfo said...

I read your post and this blog is very good. You have provided good knowledge in this blog. This blog really impressed me. Thank you for sharing your knowledge with all of us. singapore import data