Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Query

(0) ShareShare
ReportReport
Posted on by 3,099

Hi

  I want to generate Trial Balance Report . What should be the query . I want to do it in SSRS 

Liabilities

      Liabilities Value

Capital

      Equity Shares Capital Value

      Share Forefit Value

Reserve Surplus

      Capital Reserve Value

      General Reserve Value

No_ Name Search Name Account Type
1-L010000 LIABILITIES LIABILITIES 3
1-L020000 CAPITAL CAPITAL 3
1-L020010 Equity Shares Capital A/C EQUITY SHARES CAPITAL  0
1-L020020 Share Forfeit A/C SHARE FORFEIT  0
1-L029999 CAPITAL TOTAL  CAPITAL TOTAL 4
1-L030000 RESERVES AND SURPLUS RESERVES AND SURPLUS 3
1-L030010 Capital Reserve CAPITAL RESERVE 0
1-L030020 General Reserve  GENERAL RESERVE 0

*This post is locked for comments

  • jsshivalik Profile Picture
    3,099 on at
    RE: Query

    Hi

        Setup is like that . Which fields from the tables should i use for Grouping

    Thanks

  • Suggested answer
    Amol Salvi Profile Picture
    18,696 on at
    RE: Query

    Chart of account need to design such a way so you can get above result. You need to use GL account table

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans