Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Exclude reverse entries from General Ledger entries excel

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
    MahGah 15,419 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,419 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans