mibuso.com

Microsoft Business Solutions online community
It is currently Sat May 25, 2013 5:12 am

View unanswered posts | View active topics


Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » NAV/Navision Classic Client

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 2 posts ] 
  What's this MUID? [MUID:XE3U] Previous topic | Next topic 
Author Message
jordi79
 Post subject: Exclude Closing dates in DATEFILTER
PostPosted: Wed Jun 13, 2012 6:27 am 
Offline

Joined: Thu Jul 14, 2005 9:04 am
Posts: 86
Location: Malaysia
Country: Malaysia (my)
Hi,
I am trying to exclude closing dates in a range of date filter. There seems to be no easy way to do this.

I cannot just filter like this -->
010111..311212|<>C*
NAV does not accept filters like that.

I have to loop the accounting period table and determine closing dates from there, and append the closing dates from accounting period table. Is there an easier way to do this?
Top
 Profile  
 
Chinmoy
 Post subject: Re: Exclude Closing dates in DATEFILTER
PostPosted: Wed Jun 13, 2012 7:07 am 
Offline

Joined: Wed Apr 07, 2004 9:39 am
Posts: 339
Location: Bangalore
Country: India (in)
I don't think there is a way to do this when you are entering the dates in the filter box through an interface.. but when filtering through code you can use <> CLOSINGDATE(311209D), however this does not work with a range of dates.

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

Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » NAV/Navision Classic Client

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 4 guests

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: