SQL Query for Outstanding amount per item

stomar_3

Dear Collegs,

I have one question and hope that somebody can help me.

Namely, I need to make SQL query (for SSRS) which as result will have Outstanding amount per item per period.
Report should be something like this :

Item : SalesInvNo : Turnover : Current : 1-30 days : 30-60 : over 60.

Hope that somebody have experience with building with this query.

Thanks in advance.

Regards.

kriki

[Topic moved from 'NAV 2009' forum to 'SQL General' forum]