Set Range on G/L Account Code Field

nileshr18

I want to filter the record using setrange on No. field in G/L account table
and display the filtered record for example I want to dispaly the No. from
563. to 563.0002,I want to apply the filter on No field of G/L Account table ?

Sandeep_Prajapati

I am sure you know how to use SetRange. Can you elaborate a bit please. O:)

pranav-joshi

use following code:

GLAcc.SETRANGE("No.",563,563.002);

or u can also take help from c/side reference guide.


Pranav
Intech Systems Pvt. Ltd.

Alex_Chow

Becareful! Character counts!

563 is different than 563.000. :!:

kine

It means you need something like:

GLAcc.SETRANGE("No.",'563.000','563.002'); 

ssingla

Alex Chow wrote:

Becareful! Character counts!

563 is different than 563.000. :!:

That is something which one should avoid i.e having different number of characters in the G/L Account code. Place 0 to make them uniform.

Alex_Chow

kine wrote:

It means you need something like:

GLAcc.SETRANGE("No.",'563.000','563.002'); 

Thanks for the clarification.

I keep assuming people know.