Update Request form

Lamba · 2012-06-21

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 · 2012-06-21

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 · 2012-06-21

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 · 2012-06-21

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?

Update Request form

Comments

Categories