web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Business Central forum

i want to create report in g/l account under the report action before detail trail balance

(0) ShareShare
ReportReport
Posted on by 339

Hello Experts ,

i want to create report in g/l account under the report action before detail trail balance  , please find below screenshot also 

it is not display my report before detail trail balance 

reportsaddinchartofaccounts.PNG

 kindly check my below code is correct or not 

Report 

*************

report 50101 Testreport
{
DefaultLayout = RDLC;
RDLCLayout = 'testmyreport.rdl';
UsageCategory = Administration;
ApplicationArea = All;

dataset
{
dataitem("G/L Account"; "G/L Account")
{
column("No_"; "No.") { }
column(Name; Name) { }
column(Income_Balance; "Income/Balance") { }
column(Account_Category; "Account Category") { }
column(Account_Subcategory_Descript_; "Account Subcategory Descript.") { }
}
}
}
Report page extension
***************************************
pageextension 50101 ReportForChartOfAccount extends "G/L Account Card"
{


actions
{

addafter("Trial Balance")
{


action(mytestreport)
{
ApplicationArea = all;
trigger OnAction()
begin
myReport.run()
end;
}
}
}
var
myreport: Report Testreport;
}


I have the same question (0)
  • Suggested answer
    I Gusti Made Ari Profile Picture
    3,608 on at

    Please try to change "addafter("Trial Balance")" to : 

    addbefore("Detail Trial Balance")
  • SABIH Profile Picture
    339 on at

    Hello

    I did but its coming only in g/l account card ,but is is not come in ,i want to be her in chart of accounts have any solution 

    pageextension 50101 ReportForChartOfAccount extends "G/L Account Card"
    {


    actions
    {

    addbefore("Detail Trial Balance")
    {


    action(mytestreport)
    {
    ApplicationArea = all;
    trigger OnAction()
    begin
    myReport.run()
    end;
    }
    }
    }
    var
    myreport: Report Testreport;
    }
    3323.reportsaddinchartofaccounts.PNG
    3323.reportsaddinchartofaccounts.PNG
  • Verified answer
    I Gusti Made Ari Profile Picture
    3,608 on at

    Well if you need it at Chart Of Account As well , you need additional page extension as well .

    pageextension 50102 ChartOfAccountExt extends "Chart of Accounts" //16
    {
        layout
        {
    
        }
    
        actions
        {
            addbefore("Detail Trial Balance")
            {
                action(mytestreport)
                {
                    ApplicationArea = all;
                    trigger OnAction()
                    begin
                        myReport.run()
                    end;
                }
            }
        }
        var
            myreport: Report Testreport;
    }
    


  • SABIH Profile Picture
    339 on at

    Hello Gusti Made Ari Permadi ,

    Thank you 

    Finally issue has been resolved

    chartofaccount.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans