Date Filtering in GL Account

thankesh

Hi,

In my report, "Totaling" is the customized field from a customized table "GP analysis". I want to filter for those acc no. in the text field in G/L account table.

EG: If "Totaling" field has "10000..10020" (text) value. the corresponding acc. nos will get filtered so that the "balance to date" value can be calculated.
:-k

PF the below code:

GLAcc.RESET;
GLAcc.SETRANGE("No.",Totaling);
GLAcc.SETFILTER("Date Filter",'%1..%2',S_CurrMonth,E_CurrMonth);
IF GLAcc.FINDSET THEN
REPEAT
GLAcc.CALCFIELDS(GLAcc."Balance at Date");
Currmonth_Totsale += GLAcc."Balance at Date";
UNTIL GLAcc.NEXT = 0;

mohana_cse06

I am not sure what is your issue in above code..

If datefilter is not working in your code..

Did you try?

GLAcc.SETRANGE("Date Filter",S_CurrMonth,E_CurrMonth);