Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to reverse Posted GL journal

Posted on by 1,420

I want to reverse the posted General Ledger journal. Is there any default functionality exists in AX 2012 to do this ? 

*This post is locked for comments

  • Suren_G Profile Picture
    Suren_G 242 on at
    RE: How to reverse Posted GL journal

    Hi All,

    Could anyone please confirm whether will there be invoice lines created once after reversing a transaction.

    For example, once after reversing a voucher and navigating to the 'original document' of the reversed transaction and clicking the show button, it has only the invoice header and not the lines. Please let me know if there are any suggestions.

  • RollingStonzcrm Profile Picture
    RollingStonzcrm 2 on at
    RE: How to reverse Posted GL journal in AX 2012

    I did a GL entry to post $100 in to bank account (US OPER) offset by error account (9998) but i wanted to offset by Owners equity. So I went ahead and did a GL reversal as Jason suggested. it worked great. However, the bank account (under cash and bank) still show the balance as $100.  When I looked at the trial balance, the ledger account for US OPER shows correctly.   Is there something I am missing?

  • Suggested answer
    Jason Greene Profile Picture
    Jason Greene 35 on at
    RE: How to reverse Posted GL journal in AX 2012

    First find the Journal you want to reverse

    0574.4.png

    Go to the lines, then click on Inquiry > Voucher

    4784.2.png

    Get the Journal Number of the Journal that it wrote to the Ledger, in this case, it is ‘AA00000001’

    7418.3.png

    Go and create a new General Journal

    0574.4.png

    Go to Lines on that Journal and Click on Functions>Load Ledger Transactions

    3288.5.png

    In the Selection Criterial make sure you choose ‘Same new Voucher Number for all Vouchers’ and click on ‘Invert Sign’. Then click Select an put the Journal Number in the General Journal Selection field.

    5355.6.png

    When you click ok, it will bring in all the lines of the Journal, except it will Invert the Sign so you can post the reversing entry.

    8078.7.png

     

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: How to reverse Posted GL journal in AX 2012

    Hi Lally,

    You can find the answer in the first reply of this thread.

  • lally Profile Picture
    lally 19,790 on at
    RE: How to reverse Posted GL journal in AX 2012

    Can i know how to reverse the posted transactions of customer / vendor / bank / FA from journals ?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: How to reverse Posted GL journal in AX 2012

    Hi Tyler,

    The original question was around two yesrs old. It is then better to create a new thread. Then you can also mark your question as answered.

    To give an answer on your question: On a transaction reversal there is no workflow in standard AX. As the transaction reversal creates new transactions you might also consider to not use the reversal but create a new journal. Then you have the workflow. Side effect is that the reversal tracing is not available then.

  • Tyler Barron Profile Picture
    Tyler Barron on at
    RE: How to reverse Posted GL journal in AX 2012

    Pranav,

    Is there any additional approvals you can set on transaction reversals?   We have strict approval processes in place for posting to the GL and it seems the transaction reversal has no available approval.   Is this true?  

  • Pranav Kumar Profile Picture
    Pranav Kumar on at
    Re: How to reverse Posted GL journal in AX 2012

    Hi Fayaz,

    The limitation are like you cannot reverse posted payment through wire, check payment can't be reversed from vendor transaction. If taxes has been posted, than that ledger entry can't be reversed.

    From my lst post, i meant that some transaction needs to be reversed manually. For example, Wire transactions are not reversed and it gives error message. End user asks that should be reversed but logically wire transactions are never reversed in real scenarios.

    So AX is designed like that. Let me know if you have more queries.

    Pranav...

  • Fayaz Ahamed Profile Picture
    Fayaz Ahamed 1,420 on at
    Re: How to reverse Posted GL journal in AX 2012

    Thanks pranav. What is the limitation here? what kind of transactions cannot be reversed? pl clarify

  • Pranav Kumar Profile Picture
    Pranav Kumar on at
    Re: How to reverse Posted GL journal in AX 2012

    Hi,

    There is no such functionality to reverse complete journal. However, you can reverse posted vouchers. To do that, select the ledger and click on Transaction. Select the desired transaction and click on reverse transaction button. Please note that not all transaction can be reversed using Reverse transaction button.

    Pranav...

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans