| > | | | | Great Plains by entering beginning balances to |
| If you are on the data export from legacy | | | | each GL account in one General Ledger |
| accounting system, data massage in Excel or SQL | | | | transaction, review and post it on the day of the |
| Server, and data conversion/migration to | | | | first date in the new fiscal period. Preferred way |
| Microsoft Dynamics GP, we would like to give you | | | | it to start GP in production on January 1st, or |
| some technical recommendations, based on our | | | | whatever is your first day of your Corporate ERP |
| 15 years Great Plains Consulting practice. | | | | fiscal year |
| Plus, in our opinion data conversion | | | | |
| recommendations or say stronger principles are | | | | 3. Open AR, AP. We recommend you |
| applicable to other ERP and MRP systems: | | | | to import via Integration Manager unpaid AR and |
| | | | | AP, then post them and wait for payments to be |
| 1. Master records migration. This is | | | | issued (AP) or received (AR and SOP) |
| likely the required step, where you move your GP | | | | |
| Chart of Accounts, Customers, Inventory Items, | | | | 4. Historical Data Conversion. We |
| Bills of Materials, Vendors, Employees, etc. In GP | | | | recommend you to consider avoiding it and |
| these are so-called master records. The simplest | | | | instead keep legacy accounting open for inquiries. |
| way is Dynamics GP Integration Manager. If you | | | | If this is absolutely impossible, consider creating |
| only need GL accounts, you could try direct SQL | | | | historical company in GP, closed for new |
| Insert into GL00100 and then run Check Links on | | | | transactions and then move historical records |
| Account Master tables cluster. In all other cases | | | | there, here you can use SQL Insert statement. |
| we do not recommend direct SQL insert, as it is | | | | Please, never run check links in this historical |
| not guaranteed that business logic required | | | | company, as your historical data migration will |
| dependencies will be restored by Check Links | | | | likely be inconsistent, but good for querying. |
| routine | | | | Another way, which might be taken — |
| | | | | import all your historical transactions via |
| 2. Beginning Balances. When you are | | | | Integration Manager and then post them by |
| done with master records migration, we | | | | historical dates. The pitfalls of this approach |
| recommend you to keep historical transactions | | | | might be the problems with historical data export |
| lookup in your old accounting system: Peach Tree, | | | | quality and IM performance |
| MYOB, QuickBooks, or whatever it was. In this | | | | |
| case, you launch New Year or new fiscal period in | | | | 5. |