Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Paid transaction removal-can it be reversed?

Posted on by 70
One of my employees entered in the wrong date when running the paid transaction removal.  Is there any way to reverse that process?  He entered in a date in the future and now all transactions are moved to history. 
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,830 Super User 2024 Season 2 on at
    Re: Re: Re: Re: Re: Paid transaction removal-can it be reversed?

    I agree with Sr. Gomez.  In fact, he and I have worked together to move Historical purchase orders back to open at one client.  As he states, you just need good knowledge of GP architecture and the ability to write SQL scripts.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Paid transaction removal-can it be reversed?

    I agree with the first point, however I have to disagree with the others - Any Microsoft Dynamics Partner worth their salt would be able to assist with issues like this, it is not the exclusive domain of MBS Prof. Services. Especially if a module exists in the professional services tools library that could assist.

    There is always a way to get back from mistakes that users make. It might be complicated and very involved, but its always possible once you understand the underlying tables and business logic.

     

    Best regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Paid transaction removal-can it be reversed?

    The bottomline is

    1. Never ever run the Utilities without taking Backups

    2. Paid Transaction Removal once done cannot be rolled back

    3. If You need assistance in reverting it back, It is highly recommended to go to MBS Professional Services.

  • HRP Expert Profile Picture
    HRP Expert 40 on at
    Re: Paid transaction removal-can it be reversed?

    Integrity Data, Inc. has a Dynamics GP enhancement product that may be beneficial to you. To learn more about them you can visit their website at www.integrity-data.com.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Paid transaction removal-can it be reversed?

    Well spotted Callen. Certainly seems like it would do the job!

    Ian.

  • callen Profile Picture
    callen 4,595 on at
    Re: Re: Re: Paid transaction removal-can it be reversed?

    Even though it's meant for one purpose, you could probably use the tool for your purpose.

    The software is on the GP DVD and should work against the Fabrikam company.

  • callen Profile Picture
    callen 4,595 on at
    Re: Re: Paid transaction removal-can it be reversed?

    There is a module from GP to bring back historical items. It's part of the Professional Services Tools Library.

    Here's the description.

    Receivables Management Transaction Unapply ($750)

    Unapply documents in the history table and automatically move the records back to the open table, allowing you to reapply the records as needed. This is a good alternative to removing history and re-keying data if the records are applied incorrectly.

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Paid transaction removal-can it be reversed?

    Callan is right...it certainly wouldn't be fun. Can you restore from a backup? - Even if you had to re-enter a few hours of data it would be preferable to undoing it though SQL. 

    You could also leave it as is...its probably only going to be a problem if you made a mistake in an apply - and the documents are now in history. You could deal with these issues one by one? It would have to be a manual process - entering new transactions etc.

    Are you keeping history? ie are the transactions now marked as Historical or removed completely from the system.

    Best regards,

  • callen Profile Picture
    callen 4,595 on at
    Re: Paid transaction removal-can it be reversed?

    Unfortunately, there's no way through GP to reverse the action.

    It should be possible using SQL queries but it certainly won't be fun.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans