web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Error "Cannot rev...
Microsoft Dynamics NAV (Archived)

Error "Cannot reverse bank account ledger entry no. XXXX because the entry is closed" when reversing GL entries.

(0) ShareShare
ReportReport
Posted on by PTON Corporation 215

We have posted journal entries with 0 in amount. As a result, blank entries appeared in Detail Trial Balance report and we would like to delete these entries by reversing these transactions but unfortunately reversing entries always showed Cannot rev erse entry because the entry is closed.

Thanks in advance for any help.

*This post is locked for comments

I have the same question (0)
  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    Re: Error "Cannot reverse bank account ledger entry no. XXXX because the entry is closed" when reversing GL entries.

    Hello PTON Corporation,

    Thank you for posting on the Forum.  

    Based on my testing using the Dynamics NAV North America Version 2009 R2 Report 10021 - Trial Balance Detail/Summary, I can add the Amount field as a filterable field on the G/L Entry Tab and filter-out the 0 Amounts by using a <>0 filter. Rather than trying to go through the extensive effort of trying to update the data through the Tables on the backend to reopen the entries so the entries can be reversed, why not filter out the 0 Entries from being reported?  Would this be a better option for what you are trying to accomplish?  Such a step would seem the more direct method for managing the information and presentation.  My additional concern is that I don't think reversing the 0 entry will work. NAV doesn't delete entries but records reversing entries, so you would then have 2 entries with 0.

    Hopefully the guidance provided will help you move forward.

    Thanks

    Tom

  • PTON Corporation Profile Picture
    PTON Corporation 215 on at
    Re: Error "Cannot reverse bank account ledger entry no. XXXX because the entry is closed" when reversing GL entries.

    Hi Tom,

    Thank You for your reply.

    May I ask if you're using NAV 2009 RTC or the Classic client?. I checked the Amount field but it's not available in the list of filters. I tried filtering using Debit/Credit Amount <>0 but it shows same results.

  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    Re: Error "Cannot reverse bank account ledger entry no. XXXX because the entry is closed" when reversing GL entries.

    Hi PTON,

    Sorry for the delay, but I was out of the office.

    You should be able to set the filter in either case. The Amount field is available under the G/L Entry - Show Results filters if you click the Show Results - Add Filter option in the RTC.  The Classic Report just shows Amount as an available field under the G/L Entry Tab as a field to be selected.

    Thanks

    Tom

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans