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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How do you move transa...
Microsoft Dynamics GP (Archived)

How do you move transactions from one GP account to another? Wrong accounts merged in GP, trying to reverse the merge.

(0) ShareShare
ReportReport
Posted on by PetoniumTKC 500

Morning,

I am trying to move transactions (INV and PMT) from one account to another account in GP. I merged two accounts which should not have been merged, and need to take a few transactions from one account and put it back to its original account. Can this be done through interface of GP Dynamics?

Thanks in advance!

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    You would do a reversing entry from the wrong account back to the original account. Pay attention to the reversing date and make sure it will occur in the correct fiscal period. You will need to recreate the account the account that was merged, first.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Can't be done via the interface, unless you void the original transactions and repost them.  It could be done in SQL by changing the distribution accounts in the payables tables and the GL table.

  • PetoniumTKC Profile Picture
    PetoniumTKC 500 on at

    Thanks Frank, could you shed any light on the scripts for SQL to do this at all? As I mentioned, Im trying to take transactions out of an incorrect merge of two accounts and re-make the original two accounts. I.e. Merged A and B (AB), now want to go back to just A...and....B.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Frank, why can't this be done inside GP?  If you do a ledger entry back to the original account that was accidentally deleted it would reduce the balance of the account that remained and then increase the balance of the account that was deleted. Now if you want no trace of these transactions that running scripts would be the way. You would need to know the ACTINDX of the account that was deleted and then find all the records via the DEX_ROW_ID value and switch them back to what they were. If a backup exists of the database prior to the merge it would make this process fairly simple.

  • PetoniumTKC Profile Picture
    PetoniumTKC 500 on at

    I just had a look in test, both accounts exist as they were. One account (which was merged into the other) contains the majority of transactions, the account it was merged into only has one INV and PMT. Can I ask on the process to fix this and how to find ACTINDX and DEX_ROW_ID?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    You can find the ACTINDX value from either GL00100 or GL00105.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    You're right Richard, you could do a journal entry to correct the balances.  I was coming at it from the perspective of being able to drill from the originating transaction to the correct GL account.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Frank, sorry we did not get a chance to meet at Convergence. The lousy weather on Monday cancelled my flight and I did not get it until late Tuesday and then we had a funeral to get back to so I left on Friday.

  • PetoniumTKC Profile Picture
    PetoniumTKC 500 on at

    I've only done small stuff in SQL with deleting data from columns for merging creditors. Can anyone guide me through a process to move these transactions at all? Thanks guys any help much appreciated.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    First, you need to know the ACTINDX of the GL account that remained and the ACTINDX of the account that was merged. Then you will need to update records in the GL20000 and GL30000 tables. How many journal entries are we talking about here. If it is only a few, I would start by adding the GL account number back in and then get the ACTINDX value for that account. You could then do J/E for the transactions that need to be switched back. Now if you can restore from backup to a TEST company we could find all the old transactions using the old ACTINDX value and then update your production database. Now whatever you wind up doing make sure you do this after hours and after making a backup. If you can tell me the names of your production database and test database I could come up with something. After you split them you will need to run GL reconcile on all your years, both open and historical. Now this is highly irregular and I make no guarantees but it should work. This also assume the merging tool did not delete the original records and all it did what change the value of the ACTINDX field in the GL20000 and GL30000 tables.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans