mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 6:06 pm

View unanswered posts | View active topics


Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 2 posts ] 
  What's this MUID? [MUID:USEH] Previous topic | Next topic 
Author Message
stomar_3
 Post subject: SQL Query for Outstanding amount per item
PostPosted: Fri Feb 26, 2010 12:16 am 
Offline

Joined: Wed May 07, 2008 10:39 am
Posts: 15
Location: BREDA
Country: Netherlands (nl)
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.
Top
 Profile  
 
kriki
 Post subject: Re: SQL Query for Outstanding amount per item
PostPosted: Fri Feb 26, 2010 10:53 am 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7501
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV 2009' forum to 'SQL General' forum]

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 2 posts ] 

Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: