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

Announcements

No record found.

News and Announcements icon
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

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