Item Inventory

navuser1

I have deleted all the data from Item Ledger Entry Table but Item shows the Inventory quantity
greater zero.

How can it be possible?

JedrzejT

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

There is no ILE Entry.I have deleted all the entris.
But Inventory shows >0.

JedrzejT

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

I am working on Navision 3.7 version.
Server is SQL Server

DenSter

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

cernst

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.

navuser1

I have truncated all The related tables like -ILE Table,
Value Entry Table, Reservayion Table,But Item Card
Shows the Inventory greater than Zero.

navuser1

When I modify the Inventory with zero It creates
a ILE Entry with the Item Card shown quantity not
zero.

navuser1

_________________
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.

navuser1

Same Problem is in Chart Of Account Form after deleting data from GL Entry and GL Register table.

kine

1) How did you delete the tables?
2) If you are using SQL, it seems like some problems with SIFT...

navuser1

Yes,
I Use SQl command to delete all Table data.

JedrzejT

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

How did you delete the entries? through sql or through Navision, if you have deleted them through sql, the sift table are still there.

navuser1

Thank you All,
I have solve the problem.