Easy Field Changer

Administrator

Easy Field Changer
Easy way to change and/or validate field data in any table, without need to write codeunits, reports, etc.
You can change field or just validate it. Also you can set filters to the used table.

http://www.mibuso.com/dlinfo.asp?FileID=900

Discuss this download here.

ara3n

I hope this does not fall into any client hands.

ajhvdb

What does the "do not change" do?

roko

ajhvdb wrote:

What does the "do not change" do?

It just validates the field, without changing it.

ajhvdb

:-k Could you give an example of this "do not change" in which situation you would use it?

ara3n

on sales order you can hit f2 on "Sell-to customer No." and it will validate the record. recreate the lines etc etc.

People usually do it on sales Line "No." field to update the line to get the correct price etc etc.

roko

ara3n wrote:

on sales order you can hit f2 on "Sell-to customer No." and it will validate the record. recreate the lines etc etc.

People usually do it on sales Line "No." field to update the line to get the correct price etc etc.

Exactly

ajhvdb

Thx

Savatage

Mine crashes while compiling

FieldFrm@1103100009 : Form 7702;

What's form 7702?

ara3n

It's a form that displays the field table.

DeKirsten

I was considering building a tool like this myself, but i thought i should check MiBuSo first. And indeed, someone already did

It's a great tool.
As an in-house developer i get a lot of data change requests from end-users.

I did make a correction in your progress window though, for it has bad performance on big tables like item ledger entries.

So i changed this line:
RecCount := RecRef.COUNT;

into:
RecCount := RecRef.COUNTAPPROX;

and this line:
Window.UPDATE(1, ROUND(ProcessedRecords/RecCount*10000,1));

into:
IF (ProcessedRecords MOD 100) = 1 THEN
Window.UPDATE(1, ROUND(ProcessedRecords/RecCount*10000,1));

It saves performance!

Bilal

Hi,

Am having problems with this object. When i compile it or run it i get the error ''TableData 370 does not exist''. I need this inorder to save time attending to client requests. Can someone help me please?

kapamarou

Which Version of Navision do you use? Does your database contain table 370 Excel Buffer??

Bilal

Am using Navision.Incadea version 3.70.B. My Database does not contain ''table 370 Excel Buffer''
Will this tool work with my version and without table 370? Do you need a developers license to use this tool?
Please help and thank you.

kapamarou

This object uses table 370 as source table.

You can:

a) see if you have Escel Buffer table with a different ID and set the source table to that

or

b) find this table from standard Navision and see if you can import it and if you have a license to use it.

Bilal

Thank you kapamarou. However, I dont have that table even in another ID. I will try check in Standard Navision but it will be hard for me to get a copy of Naivision Standard especially where I am. How else can i get it? Thank you.

kapamarou

Bilal wrote:

it will be hard for me to get a copy of Naivision Standard especially where I am

I hope you mean you are on a sunny beach enjoying some vacation...???


You'll need to find the Client installation CD that contains the All-Famous CRONUS Database. In there you will find that missing object.

I think it's missing because most probably your version of incadea is based on an older version of Nav.

Bilal

Lol! You have a very good sense of humour! I wish i was in a Sunny Beach in Mombasa but rather am in a very sunny, dry worst part of Africa, Olduvai Gorge East Africa! Slow Internet speeds, flies, all types of insects etc. Anyways i will struggle to get the object.Thank you for all you help!