You’re offline. This is a read only version of the page.
2,015
Hi techies,
We have a requirement where we need to migrate historical customer transactions(directly posted transactions) into AX7.
What are the best possible ways we could dump the data in?
Can anyone please suggest me a way to achieve this, thanks in advance!
*This post is locked for comments
Hi,
I would recommend that you rethink the approach of bringing historical data from a different ERP system. Trying to migrate those data can quickly become a nightmare especially when it comes to transferring things that are handled differently in AX. Also think about erroneous transactions that were somehow fixed in your old system and how you want to migrate them.
Best regards,
Ludwig
You also misunderstood as well, while have forgotten to mention that your source system is not AX. The data upgrade scripts are only for AX from a previous version, and will be released in the future. They do not support legacy systems.
It is not common at all to import such historical transactions, instead the legacy system should be available for the period until your country's legal compliance requires you to keep historical data in case of an audit. The typical implementation only brings in master data and opening transaction, that is why historical data generation is not supported.
Hi Ludwig,
Those might requires them for reporting/printing purpose and all they want in a single system i.e. in AX. Also with this there are transactions of GL, PO as well - that needs to be migrated!
Hi Sangram Shinde,
Why is the transfer of historical SO related transactions required?
I mean wouldn't it be sufficient to transfer only open/new SO?
Transferring historical data with all the related stuff is quite complex and I cannot see much value added by doing this.
Best regards,
Ludwig
Hi Ludwig - Thanks for the reply.
As of now we are analyzing it for SO and SO should include the inventory item details as well because they want to display these details on their reports. But they need to import these posted transactions as it is. We can't import them as open and then do invoice and rest process. So what would be a way to do this.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,963
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (