Selecting the range of GL accounts in query level

[Former Member]

Hi Friends,

In the query level how to select the GL account range. There is a requirement to select only the GL accounts b/w (100000-199999), (200000-299999) (700000-799999). where i need to write this condition in the query. help me out.

Thanks in advance

Karthik

Edited by: karthikeyan l on Mar 2, 2009 9:19 AM

[Former Member]

I have did it in query level

[former_member181964]

Hi

You can do it by using Customet Exit, just see the sample code, you changec the code as per your requirement,.

When 'ZGLA'.
   IF I_STEP = 2.
     Clear l_s_range.
     l_s_range-LOW = '*30'.
     l_s_range-OPT = 'CP'.
     l_s_range-SIGN = 'I'.
     Append l_s_range to e_t_range.
     
     Clear l_s_range.
     l_s_range-LOW = '*31'.
     l_s_range-OPT = 'CP'.
     l_s_range-SIGN = 'I'.
     Append l_s_range to e_t_range.
   ENDIF.

Thanks

Reddy

[Former Member]

Hi,

Create a variable for GL Account with option "Select Option" and restrict againest required values as default values or in filter.

Srini

[Former Member]

Hi Srini,

I have added the variable with select options, but where the value should be given like 10000 to 19999. Do i need to do it in "Set offset for variable", but that icon is disabled.

Thanks

Karthik

Edited by: karthikeyan l on Mar 2, 2009 9:33 AM

[shanthi_bhaskar]

hi,

restrcit with varaible ranges opiton and give ur default values in from to section.

bhaskar

[former_member181964]

Hi,

Yes you can set teh defalut values for that Variable, Create 3 variabls on GL A/C and then write the following code, else at the time creating variables select Ranges and then try to give defalut values.

When 'ZGLA'.
   IF I_STEP = 1.
     Clear l_s_range.
     l_s_range-LOW = '100000'.
     l_s_range-HIGH = '199999'.
     l_s_range-OPT = 'BT'.
     l_s_range-SIGN = 'I'.
     Append l_s_range to e_t_range.
   ENDIF.

When 'ZGLA1'.
   IF I_STEP = 1.
     Clear l_s_range.
     l_s_range-LOW = '200000'.
     l_s_range-HIGH = '299999'.
     l_s_range-OPT = 'BT'.
     l_s_range-SIGN = 'I'.
     Append l_s_range to e_t_range.
   ENDIF.


When 'ZGLA2'.
   IF I_STEP = 1.
     Clear l_s_range.
     l_s_range-LOW = '700000'.
     l_s_range-HIGH = '799999'.
     l_s_range-OPT = 'BT'.
     l_s_range-SIGN = 'I'.
     Append l_s_range to e_t_range.
   ENDIF.

Thanks

Reddy

[Former Member]

Karthik,

No need of any offset.

Gor GL Account restrict againest multiple ranges. follow below steps..

GL Account --> Ristrict --> Ranges/multiple values --> Between --> Choose required ranges --> add.

Srini

[Former Member]

Hi Reddy,

I have selected the option Customer exit while creting the variable, where i need to write those program now

thanks

Karthik

[former_member192142]

Why do you need variables if it is a fixed selection. There is no need, just do as Srini described just above. Right click the characteristic -> restrict and then enter the value ranges for GL Account.

Best regards,

Jacob

[Former Member]

Hi JL,

i cant do it iin default or fixed, actually am doing it to calculate Cummulative balance for the above mentioned GL series, but still there is lot of GL series has to be displayed with out cummulative.

thanks in adv

Karhtik