[Axapta-Knowledge-Village] retrieving records by paging

Hi, Is there any possibility in Ax to get the records from a table set by set i.e.,first 15 records one time, next 15 records other time and so on.. Regards, Giridhar Raj.

[Axapta-Knowledge-Village] how to represent not equal to symbol in query build

Hi, Can anyone tell me how to put NOT EQUAL TO symbol in query build. Because the below query is not working for me. str test; test =''; qbr.value(strfmt('%1 != %2',contact.custaccount,test) Regards, Giridhar Raj.

Re: [Axapta-Knowledge-Village] how to represent not equal to symbol in query build

Hi, Check if it works.. try with SysQuery in Value. for eg., Qbr.value(SysQuery::valueNotEmptyString()); -- this checks value is not equal to null. Hope it helps. Regards, Anitha On Fri, Nov 20, 2009 at 2:59 PM, giridharraj giridhar...@yahoo.com wrote: Hi, Can anyone tell me how to put

[Axapta-Knowledge-Village] Re: One invoice against two sales order

Hi Nitin , Thank you very much. It also works in Ax 3.0 also Thanks again. PRASANNA --- In Axapta-Knowledge-Village@yahoogroups.com, NITIN DESALE nitindes...@... wrote: Hi, I am not sure its available in 3.0 or not.but in 4.0 sp2 you can post invoice against multiple sales

[Axapta-Knowledge-Village] Re: how to represent not equal to symbol in query build

Hi, ya, that is ok if not empty string but wat if i want to put for not equal to a value.Bcoz query build is not considering != symbol.i.e., str test; test ='1100'; qbr.value(strfmt('%1 != %2',contact.custaccount,test) Regards, Giridhar Raj. --- In Axapta-Knowledge-Village@yahoogroups.com,

Re: [Axapta-Knowledge-Village] Re: how to represent not equal to symbol in query build

Hi, Use SysQuery::valueNot(anytypeValue); Regards, Sumit On Fri, Nov 20, 2009 at 4:30 PM, giridharraj giridhar...@yahoo.com wrote: Hi, ya, that is ok if not empty string but wat if i want to put for not equal to a value.Bcoz query build is not considering != symbol.i.e., str test;

[Axapta-Knowledge-Village] AX 4.0 SP1 Freeze Issue

Hi All, We are facing a peculiar problem in MS Dynamics AX 4.0 Sp1 environment . We have around 70-80 users connecting to AX using citrix terminal servers. The business works from different locations and have users connecting from local clients as well. When the local clients are connected the