Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

(0) ShareShare
ReportReport
Posted on by 46,226 Super User 2024 Season 2

Has anyone seen this behavior - when selecting 'Use existing dates for reversal', seemingly random dates are sometimes (not always) selected for the reversal posting.  I've been trying to identify a pattern to this behavior with no success thus far.  I've advised the client not to flip this flag on and instead enter the date they want to journal to reverse on.  I've seen this in multiple environments.  Thanks

2020_2D00_07_2D00_08_5F00_14_2D00_10_2D00_23.jpg

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,226 Super User 2024 Season 2 on at
    RE: General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

    Thanks MATTGUO and Ludwig.  Our current version includes hotfixes 445217 & 452984, but I see Quality update 10.0.420.30017 in LCS that includes 4557353 which needs to be applied.  I'll report back on whether this fixes the issue.  Thank you experts!!  

  • MATTGUO Profile Picture
    MATTGUO 22,312 on at
    RE: General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

    Hi,

    Please check KB4557353.

    If not work, please create a support ticket.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

    Hello Frank,

    Can you double check whether the following hotfixes apply?

    Issue 445217 Reversal dates are not correct when used reverse entire journal for transactions with multiple dates

    Issue 452984 Unable to reverse the general journal when it is retrieved from a periodic journal into the general journal

    Best regards,

    Ludwig

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,226 Super User 2024 Season 2 on at
    RE: General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

    It varies by journal.  I reversed a journal where all the lines were dated 7/1/2020 and it picked 6/23/2020 for the reversal date.  I picked another journal that was dated 5/31/2020 and it reversed on 7/8/2020, which was the current system date.  I picked a 3rd journal that was dated 5/31/2020 and it reversed it on 6/1/2020.  

    I'm sure there is some logic to the dates it's picking, but I can't determine what the logic is.  On the journal where the reversal occurred on 6/23/2020, I tried just prior to reversing that one, reversing another journal that was dated 6/23/2020 and that journal was not able to be reversed.  Is it possible the system would be picking the date of the last journal reversal that failed?  I don't know.

    All my testing is being done in a test environment where all periods are open and the journal lines all have the date & company.

    Thanks for the help!

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2024 Season 2 on at
    RE: General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

    can you please tell which date it considered?

    Above reply is as per Microsoft official doc, in case of difference you should raise a support ticket to get it confirmed.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,226 Super User 2024 Season 2 on at
    RE: General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

    Thanks for the responses MATTGUO and Saurabh.  Neither of those is the case here.  The journals have just a single date on the voucher lines and the ledger periods are open.

    Version = 10.0.10, PU 34

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2024 Season 2 on at
    RE: General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

    Hi Frank,

    1. First priority for system to take the original date as reversal in case of this is marked as yes

    2. In some cases, the period of the original transaction may be closed , so in that case mostly system picked "Current date" or " Next date available which is open in selected transactions"

  • MATTGUO Profile Picture
    MATTGUO 22,312 on at
    RE: General Journal Reverse Entire Journal - Inconsistent Reversal Date Behavior

    Hi Frank,

    Which version are you using?

    The issue happens to multiple vouchers with different date.

    There are multiple KB for different versions in LCS, please check.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,861 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,540 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans