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