Problem with Setfilter

deepblue

Hello,

In the GL setup table I have a text field that contain a filter for GL account (ex: '60801000..60803000','60801000','60801000|60803000',...).

I need to set a filter on the Gl account table using that filter, I've tried

Rec_GLAccount.SETFILTER("No.",'%1',Rec_GLSetup."Account Filter");

but it doesn't work when I have a complicated filter like '60801000..60803000' or '60801000|60803000'.

Can you help me?

remco_rausch

Try
Rec_GLAccount.SETFILTER("No.",Rec_GLSetup."Account Filter");

deepblue

Thank you \:D/ it works well =D>