Adjust Cost and SQL server database

emabare

I have a customer with Navision 3.60 HotFix 38.

Running adjust cost procedure we have wrong value entries (in particular the procedure sometimes create two value entries instead of one and the second one have amounts multiplied for two).

The strange thing is that the error doesn't happen if I run adjust cost under navision database. :-s

Tests was made with two restore (one SQL and one Navision) of one single backup.

I'm thinking about sorting problems with SQL in Codeunit 5895 (in my case with version list NAVW13.60.00.38), but I have not found solution...



Emanuele

kine

it can be problem of sorting or the problem about "ghost records" on MS SQL (that Navision does not see some records...). You can try the hack for that (setting diagnostic property in db_property table, search this forum for that)

emabare

Solved with the query

UPDATE [$ndo$dbproperty] SET diagnostics = 131072

thank's a lot!
Emanuele

sgg

Could This Solution be applied to the problem of Inventory Valuation Report not reconcilling with the G/L?

Where Costing Method = Average and Database is 3.60A US on SQL ?