Hot to solve this problem

gmorken

Hello,

Which is the best way to solve this problem.
We are running Navision on native database and warehouse-system on sql. What I want is to compare the inventory values in the both systems. I have made a dataport in Navision that imports exported data from sql-server and then I have made a report that compares the values from the system. Is there a better solution for this problem? My solution requires manual steps and I want to automate it.

Can I solve this by a webservice and reporting services?

Regards

JoeK

Hi,

i did something like that already.

I implemented in Navision a function which connects to the sql server by ADO. With simple sql querys i got the values which i want to compare....

Greetings

gmorken

Ok. Can you show som code?