mibuso.com
Home› NAV Three Tier
Options

setfilter for remaining quantity >0

monir_asianmonir_asian Member Posts: 80
edited 2012-05-06 in NAV Three Tier
I need a filtering field in itemledger entry table where remaining quantity >0
setfilter(remainingquanatity,'>%1',0);
setfilter(remainingquanatity,'>0');

which one is correct?

Comments

  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    You should use the 1st notation ... but correct the fieldname ;-)
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    krikikriki Member, Moderator Posts: 9,090
    Actually both work in this case, but the first always works.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    thegunzothegunzo Member Posts: 274
    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
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
Sign In or Register to comment.