web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Query

Microsoft Dynamics NAV (Archived)

Query

(0) Share

Report

Report

Posted on by jsshivalik

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

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

Thanks

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans