Reversing Date Calculation in Dynamics 365 Business Central

New feature in Dynamics 365 BC

There is now more control available on the reversing date for recurring general journals in Microsoft Dynamics 365 Business Central. This is a new feature in the latest release.

To start, navigate to Recurring General Journals and select the batch you would like to work with.

You will need to personalize your window first to add the new field “Reverse Date Calculation.”

Click the settings wheel and select personalize:

Business Central Reverse Date Calculation

Click More and then select the + Field button:

Business Central Reverse Date Calculation

Drag and drop the “Reverse Date Calculation” field onto the window, as shown.

Business Central Reverse Date Calculation

Then click Done. Exit the window and open it again.

I added the Reverse Date Calculation field next to posting date per below. I entered 2 Reversing entries to demonstrate different calculations that can be used for the reversing date.

  • The first entry will reverse the date in 7 days (CD+7D).
  • The second entry will reverse the date 10 days into the following month (CM+10D).

Both entries are using the code ACCRUE%4 code for the Document No. This will create the Document No. as ACCRUE<MONTH> (ACCRUENOVEMBER)

Business Central Reverse Date Calculation

I can go to Post/Print > Preview > Preview Posting to verify the reversing entry dates are correct:

Business Central Reverse Date Calculation

Below is the result of the posted batch:

Business Central Reverse Date Calculation

After I post the batch it will remain out there with the date rolled forward 1 month. The amounts will now be 0.00 since this was a RV Reversing Variable Method.

Business Central Reverse Date Calculation

And that’s all there is to it! Was this still gibberish, or does it make sense but you crave more info? You may want to go back to school! Click here for a little bit of info on our Crestwood Academy, an advanced paid training designed to make you a Business Central expert in a matter of weeks! Contact us for more info on this program.

Leave a Reply