We are currently on V8.03 and are moving to E10.1. Originally the need was just to get off of the old servers that V8 is running on (a Win Server 2003 box). The plan was to export select data from V8, do some minor translations, and import into E10 via DMT. The translations were going to be to bring some things in line with our new parents companies accounting systems. Translations were just going to be to : CustID’s, SupplierID’s, Product Groups, Part Numbers, and GL Acct’s.
But someone in Finance threw a monkey wrench into the plan (it’s always Finance, isn’t it? ). And now we’re going to do this as two stages.
Stage 1 is just to get off the old box and onto E10. No translations will be done, just exporting data from V8 for import into E10. I did convince them only migrate relevant data Ex: only customers with an order in the last two 2 years, recently used suppliers, recently used parts, etc…)
The plan is to make BAQ’s to run in V8, to create the CSV files for import into E10. Looks like there is 109 “entries” in DMT (using the Migration menu). I’ll only need about 60 of them - we don’t use It much beyond Sales, Parts, Jobs (mtls only, no labor, operations or scheduling), AR and AP. And only the basics of those.
Anyone see any major flaws with this technique, or know of a better one?
One thing I’ve already found, is that the DMT into E10 uses CustID’s and not CustNum’s. So every BAQ will have to export CustID in place of CustNum. I assume SupplierID’s are the same. Any others like this?
BTW - There is WAY to much garbage in V8 to just have Epicor convert it to E10. We already made that mistake when we went from Vista 4 to V8.