mibuso.com

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

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 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  
 
 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  
 
 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  
 
 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  [ 4 posts ] 

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: