Extracting GL Transaction History from Dynamics GP: SQL Guide
A SQL reference guide for extracting complete GL transaction history from Dynamics GP — covering table architecture, year-end close handling, AA dimensions, and multicurrency.
Guides for Dynamics GP — end-of-life timelines, migration to Business Central and other ERPs, and historical data retention.
A SQL reference guide for extracting complete GL transaction history from Dynamics GP — covering table architecture, year-end close handling, AA dimensions, and multicurrency.
Standard GP migration tools skip payroll. Learn how to extract UPR tables, map to new HRIS systems, and meet IRS compliance requirements.
A technical guide to migrating Dynamics GP Fixed Assets: mapping books to depreciation books, handling mid-year cutovers, and choosing between full history vs. beginning-balance-only.
A practical SQL table reference for Dynamics GP migration — covering GL, AP, AR, Inventory, SOP, POP, Payroll, DEX_ROW_ID traps, and cross-company extraction.
Technical guide to migrating Dynamics GP inventory — costing methods, serial/lot tracking tables (IV00200, IV00300), UoM schedules, pricing, and multi-location validation.
Technical guide to migrating financial data from Dynamics GP to Acumatica. Covers subaccount mapping, migration mode, API limits, and trial balance validation.
CTO-level technical guide to migrating financial data from Dynamics GP to NetSuite, covering data model mapping, API constraints, and trial balance validation.
A CTO-level guide to migrating Dynamics GP data to QuickBooks Enterprise or Online Advanced, covering segmented account mapping, API limits, and the exact ETL process.
Technical guide to migrating Dynamics GP to Sage Intacct: segment-to-dimension mapping, API rate limits, SQL extraction, and trial balance validation.
Dynamics GP 2016 loses all Microsoft support on July 14, 2026. Learn the risks of staying, the costs of upgrading to GP 18.x, and when to migrate directly.
Step-by-step guide to auditing Dynamics GP customizations — Dexterity, ISVs, custom SQL, integrations, and reporting — before migrating to Business Central.
Dynamics GP support ends Dec 2029, but SQL Server 2016 loses support in July 2026. Here's how to protect decades of financial history before the infrastructure decays.