45

There should be a tick box when entering a journal to say that it should be reversed next period

STATUS DETAILS
Planned
2020 Release Wave 2
Ideas Administrator

Thank you for your valuable feedback. We have decided to deliver this idea and make it available with Business Central 2020 release wave 2.   

You can choose to **Copy to Posted Jnl. Lines** in **General Journal Templates** to enable copying of journals to **Posted General Journal**. You can also enable or disable **Copy to Posted Jnl. Lines** on a specific **General Journal Batch** that belongs to General Journal Templates where Copy to Posted Jnl. Lines was enabled.

On the **Posted General Journal** page, you can now use the **Copy Selected Lines to Journal** function to create a copy of a general journal line or a batch with opposite signs (a reversing journal), a different posting date or document number. **Copy G/L Register to Journal** function will copy all journal lines that belong to selected G/L Register to targe General Journal.
On **Recurring General Journals**, in **Reverse Date Calculation** column, you can now enter the date formula that will be used to calculate the date with which reversal entries will be posted where Reversal Recurring Methods are used. Please note that **Reverse Date Calculaiton** can be added to Recurring General Journal through page personalization.

This feature is available to be enabled as standard for all Business Central customers in Business Central 2020 Release Wave 2. To enable this feature, sign in to your online environment and open General Journal Templates page and choose to **Copy to Posted Jnl. Lines** for General Journal Templates where you want to enable this feature.

Learn more about what's new and planned for "Use the Copy Journal function on Posted General Journals and control date for reversing entries in Recurring General Journals" in the release plan here: https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/use-copy-journal-function-general-journals-gl-registers-when-reversing-entries  

Your help was greatly appreciated,  
Business Central Team

Comments

K

Using a recurring journal to do reversing journals is fine in my opinion. The problem with the recurring journal however is it lacks functionality in the standard general journal such as Approvals and edit in Excel.

Category: Financial Management

K

To respond to the BC Administrator's question from 1/29/2020, this seems to be the functionality most of us are talking about, but the problem is that it is only in the Recurring Journals and not in any of the other journals, primarily General Journals. The other problem is that it appears you can't choose WHEN to reverse the entry. Most times, you need a reversing entry on an "as-needed" basis as you post it in a regular General Journal. I think you should add the functionality to ALL journal types and let the user choose if they want to reverse it or not and most important, WHEN do they want to reverse it. It is not always the immediate month following the original posting.

Category: Financial Management

K

I agree with this idea. If we compare with customers that are using Dynamics GP and think to go with Business Central, it is a choice when entering a journal entry if it is standard or a reversing entry. If it is a reversing entry we must enter a reversing date. That could be really nice to have this choice.

Category: Financial Management

K

Reverse on date is needed.

like shown in this picture:
https://community.dynamics.com/resized-image/__size/750x557/__key/communityserver-discussions-components-files/34/6545.reverse.png

Category: Financial Management

K

I completely agree. This is a MUST have and should allow the user to choose what period they want it to reverse to. It's a basic functionality like Justin said.

Category: Financial Management

K

I agree with Justin. When reversing a journal, the user should be able to choose freely a posting date (of course only possible to reverse in open accounting periods)

Category: Financial Management

K

Alternatively... Allowing a user to edit the posting date when reversing a journal would be ideal. I am absolutely floored that this basic functionality is not present in the system.

Category: Financial Management

K

I'd go one further and request two new fields. The tick box to indicate the lines should have a reversing entry, and a reversing date with is populated with the 1st of the next period by default based on the posting date for the line, but editable so the user can enter their own specific reversing date if they so wish.

Category: Financial Management