How to generate Report from budget

srinictsrinict Member Posts: 58
Hi all

Im facing problems in generating report from budget. I have created a new report, where it will show some fields ](*,) from G/L account table.
Im using one tab (Get Report) in Budget form, On pressing 'Get report', it will run my created report where G/L acc no in request form should be the same as G/L account filter(in filter tab in budget form). To achieve that, i had written code in 'On Push' trigger of 'Get Report' as :

GLaccrec.SETFILTER(GLaccrec."No.",'%1',GLAccFilter);
//if GLaccrec.FINDFIRST then
REPORT.RUNMODAL(50009,TRUE,FALSE,GLaccrec);

in this case, G/L acc no (in req form) is filering with single quotations, fo ex: '1000..1005'
So report is not generating stating that G/L acc no does not exist

Pls help to achieve this.

Thanks

Answers

  • MBergerMBerger Member Posts: 413
    use this :
    GLaccrec.SETFILTER(GLaccrec."No.",GLAccFilter);
  • srinictsrinict Member Posts: 58
    Thanks a lot for your early reply and our problem has been solved.

    Regards,
    Srinivas
Sign In or Register to comment.