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:
Click More and then select the + Field button:
Drag and drop the “Reverse Date Calculation” field onto the window, as shown.
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)
I can go to Post/Print > Preview > Preview Posting to verify the reversing entry dates are correct:
Below is the result of the posted batch:
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.
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.