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) / Migration from Sage MA...
Microsoft Dynamics GP (Archived)

Migration from Sage MAS 500 to GP 10

(0) ShareShare
ReportReport
Posted on by Ron McVciar 1,005

What tools are people using? What works?

Just Master files or Transactions also? (e.g., Sales, Cash Receipts, GL Transactions, etc.)

MS Migration Tools for Dynamics GP?

Data Junciton or other Tools?

What tools are the bes bang for the buck?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Honest opinion is Excel and Integration Manager!

    If there is a large amount of data in Sage, you will want to export and check for problems / reconcile before you import into GP. Also, you might want to tidy up ID fields - debtor / creditor / inventory ID's...and you will probably revisit your chart of accounts - new chart of accounts mens mapping transactional data from the old chart to the new chart.

    Excel really is the best for all of this. Integration Manager for conversions comes with a new install of GP (there is a time limit on using it though). Using IM to import the data means your import obeys the basic GP business logic.

    In terms of bang for your buck...you probalby already have Excel, and as I said IM for conversions comes with new installs of GP.

    For data imports not covered in IM, or if you are importing into modified windows, you could write a macro...which again must obey the basic GP business logic or it will fail. Net effect is 'good' data in GP to start off with. You can write a macro in Qbasic from scratch or use mail merge in word to create the macro.

    Thats my opinion anyway...others might have different views.

    Hope this helps.

  • Ron McVciar Profile Picture
    Ron McVciar 1,005 on at

    Ian,

    Thanks for the feedback. Just at times the transaction level of the IM tool seems to be much more complicated then it needs to be especially for Invoice Transactions and Payment applications (Cash Receipts). It seems as though the stock connector samples don't always work out of the box. (Ok I like easy).

     A McVicar sends his thank, really. Blessings and a great day.

  • Community Member Profile Picture
    Community Member on at

    Yeah, I hear you...A lot of the required values in IM however can be defaulted...or a constant inserted. Bit of work I know, but once you get it working it is a peach. You can have all of your imports set up and tested in advance, and when the big day comes, you just export the latest data from Sage..get it into the required format and run IM.

    Are you doing the conversion anytime soon?

  • Ron McVciar Profile Picture
    Ron McVciar 1,005 on at

    Yes, and we will be doing them forever? I'll let you know how it goes. That is of course I do not ge distracted.

  • Community Member Profile Picture
    Community Member on at

    Is this a one time migration? - or will you be doing regular integrations from sage? If regular, you should really look at eConnect. Far better error handling, more robust, and less management time required once the integrations are set up.

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