Report Inventory Value using SQL server

Djindjiplactor
Djindjiplactor Member Posts: 1
in SQL General
Hi all, I have to do Inventory Value report, using SQL. How to do this? Which tables and filds must to use?

Thank you

Answers

  • kriki
    kriki Member, Moderator Posts: 9,121
    [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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • rmv_RU
    rmv_RU Member Posts: 119
    Have a look at http://forum.mibuso.com/discussion/comment/285772/#Comment_285772.
    Looking for part-time work.
    Nav, T-SQL.

Categories