Data Migration to Microsoft Dynamics Axapta 4.0 / any tier 1 EPR

[mohta...@gmail.com]

With historical financial and open transactions:
1. Have an accurate mapping of Ax COA and legacy financial system.
2. Take up an accurate & stern cut off date.
3. Simulate posting in Ax for all historical transactions (financials)
a. Cross check ledger balances only & not the Balance Sheet as the
mapping may be different viz. before Ax inventory may be expensed out
but after mapping they may be taken to Assets.
4. For opening balances: (Financials)
a. Method 1: Use Ax closing sheet (on the cut off date) and close the
year.
i. In case of any corrections, post the corrections in a correction
journal.
b. Method 2: Use General Journal to post the openings on the next day.
i. n case of any corrections, reverse the opening journal, copy the
same to new journal, rectify the balances and post the same.
5. For opening balances: (Inventory)
a. Map the items to their receipts accounts via the item groups and
post the Inventory Movement journal to load the physical & financial
inventory. The offset for the inventory movement journal has to be
decided based upon whether the inventory would be an Asset or an
Expense.
6. For open transactions:
i. Method 1: Use big bang approach and bring the open transactions to
Axapta.
ii. Method 2: Zero open transactions.
1. For accurate financial reporting, create the open entries in Axapta
(manually/automatically) post the cut off date and then proceed (The
most recommended approach).
2. Allow the open transactions to be proceeded in the legacy system as
normal while the related entries to be posted in Axapta as well
(Requires customizations and the complexity depends on the financial
needs of the client.)