Data Cleaning in 5

coder

Hello,

Where is data Cleaning in NAV 5?
Is there any other option available in NAV ?

Regards,
Rakesh

DaveT

Hi Rakesh,

Administration -> IT Administration -> Data Deletion

Is this what you are looking for?

nunomaia

I think you are referring to a codeunit that existed in NAV 4.X that allowed to clean historical entries to prepare a new company. That codeunit was removed in NAV 5.X.

DaveT

nunomaia wrote:

I think you are referring to a codeunit that existed in NAV 4.X that allowed to clean historical entries to prepare a new company. That codeunit was removed in NAV 5.X.

... if so then codeunit 8604 Data Cleaning is what you want - you will get this from the RIM toolset. N.B. be careful !

coder

Hi Dave and Nuno,

Thanks for the reply.

nunomaia wrote:

I think you are referring to a codeunit that existed in NAV 4.X that allowed to clean historical entries to prepare a new company. That codeunit was removed in NAV 5.X.

Yes, i am looking for the codeunit for data deletion from the posted table which are present in NAV 4.X databases.

DaveT wrote:

nunomaia wrote:

I think you are referring to a codeunit that existed in NAV 4.X that allowed to clean historical entries to prepare a new company. That codeunit was removed in NAV 5.X.

... if so then codeunit 8604 Data Cleaning is what you want - you will get this from the RIM toolset. N.B. be careful !

Actually the codeunit is 8604 data cleaning which is not present in NAV 5. However, i have managed the codeunit from NAV 4 database and apply it on NAV 5.

Regards,
Rakesh

rjverma

Hi Dave Treanor,

can be clean Nav4 database also ?, can you explain about Data Deletion in Nav4. Data can be delete from there or clean the junk data from there.

pls explain about Data Deletion.

thanks

Rupesh Verma
Kortek Electronics (I) Pvt. Ltd.

DaveT

Hi Rupesh,

Data deletion is a collect of object designed to help the user remove unwanted historical data. The most common example is then on sales orders, if you invoice by get shipment lines the original order is left. Some customer like this as an audit trail but the details are in the posted shipment and posted invoice. The idea is to enable the end-user (admin of course) to manage the build up of non-essential data.

On the other side the data cleaning codeunit is designed (although you need to modify for extra tables) to clear out test data when getting ready for an implementation. It is alway implied that this is tested throughly

Hope this makes it clearer

Kisu

Why it was removed in Nav 5.x?
Its there any new way to delete the test transactions exmple? ](*,)

DaveT

Hi Kisu,

The cleaning was only a small part of the RIM tool set. The data migration took over from the RIM tool so the cleaning "got Lost". It's a dangerous but powerful tool - be careful and loads of testing

Kisu

So after we get a new database tested with all customs and setups ready we create new company, use the company to company copy function in the setup check list and hope everything will work as new, then delete the test company? :-k :?:

Would be just simple to have that tool to remove the transactions and such and leave the clean setup in the tables blah

DaveT

Hi Kisu,

I agree, that's why I know where the codeunit is

Kisu

DaveT wrote:

Hi Kisu,

I agree, that's why I know where the codeunit is

You mean the cu8604?

If so which tables should I add for it so it would clean the nav 5 properly. If I read correct something was missing from manufacturing and production that is not listed. Any thing else. :shock: