Removing Item tracking on products

Alveus

Hi all!

Is there anyone who knows how to remove item tracking on items? You could add the items again without tracking but that would delete important statistical data. Is there any other way?

Regards

Alveus

ecclectic

std navision no, u could always do it by sql

Alveus

ecclectic wrote:

std navision no, u could always do it by sql

Ok thanks,

Do you have any tips on where to start? Do i need a script that removes the entries from the database?

ecclectic

tables item, reservation entry for sure there are couple of tables as well

nunomaia

there is 2 aways.

1 - Clean Way

Using inventory journal, put to zero the item.
Rename the item
Create a new Item with old code
Using inventory journal, increase new item (attention to cost)

2 – Delete tracking entries. You follow this way, you must know what you are doing because the several tables to change / delete (tracking from orders, shipments, several ledger entries, etc),

Alveus

but when i change the name of the item it makes the transactions and enter the new id on all transactions. is there a way to keep the statistical data?

nunomaia

The same item code having item tracking posted entries and not having?

Alveus

Yes, i need to keep the item transactions but just remowe item tracking on the item.

thanks

Alveus

So I reckon SQL is the only way to do it?

nunomaia

No,

1 – Create a backup.
2 – Create a codeunit to remove item tracking entries from all related tables.

keep away from using direct SQL, it’s dangerous.

If you need further assistance to know witch tables you must do the modifications. I can help you.

nunomaia

What is your current NavisionVersion?

Warehouse functionalities that you have?
Do you have manufacturing?

Alveus

I use Navision 3.70.

Yes I am using manufacturing.

I am not using warehouse management, pretty much standard inventory usage.

Kind regards

nunomaia

If I'm not missing any table, and based in your current setup.

You need to delete or change the following tables.

Item Ledger Entries
Value Entry Relation
Reservation Entry
Item Entry Relation

There are other related tables but they are only used in warehouse functionality.

nunomaia

You must be careful. You must know what you are doing.

David_Singleton

nunomaia wrote:

If I'm not missing any table, and based in your current setup.

You need to delete or change the following tables.

Item Ledger Entries
Value Entry Relation
Reservation Entry

There are other related tables but they are only used in warehouse functionality.

Please don't do this unless you really know what you are doing.
[-o<

nunomaia

Yes David Singleton, it's a dangerous process, it can corrupt the database and it’s an irreversible method.

Forgot to mention: Pay attention if you have the costing method “Specific”