Report issue in RTC only

navuser1navuser1 Member Posts: 1,329
edited 2012-09-06 in NAV Three Tier
Dear Sir,

Unable see the Test Report preview from Payment Journal in NAV 2009 R2 (RTC). It gives the below error message.



How to solve this issue ?

Note :- Same thing working correctly from Classic Client.

Thanks!
Now or Never

Comments

  • BeliasBelias Member Posts: 2,998
    Is the report standard or has it been modified (or is it localized)?
    Is there some commit (i don't remember if it's possible) under the section triggers?
    I'm asking it because sometimes that kind of error can be solved by placing the right COMMIT statement in the right place. Some other times, the code is not well designed.
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • navuser1navuser1 Member Posts: 1,329
    This is Localized Standard Report (IN Version), ID 2.

    The most interested thing is that the same report is running correctly from different Journal Screen.

    I have found no "COMMIT" statement in any Section trigger.

    :shock:
    Now or Never
  • BeliasBelias Member Posts: 2,998
    let's wait for someone of your country, maybe he has already solved the problem.
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Can you show us the code under OnPush trigger of Test Report from Payment Journal Page and also PrintGenJnlLine function code from Codeunit Test Report-Print...

    I am using NAV2009R2 32012 build and didnt get any error.
  • navuser1navuser1 Member Posts: 1,329
    <Action45> - OnAction()
    ReportPrint.PrintGenJnlLine(Rec);

    PrintGenJnlLine(VAR NewGenJnlLine : Record "Gen. Journal Line")
    GenJnlLine.COPY(NewGenJnlLine);
    GenJnlLine.SETRANGE("Journal Template Name",GenJnlLine."Journal Template Name");
    GenJnlLine.SETRANGE("Journal Batch Name",GenJnlLine."Journal Batch Name");
    IF GenJnlLine.FINDFIRST THEN
    GenJnlLine.CalcTDS('');
    GenJnlTemplate.GET(GenJnlLine."Journal Template Name");
    GenJnlTemplate.TESTFIELD("Test Report ID");
    REPORT.RUN(GenJnlTemplate."Test Report ID",TRUE,FALSE,GenJnlLine);
    Now or Never
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    navuser1 wrote:
    IF GenJnlLine.FINDFIRST THEN
    GenJnlLine.CalcTDS('');
    Above code should be
    IF GenJnlLine.FINDFIRST THEN
      IF GenJnlLine."TDS Nature of Deduction" <> '' THEN BEGIN
        GenJnlLine.CalcTDS('');
        COMMIT;
      END;
    
  • navuser1navuser1 Member Posts: 1,329
    navuser1 wrote:
    IF GenJnlLine.FINDFIRST THEN
    GenJnlLine.CalcTDS('');
    Above code should be
    IF GenJnlLine.FINDFIRST THEN
      IF GenJnlLine."TDS Nature of Deduction" <> '' THEN BEGIN
        GenJnlLine.CalcTDS('');
        COMMIT;
      END;
    

    Yes!
    I have found this correction in NAV 2013 in IN version.

    Thanks you.
    Now or Never
  • navuser1navuser1 Member Posts: 1,329
    Dear Sir,

    The uncorrected code does not give me any error message while it's called from Classic Client from Payment Journal Screen (Same Batch).

    What is the reason ? :roll:
    Now or Never
Sign In or Register to comment.