Item Inventory

navuser1
navuser1 Member Posts: 1,334
edited 2008-04-08 in NAV/Navision Classic Client
I have deleted all the data from Item Ledger Entry Table but Item shows the Inventory quantity
greater zero.

How can it be possible?
Now or Never

Comments

  • JedrzejT
    JedrzejT Member Posts: 267
    Hi,

    There is no possibility to item show "inventory" when item ledger entry is empty.
    Maybe you don't delete all data (some filters) or you have some modifica tion with field inventory or "inventory quantity" which you see is not field inventory.

    Regards
  • navuser1
    navuser1 Member Posts: 1,334
    There is no ILE Entry.I have deleted all the entris.
    But Inventory shows >0.
    Now or Never
  • JedrzejT
    JedrzejT Member Posts: 267
    You can run full test on this two table and check for problem with SumIndexField Sum. I have it once on older version but this is small possibility.
    You have no modification? SQL or native?
  • navuser1
    navuser1 Member Posts: 1,334
    I am working on Navision 3.7 version.
    Server is SQL Server
    Now or Never
  • DenSter
    DenSter Member Posts: 8,307
    Did you also delete everything out of the Value Entry table? What happens when you drill down into the inventory on the Item Card?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • cernst
    cernst Member Posts: 280
    It isn't a live database is it? Why do you want to delete the item ledger entries?
    If you do delete all entries then it is very important that you delete all other related tables. For example value entries, item application entries, reservation entries etc. If you don't you'll be in trouble later.
    _____________________
    NAV Freelance Consultant
  • navuser1
    navuser1 Member Posts: 1,334
    I have truncated all The related tables like -ILE Table,
    Value Entry Table, Reservayion Table,But Item Card
    Shows the Inventory greater than Zero.
    Now or Never
  • navuser1
    navuser1 Member Posts: 1,334
    When I modify the Inventory with zero It creates
    a ILE Entry with the Item Card shown quantity not
    zero.
    Now or Never
  • navuser1
    navuser1 Member Posts: 1,334
    _________________
    KriKi

    Did you also delete everything out of the Value Entry table? What happens when you drill down into the inventory on the Item Card?
    _________________


    It shows no ILE ENTRY.
    Now or Never
  • navuser1
    navuser1 Member Posts: 1,334
    Same Problem is in Chart Of Account Form after deleting data from GL Entry and GL Register table.
    Now or Never
  • kine
    kine Member Posts: 12,562
    1) How did you delete the tables?
    2) If you are using SQL, it seems like some problems with SIFT...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • navuser1
    navuser1 Member Posts: 1,334
    Yes,
    I Use SQl command to delete all Table data.
    Now or Never
  • JedrzejT
    JedrzejT Member Posts: 267
    Not good. Try to Never modify data in tables by other tools than navision if you don't know influence on whole database.
    Its simple to delete data by CU..

    Now.. You just have to delete all SiftIndexKey [by navision] in all keys of tables which You delete date. Then save tables. Then Add the same SiftIndexKey which you delete and save again. SIFT tables will recreate, and You have good resoults for invenory. Maybe simple case work.. [disable,save,enable,save] check on column - "maintain sift index" - in every key in tables. I don't test it.

    Regards
  • ara3n
    ara3n Member Posts: 9,258
    How did you delete the entries? through sql or through Navision, if you have deleted them through sql, the sift table are still there.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • navuser1
    navuser1 Member Posts: 1,334
    Thank you All,
    I have solve the problem.
    Now or Never

Categories