Posting Date filter.

Rajat_M

Hello Experts,

I have been asked to create two fields 'From Date' and 'To Date' in General Ledger Setup table. Then in 'General Ledger Entries' page when I use filter for Posting Date (e.g. 12/10/2012..05/05/2016) then it will show all the records till today. Also, I need to use ( where From Date<= To Date) expression.

For that I need to write a code within OnOpenPage Trigger of 'General Ledger Entries' page. And I also declared two global variables 'From Date' & 'To Date' and a record variable RecGLSetup(General Ledger Setup). But I don't know the exact code for this?? Can anyone please help me out??

Regards,

mohana_cse06

1. you need to set filter on G/L Entry (Rec) and not GL Setup
2. You need to get GLSetup first to apply values /filters on GL Entry rec.

mohana_cse06

Please try yourself and let us know what is not working.

Rajat_M

Within OnOpenPage() trigger I wrote:

RecGLSetup.SETRANGE("Posting Date","From Date", "To Date");

But didn't work..!!

mohana_cse06

1. you need to set filter on G/L Entry (Rec) and not GL Setup
2. You need to get GLSetup first to apply values /filters on GL Entry rec.

RockWithNAV

Rajat,

Write something like this. Keep on trying and thinking.

Glsetup.GET;
GLEntry.SETRNAGE("Posting Date",Glsetup.StartDate,Glsetup.EndDate);
GLEntry.FINDSET;