mibuso.com

Microsoft Business Solutions online community
It is currently Fri May 24, 2013 6:03 pm

View unanswered posts | View active topics


Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » NAV Three Tier

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 
  What's this MUID? [MUID:GUWY] Previous topic | Next topic 
Author Message
monir_asian
 Post subject: setfilter for remaining quantity >0
PostPosted: Sat Apr 28, 2012 9:13 am 
Offline

Joined: Mon Nov 28, 2011 2:31 pm
Posts: 57
Country: Georgia (ge)
I need a filtering field in itemledger entry table where remaining quantity >0
setfilter(remainingquanatity,'>%1',0);
setfilter(remainingquanatity,'>0');

which one is correct?
Top
 Profile E-mail  
 
Luc Van Dyck
 Post subject: Re: setfilter for remaining quantity >0
PostPosted: Sat Apr 28, 2012 9:16 am 
Offline
Site Admin
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Sun Nov 07, 1999 8:01 am
Posts: 3294
Location: Wilrijk
Country: Belgium (be)
You should use the 1st notation ... but correct the fieldname ;-)

_________________
No support using PM or e-mail - Please use this forum.
Search is your friend || Mark your Topic as SOLVED (= green checkmark) when your question is answered || Read the Forum Rules before making a posting
»»» Mark your calendar: NAV TechDays 2013 - 7 & 8 November 2013 ««« Visit the conference website: www.navtechdays.com

Top
 Profile  
 
kriki
 Post subject: Re: setfilter for remaining quantity >0
PostPosted: Sat Apr 28, 2012 12:09 pm 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7504
Location: Milan
Country: Italy (it)
Actually both work in this case, but the first always works.

_________________
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  
 
thegunzo
 Post subject: Re: setfilter for remaining quantity >0
PostPosted: Sun May 06, 2012 7:32 pm 
Offline

Joined: Mon Apr 04, 2005 3:49 pm
Posts: 72
Location: Sauðárkrókur
Country: Iceland (is)
You might want to select a key with the Open field included and use SETRANGE(Open,TRUE) before this filter to speed things up.

_________________
________________________________
Gunnar Gestsson
Microsoft Certified IT Professional
http://www.dynamics.is

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

Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » NAV Three Tier

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: mbmartinwa and 6 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: