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) / Migrate AR from one co...
Microsoft Dynamics GP (Archived)

Migrate AR from one company to another

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are amalgamating companies and are looking to move AR from one company to another. 

What is the best way to accomplish this without re keying all of the transactions?  I am comfortable with SQL and would have no issue with scripting this out if needed, but lack the familiarity of the table structure within GP to ensure we are capturing all the right data for these transactions.    I would prefer to find a way to get the data out and then use Integration Manager to import the data into the other companies.

We are only looking at moving Open transactions and not Historical.

Any idea's are welcomed..

Thanks

Steve

*This post is locked for comments

  • Suggested answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,144 on at
    RE: Migrate AR from one company to another

    Hi

    Effectively you want to treat this as you would a new implementation.  I assume that you only want to move the open balances for the purposes of printing statements etc.  Any GL posting would be done based on posting the trial balance from the source company to the destination company.

    Based on that, a simple SmartList from Receivables Transactions to give you Document Type, Invoice Number, Date, Customer ID and Current Transaction Amount should suffice.

    If you have any open payments, add these in as Credit Memos - you don't want to update Bank Reconciliation.

    You can then use Integration Manager to import into GP and use a simple suspense account for the offset to Accounts Receivable.

    Most important, you want to ensure your posting through the General Ledger is turned off.  Because while you want to post the batch to update the AR sub-ledger, you don't want to update the General Ledger.

    Then when you find the GL batch in Financial Series Post, delete the batch.

    Cheers

    Heather

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Migrate AR from one company to another

    If only looking to use Integration Manager then you could probably use this view to give you a listing of open transactions:

    victoriayudin.com/.../sql-view-for-all-unapplied-receivables-transactions-in-dynamics-gp

    Then build the integration around that.

    If you need GL distributions, you could use a combination of the above and this one:

    victoriayudin.com/.../sql-view-with-all-gl-distributions-for-ar-transactions

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Migrate AR from one company to another

    Further to this, we are only looking at moving Open transactions and not Historical.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,492 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans