Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Converting historical ...
Microsoft Dynamics GP (Archived)

Converting historical transactions

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

I am investigating the possibility of converting historical purchasing transactions for an upcoming project, specifically historical purchase orders.


I know this is not the norm, and I know it's going to add a significant number of hours to the project but the client is asking for nonetheless.

That said, has anyone ever done something like this, and do you know what it entails? The only solution I can think of is to use integration manager to convert all historical PO's first as open purchase orders, turn off posting, then go through the normal receipt process and eventually end up closing all of the PO's and using the Remove Completed Purchase Orders utility to get them into history. Is there an easier way to do this? I'm also considering bringing in a third party to do this part of the work. Any suggestions are greatly appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Converting historical transactions

    Frank, that's really nice of you. Would you mind sending them to me? My email address is mscalamogna@sdcpa.com

    Thanks!

    Mike

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Converting historical transactions

    Michael, I have templates to use Table Import for importing BOMs.  Send me an email and I'll send them to you if you want to go that way.  the downfall is you have to manually validate the data prior to importing it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Converting historical transactions

    Thanks everybody! I am familiar with the willoware products, and actually suggested using the BOMImport tool for this client. Redbeard - your blog is awesome. Do you have any experience converting Bills of Material? Is a macro the best way without buying a gui tool like BOMImport or a full blown integration tool like smartconnect/scribe?

    The SSRS report was something that I suggested to my managers as an alternative to migrating all of this data into GP and they seemed to like that idea. After talking, we're going to do something a la Frank's suggestion with SQL, which is why I'm marking his answer as verified.

    Bill Campbell and Redbeard, thank you very much for your help! I really appreciate it!.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Converting historical transactions

    Michael,

    Willoware.com has a really cool EZImport tool, which makes it possible to import historical transactions without many of the requirements, which typically increase the complexity and expense of such a project.

    willoware.com/.../ezimport

  • Verified answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Converting historical transactions

    I've been involved with more than 1 project where, partially through the migration of historical transactions, we gave up because of the number of hours expended.  I guarantee you, it's a budget-buster.  A better solution is to dump the historical data into a SQL table or tables and report off it using SSRS, if the customer insists on not keeping the old system alive.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Converting historical transactions

    I would agree with Frank - trying to import "historical" data for the sake of having all the old data in the new system is the source of great many problems.

    I have tried to do this in the past and after a number of hours of trying, we did as Frank suggested, and got the client to buy into the idea of keeping the old system alive for use of historical.

    We used the OPEN Transactions as a means of training the staff on the new system.  After about 2 months of running the new system, the users stopped accessing the old system and really never went back.  They used the printed copy of posting documents that they had printed out of the old system.

    So in the long run, they really never did need the historical data and were very pleased not to having imported all that old data.

    Anyway, our experience.

    Talk soon, take care.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Converting historical transactions

    It is unusual and I would be pushing back HARD on migrating historical POs and SOs because it is going to cause all kinds of grief reconciling in the new system.  I'm assuming you are going to have to migrate PO receipts, invoices, AP invoices, Sales orders, invoices, cash receipts, etc.  Is this correct?  If so, migrating all that will be a nightmare because you are correct, you'll have to import all the detail as open documents, post them, apply payments, so on and so on.  It would be much better if they keep Macola alive for awhile to use for historical reference.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Converting historical transactions

    Frank and Bill: Yes, we are migrating from Macola to GP. We have an ex-Macola consultant on staff who knows the data structure and can get the information out of Macola.

    We typically don't include the migration of historical transactions in the project scope, and I've honestly never done this before.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Converting historical transactions

    From you posted here I believe I now understand that you are migrating from 'an old' system to a new system?  Is that correct.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Converting historical transactions

    Mike, what system are you importing migrating from?  How many years of history?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans