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 :
Small and medium business | Business Central, N...
Suggested Answer

Exclude reverse entries from General Ledger entries excel

(0) ShareShare
ReportReport
Posted on by 55

Hi, I would like to check if there is an option to exclude the reverse entries when we print/ download General Ledger entries to excel? Thanks.

  • Suggested answer
    MahGah Profile Picture
    15,613 on at

    Can you try the following

    Go to General Ledger Entries then filter by date range you need and then Source Code <>Reversal  

    I am not sure if this is what you needed. 

    pastedimage1641575248584v1.png

  • Michelleee12 Profile Picture
    55 on at

    Hi Mah Gah, thank you for your reply.

    May I check how am I able to print the general ledger entries report by showing each G/L account total amount? Thanks.

  • Suggested answer
    MahGah Profile Picture
    15,613 on at

    Hi

    I could not find a report for that. My suggestion is either:

    1) Take it to Excel then sum it up.

    2) Use free QuickSum app. Then filter each account and sum it up : appsource.microsoft.com/.../PUBID.webcom|AID.bc001|PAPPID.0b613ad6-def9-43ec-994c-1db094d086d8

    The other methods are

    1) Customer report which require development

    2) Use ODATA and Excel. You can use General Ledger Entries ODATA (Web Service). Then take the data to Excel, then use Power Query to filter the data they way you want to. Format them then reuse the report. See below for example

    thatnavguy.wordpress.com/.../

    archerpoint.com/.../

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 755 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 413 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 387 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans