web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Detailed Historical Data Migration of GL, AP, PO, Payroll, FA, Banks in AX 2012

(0) ShareShare
ReportReport
Posted on by

We have a client that needs detailed historical data migration to be carried out. We would appreciate any insight on the same.

We plan on importing most of the data using the LedgerGeneralJournalService and using a suspense account for the GL trial balance imports and then offsetting the same when importing the sub-ledgers.

We need to make sure that we are on the right track for historical Payroll imports.

We also see default DMFs for POs and Product Receipts and want to know if anyone has used these for historical data migrations and issues that anyone may have faced when carrying this out for historical data of the same.

I did see another blog by André Arnaud de Calavon about configuration settings for ledger postings an unrelated topic: https://community.dynamics.com/ax/f/33/t/129779 This got me thinking that could this be another option for posting GL trial balances and carry out a separate set of imports for AP/PO/FA/PY imports and NOT have them impact the GL, basically create the situation that Howard in the link above was trying to get out of? 

Looking forward to input / previously deployed solution strategies.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    60,284 on at

    Hi Navin,

    There are actually some tools that you can use not to invent your own bicycle :)

    technet.microsoft.com/.../hh378082.aspx

    blogs.msdn.microsoft.com/.../introducing-entity-store-for-dynamics-ax-2012-r3

    Talking about DMF it is used under the hood in entity store so you should not have any issue with export data.

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans