Inventory valuation after converting to 3.7

JBeck

Hi,

I've converted from 2.6 to 3.7 . When I run my Inventory valuation report the outcome of 2.6 and 3.7 are different. I've done some research and found out that table "value entry" did not exist in 2.6 which means that all my data on inventory valuation before the conversion does not exist in 3.7 .
What can I do to get the data?

Thanks in advance,
JBeck

Alex_Chow

They way Navision keeps track of costing is different from 2.x to 3.x. Basically, all the costing information is stored in the value entry table.

This way, you'll be able to backdate inventory valuation as well as do detailed costing analysis.

lubost

We also found this difference and our decision was to don't migrate the table 32 (as is), but transfer living items (items on stock) into item journal as type purchase or positive adjustment with the right prices and then post the journal.

kine

Main rule is to run adjust batches before upgrade on old version and after upgrade on new version. Do not forget this... (you need to upgrade fully adjusted database)

Alex_Chow

kine wrote:

Main rule is to run adjust batches before upgrade on old version and after upgrade on new version. Do not forget this... (you need to upgrade fully adjusted database)

You mean to follow the instructions on the upgrade toolkit to the dot?