Migrate AR from one company to another

(0) Share

Report

Posted on by Community Member

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

All responses (3)

Answers (0)

Suggested answer

Heather Roggeveen 9,146 on at

Like (0)

Report

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 6,912 on at

Like (0)

Report

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 on at

Like (0)

Report

RE: Migrate AR from one company to another

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