INVENTORY VALUATION REPORT NOT AGREEING WITH ITEM CARD

Hello,

I have a situation where the sum of an items increases less its decreases result in a remaining balance not equal to that on the item card. Can you explain whether this can happen through normal use of Navision and how I can resolve.

Thanks

Any filters on the report?

Any filters on the item card?

Hi

First of all version are you using ?

Are you talking quantity or value ?

If quantity check filters as Adam says.

If value then check that you have run the cost update routines and are you using expected cost posting for item received but not invoiced.

No filters set on either card or report ?.

V4 SP3.

I am talking quantity.

No filters set.

Thanks

I have only ever seen the quantity differ in this manner previously where an end user deleted records they did not want to see directly from the SQL tables, or had a modification.

What you need to do is pick an item with a difference that does not have too many transactions. Then filter the itme card for set dates, then run the report for the same filters. Eventually you will get down to a period where there are differences, then reference the value entry records to the item ledger records to try and discover what record/records are missing and why.