Dynamics GP exit assessment: what the data is, what will break, and how long the move takes.
3 issues block the import: duplicate customer names under different ids; items with a zero standard cost; items with no unit of measure.
| GP table | Business Central equivalent | Rows |
|---|---|---|
OP10200 | — | 7,000 |
SOP10100 | Sales Header | 3,000 |
OP10110 | — | 2,009 |
OP10100 | — | 800 |
IV00101 | Item | 400 |
GL00100 | G/L Account | 160 |
PM00200 | Vendor | 80 |
PR00100 | — | 64 |
RM00101 | Customer | 50 |
SY40100 | Accounting Period | 36 |
Every item below was counted from the exports, not estimated. Severity reflects whether it blocks the import or corrupts a number after it.
12 names appear more than once, 50 records total. Example: 'Harbor Supply' exists as 10000, 10001, 10002.
Do this: Decide one surviving ID per name before import, or the duplicate logic moves with you.
20 of 50 customers have a blank state (40.0%). Business Central will reject the address on import unless a state or region is supplied.
Do this: Backfill from the billing address or set a default by country.
34 customers carry a non-zero balance and have not transacted in over 365 days ($392,942.28 total).
Do this: Decide write-off versus opening balance before cutover, not after.
31 of 400 items (7.8%) have no standard cost. Every one becomes a margin error in the new system on the first sale.
Do this: Recompute from purchase history or last landed cost; do not import at zero.
13 items have a blank UOFM. Business Central requires a base unit of measure on every item; the import will fail at the first of them.
Do this: Default to EA, then correct the exceptions by item class.
Four files are written alongside this report, shaped for Business Central's configuration packages:
| File | Rows |
|---|---|
| customers_bc.csv | 50 |
| vendors_bc.csv | 80 |
| items_bc.csv | 400 |
| gl_accounts_bc.csv | 0 |