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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Reversing of Recurring Journals

(8) ShareShare
ReportReport
Posted on by 340
Dear Members,

When I tried to reverse a trasaction in recurring journal it is not allowing to post in future date in Business central.It allows only if the work date is changed to future date.How to reverse in future date without changing the work date? Please help me with this.


Thanks in advance,
sneha
I have the same question (0)
  • Suggested answer
    Sohail Ahmed Profile Picture
    11,169 Super User 2026 Season 1 on at
    Hi Sneha,
     
    In Business Central, posting in a future date from a recurring journal requires the Work Date to match or be later than the reversal date. Unfortunately, there’s no built-in setting to bypass this.
     
    ✅ Workaround: Temporarily set the Work Date to the future date you want to post the reversal on. You can revert it back immediately after posting.
     
    If your process frequently needs future reversals, a custom extension might help automate or simplify this.
     
     
     
     
    ✅ Mark this answer as verified if it helps you.
     
     
  • Suggested answer
    Ramesh Kumar Profile Picture
    7,547 Super User 2026 Season 1 on at
    Business Central always uses the Work Date as a control mechanism when posting transactions. If you attempt to post a journal line with a Posting Date later than the Work Date, it will block the posting unless explicitly allowed.
     
    You can also control user setup by putting allowed posting date range
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • Suggested answer
    YUN ZHU Profile Picture
    99,086 Super User 2026 Season 1 on at
    Hi, hope the following helps as well.
     
    Thanks.
    ZHU
  • Suggested answer
    Andrés Arias Profile Picture
    5,166 Super User 2026 Season 1 on at
    Hello,
     
    In the standard functionality it would not be possible, I would recommend to keep using the Work Date option or analyze if it is really necessary to make a development. I hope the following information can help you:
     

    I hope I can help.
     
    Regards,
     
    Andres
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,803 Super User 2026 Season 1 on at
    Hello,
     
    Reversing a transaction in a recurring journal for a future date is restricted unless the Work Date is also set to that future date, as the system prevents future-dated postings by default.
     
    To proceed, you must temporarily change the Work Date to the desired future date, post the journal, and then revert the Work Date back.
     
    There is no built-in way to bypass this without adjusting the Work Date.
  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    9,112 Super User 2026 Season 1 on at

    Hi Sneha,

    This is a common scenario when working with Recurring General Journals in BC. By default, BC restricts posting to future dates unless the Work Date is adjusted. But there’s a clean workaround using Reversal Date Calculation and page personalization.

    Here’s how to reverse in a future date without changing the Work Date:

    Use the “Reversal Date Calculation” Field

    • On the Recurring General Journal page, personalize the view to add the Reversal Date Calculation field.
    • This field lets you define a formula for the reversal date (e.g., CM+10D for 10 days into the next month).
    • BC will then post the reversal entry on the calculated future date, even if your current Work Date is today.

    How to Add the Field

    • Click the Settings icon > Personalize
    • Select + Field and drag Reversal Date Calculation onto the journal page
    • Click Done to save personalization

    Example Formula

    • CD+7D → 7 days from current date
    • CM+10D → 10 days into next month
    • 1M-1D → Last day of next month


    This method gives you full control over reversal timing without needing to alter the global Work Date.

    Helpful References:
    Using Recurring & Reversing Journals in BC
    Reversing Date Calculation – Crestwood
    Undo Posting via Reversal Entry – Microsoft Learn


    If this solves your issue, feel free to mark it as the suggested answer.

    Cheers
    Jeffrey

  • Suggested answer
    Sumit Singh Profile Picture
    11,757 Super User 2026 Season 1 on at
    Workarounds to Post in Future Date Without Changing Global Work Date
    Here are a few options:
    Option 1: Change Work Date Temporarily (Safest)
    This is the recommended and safest method, as it doesn't affect other users.
    Option 2: Use a Custom Posting Date Field (Advanced)
    If you're developing a custom solution, you can:
    • Add a custom field for "Desired Posting Date"
    • Use AL code to override the Posting Date during posting logic
    • This requires customization and careful handling of posting routines
    Option 3: Schedule Posting via Job Queue
    • Create a Job Queue Entry to post the journal on the future date
    • This way, the system posts it automatically when the date arrives
    Important Notes
    • Ensure the Allowed Posting Date Range in General Ledger Setup and User Setup includes the future date.
    • If you're using approval workflows, make sure the future date doesn't conflict with approval timing.
    Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
    Mark the Answer as Verified if this is Helpful.
     

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,005 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,148 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans