Update Request form

Lamba · **Posted:** Thu Jun 21, 2012 1:26 pm

I have created a custom report and have added it to stock voucher journal.
The issue is this that it doesn't picks up the current Journal Batch Name while running the report,as it should.
As we can see it in Sales order->Test Report the current document Type and No. gets updated automatically.
How this can be done, is there any property

udayrmer · **Posted:** Thu Jun 21, 2012 1:38 pm

Hi,

Take a variable, apply filters of Journal Template Name and, Journal Batch Name, and pass this record when running report.

support you using Item Journal Line then

ItemJnlLine.SETRANGE("Journal Template Name","Journal Template Name");
ItemJnlLine.SETRANGE("Journal Batch Name",Journal Batch Name");
REPORT.RUNMODAL(REPORT::"XYZ",TRUE,FALSE,ItemJnlLine);

faizguy84 · **Posted:** Thu Jun 21, 2012 1:47 pm

second option would be to create a menu item and write the code on 'OnPush'
ItemJnlLine.SETRANGE("Journal Template Name","Journal Template Name");
ItemJnlLine.SETRANGE("Journal Batch Name",Journal Batch Name");
Report.SETTABLEVIEW(ItemJnlLine);
Report.RUNMODAL;

mohana_cse06 · **Posted:** Thu Jun 21, 2012 1:49 pm

Lamba wrote:

As we can see it in Sales order->Test Report the current document Type and No. gets updated automatically.
How this can be done, is there any property

Cant you debug the process what it is doing?

mibuso.com

Update Request form

Who is online