Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Ledger transaction cannot be reversed

(0) ShareShare
ReportReport
Posted on by 1,260

Hi,

We have an issue where we have extra sales for some stores for the 25th November. Is there a way to reverse these SO's that contain the extra sales. Below is an example of how these sales looks when viewing them from the AR.

rev.JPG

When I click on the reverse transaction button on the action pane I get following error:

"The ledger transaction type Sales order revenue for account 24000 cannot be reversed"

*This post is locked for comments

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at
    RE: Ledger transaction cannot be reversed

    Thanks Ludwig :)

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Ledger transaction cannot be reversed

    Hi D_Meethu,

    Creating a reverse sales order sounds ok to get this fixed. Yet, please keep track if this issue occurs again in the future.

    All the best,

    Ludwig

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at
    RE: Ledger transaction cannot be reversed

    Ludwig,

    This is a duplicate transactions - I am not sue of the root cause. As I check in the Retail Transactions for this record, there was no record, no invoice record, no SO record - nothing.

    As of now I created a reverse sales order transactions for the same with negative amount... Should I have done something different, already spoke to the department but no clue we are comparatively new to AX.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Ledger transaction cannot be reversed

    Hi D_Meethu,

    Regarding your last two comments:

    1) You can make the balance 0.00 easily by recording a customer payment that you settle against this open Position of 3342.89. When doing that you have to clarify the offset account that shall be used. Should it be a bank account, a ledger transfer/correction account or something alike, etc.

    2) Before trying to do no. 1) I still do not get what's wrong here as I can identify two sales order invoice lines and one payment for the first invoice above. (ingoring the penny difference posting). So, my recommendation would be to consult somebody from your accounting department before you are doing the correction.

    Hope this helps.

    Would be great if you could Keep us updated how things are going and if some additional help is required.

    Many thanks and best regards,

    Ludwig

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at
    RE: Reverse transactions in AX 2012 R3

    Ludwig,

    Is there a way I can make the balance 0.00 instead of 3342.89?

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at
    RE: Reverse transactions in AX 2012 R3

    Ludwig,

    If you check in the screen shot where there is invoice number INV-308844 is coming after posting the transactions for the end of day. Whereas the other error invoice number INV-308727 does not have any transactions or any detail for the same record.

    If I really have to check if this is a correct sales transactions how will I check?

    There is no SO record, no transaction, no Invoice number.

    If it really a large sales order, then how can I make the balance value 0.00?

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Reverse transactions in AX 2012 R3

    Hi D_Meethu R,

    Before you do a correction you need to identify the root cause of the problem. I did not get this from the information provided.

    Why is the difference large and what difference do you refer to?

    Does a large difference by itself indicate that there is something wrong?

    Can't this simply be caused by the size of the order, the item costs or something alike?

    Ludwig

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at
    RE: Reverse transactions in AX 2012 R3

    Hi Ludwig,

    When I run the customer aging report there are stores that affected by this. Also, we have a customized report which shows the expected sales and DAX sales - the difference is large and most likely incorrect overages.

    What steps can I take to correct the transactions?

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Reverse transactions in AX 2012 R3

    Hi D_Meethu,

    There is no real guideline available for a manual correction as there might be numerous reasons why things might have gone wrong.

    What is the underlying reason that you want to correct this SO invoice?

    Ludwig

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at
    RE: Reverse transactions in AX 2012 R3

    Hi Ludwig,

    Do we have any documentation for the steps (as none of the online doc were helpful till now) or can you dot me the steps I can follow to correct the transactions?

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Kempeth Profile Picture

Kempeth 4

#1
Andy Adamak Profile Picture

Andy Adamak 4

#1
Community Member Profile Picture

Community Member 4

Featured topics

Product updates

Dynamics 365 release plans