Report Inventory Value using SQL server

Djindjiplactor

Hi all, I have to do Inventory Value report, using SQL. How to do this? Which tables and filds must to use?

Thank you

kriki

[Topic moved from 'SQL Tips & Tricks' forum to 'SQL General' forum]

Before you start doing this in SQL, start knowing how to do this in C/AL. If you don;t even know how to do it in pure C/AL (you don't even know which tables and fields to use....), how can you even be sure to succeed in SQL. In general it is more difficult but the performance is way better.

rmv_RU

Have a look at http://forum.mibuso.com/discussion/comment/285772/#Comment_285772.