Skip to main content

Notifications

Announcements

Announcing Category Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Exclude reverse entrie...
Small and medium business | Business Central, N...
Suggested answer

Exclude reverse entries from General Ledger entries excel

(0) ShareShare
ReportReport
Posted on by Michelleee12 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
    MahGah 15,428 on at
    RE: Exclude reverse entries from General Ledger entries excel

    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/.../

  • Michelleee12 Profile Picture
    Michelleee12 55 on at
    RE: Exclude reverse entries from General Ledger entries excel

    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
    MahGah 15,428 on at
    RE: Exclude reverse entries from General Ledger entries excel

    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

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

Announcing Category Subscriptions!

Quick Links

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans