Removing Item tracking on products

Alveus
Alveus Member Posts: 44
edited 2007-03-05 in NAV/Navision Classic Client
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

Comments

  • ecclectic
    ecclectic Member Posts: 176
    std navision no, u could always do it by sql
  • Alveus
    Alveus Member Posts: 44
    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
    ecclectic Member Posts: 176
    tables item, reservation entry for sure there are couple of tables as well
  • nunomaia
    nunomaia Member Posts: 1,153
    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),
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Alveus
    Alveus Member Posts: 44
    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
    nunomaia Member Posts: 1,153
    The same item code having item tracking posted entries and not having?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Alveus
    Alveus Member Posts: 44
    Yes, i need to keep the item transactions but just remowe item tracking on the item.

    thanks
  • Alveus
    Alveus Member Posts: 44
    So I reckon SQL is the only way to do it? :)
  • nunomaia
    nunomaia Member Posts: 1,153
    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.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • nunomaia
    nunomaia Member Posts: 1,153
    What is your current NavisionVersion?

    Warehouse functionalities that you have?
    Do you have manufacturing?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Alveus
    Alveus Member Posts: 44
    I use Navision 3.70.

    Yes I am using manufacturing.

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

    Kind regards
  • nunomaia
    nunomaia Member Posts: 1,153
    edited 2007-03-12
    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.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • nunomaia
    nunomaia Member Posts: 1,153
    You must be careful. You must know what you are doing.

    :wink:
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • David_Singleton
    David_Singleton Member Posts: 5,479
    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<
    David Singleton
  • nunomaia
    nunomaia Member Posts: 1,153
    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”
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/

Categories