ERP migration
Field-level mapping, validation, and rollback between Deltek Costpoint and Acumatica. We move data and schema; workflows are rebuilt natively in Acumatica.
Deltek Costpoint
Source
Acumatica
Destination
Compatibility
14 of 14
objects map 1:1 between Deltek Costpoint and Acumatica.
Complexity
BStandard
Timeline
7–14 days
Overview
Deltek Costpoint and Acumatica both handle project-based financials, but their schemas diverge significantly at the billing and compliance layers. Costpoint organizes data around contracts with embedded DCAA compliance fields, government billing rate tables, and CLIN/SLIN structures that Acumatica represents differently — Projects linked to branches, AR/AP with tax zones, and subaccounts keyed by cost type. FlitStack AI extracts Costpoint master records, transactional history, and open documents via the Costpoint REST API, transforms labor distribution rows into Acumatica labor items, maps contract billing formulas to Acumatica's Projects billing configuration, and loads GL account balances into the Chart of Accounts with subaccount masks intact. For data destined for Acumatica, FlitStack uses Acumatica OData v4 endpoints to write records and leverages Acumatica's branch-and-subaccount segmentation, ensuring that each entity's legal entity structure is preserved. Approval workflows, notification rules, and custom Costpoint Extensibility Designer screens are not portable — we export the definitions as configuration reference for manual rebuild in Acumatica's Customization Project editor. The migration runs against a scoped Acumatica API connection while your Costpoint instance stays fully operational, and a 24‑48 hour delta pickup captures any changes made during cutover.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a Deltek Costpoint object lands in Acumatica, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
Deltek Costpoint
Project / Project Header
Acumatica
Project
1:1Costpoint projects map directly to Acumatica Projects. The project description, status, start/end dates, and customer reference transfer as-is. Costpoint's project hierarchy (parent/child) maps to Acumatica's Project Template or parent project linkage. Budget amounts from Costpoint become Project Budget records in Acumatica.
Deltek Costpoint
Contract / Agreement
Acumatica
Customer + Project Billing Rule
1:1Costpoint contract records contain funding limits, award type (T&M, FP, CP), and CLIN definitions. These split into an Acumatica Customer record (for billing terms) and a Project Billing Rule configuration (for rate/schedule setup). CLIN line items from Costpoint are preserved as Project Task billing notes or custom fields on Acumatica.
Deltek Costpoint
Employee
Acumatica
Employee + Employee Class
1:1Costpoint employees transfer to Acumatica Employees with name, email, hire date, and employment status. Labor category from Costpoint maps to the Employee Class in Acumatica, which controls default billing rates and GL labor accounts. DCAA timesheet flag from Costpoint becomes a custom field on Acumatica Employee.
Deltek Costpoint
Vendor
Acumatica
Vendor
1:1Costpoint vendors migrate to Acumatica Vendors with name, address, payment terms, and 1099 flag. CAGE codes and SAM registration status are stored as custom fields in Acumatica since they have no native equivalent. EDI settings from Costpoint require manual reconfiguration in Acumatica's Vendor Details.
Deltek Costpoint
Timesheet / Time Entry
Acumatica
Time Entry
1:1Costpoint timesheet rows (employee, date, project, labor task, hours, status) map to Acumatica Time Entries linked to the corresponding Project and Task. Approval status from Costpoint is preserved as a reference flag; Acumatica approval workflows require separate configuration. Original submitted timestamps are retained for audit trail.
Deltek Costpoint
Expense Report
Acumatica
Expense Receipt + Employee Expense
1:1Costpoint expense reports with line items (date, vendor, amount, project, GL account) transfer to Acumatica Expense Receipts linked to the Project. Receipt images attached to Costpoint expense records are downloaded and reattached to the corresponding Acumatica records. Per-diem and mileage calculations from Costpoint are preserved as custom fields for reference.
Deltek Costpoint
Purchase Order
Acumatica
Purchase Order
1:1Open Costpoint POs with line items (item, quantity, unit cost, GL account, vendor) transfer to Acumatica POs. Received quantities to date are reflected in Acumatica PO receipts. Closed POs are logged as historical records in a custom table. PO approval workflows are not carried over.
Deltek Costpoint
Invoice / AR Billing
Acumatica
AR Invoice
1:1Costpoint AR invoices map to Acumatica AR Invoices with customer, invoice number, date, amount, and project reference. Line items include description, quantity, and billing amount. Retainage amounts from Costpoint are preserved as custom fields on Acumatica. Invoice templates and print formats require rebuild in Acumatica.
Deltek Costpoint
GL Account
Acumatica
Account + Subaccount
1:1Costpoint's three-way account code (Account-Org-Department) splits into Acumatica Accounts (main segment) and Subaccounts (branch/dimension segments). The Costpoint GFMORG hierarchy maps to Acumatica Branches, each representing a legal entity or cost center. FlitStack validates subaccount masks before loading to avoid dimension overflow errors.
Deltek Costpoint
AP Invoice / Voucher
Acumatica
AP Invoice
1:1Costpoint AP vouchers with vendor, invoice number, amount, and distribution lines transfer to Acumatica AP Invoices. GL distribution from Costpoint maps to the corresponding Acumatica Account + Subaccount combination. Prepaid invoices and retainage payable from Costpoint carry over as separate Acumatica AP adjustment records.
Deltek Costpoint
Billing Rate Table
Acumatica
Employee Class Billing Settings + Project Rate Matrix
1:1Costpoint billing rate tables (per employee class, labor category, and contract) translate to Acumatica Employee Class billing rates and Project-specific rate overrides. The mapping requires a rate matrix crosswalk since Costpoint rates can be contract-scoped while Acumatica rates are project-task-scoped.
Deltek Costpoint
Custom Fields (UDf)
Acumatica
Custom Fields on respective screens
1:1Costpoint user-defined fields (UDFs) added via Extensibility Designer or the UDEF screen transfer to Acumatica as custom fields on the equivalent screen. Field type translation is required: Costpoint date UDFs become Acumatica date fields, pick-list UDFs become Acumatica segmented keys or custom selectors, and numeric UDFs become Acumatica float fields.
Deltek Costpoint
Costpoint Workflow Tables
Acumatica
Not migrated
1:1Costpoint approval routing, escalation rules, and workflow states stored in internal Costpoint workflow tables have no direct Acumatica equivalent. FlitStack exports the Costpoint workflow rule definitions as a configuration document; Acumatica notification maps and approval maps are built manually from that reference.
Deltek Costpoint
Attachment / Document
Acumatica
Files / Notes on respective records
1:1Documents attached to Costpoint records (contracts, projects, invoices) are downloaded by FlitStack and reattached to the corresponding Acumatica records using the Files module. File size limits from Acumatica apply (default 25MB per file). Inline images in Costpoint notes are extracted and re-hosted.
| Deltek Costpoint | Acumatica | Compatibility | |
|---|---|---|---|
| Project / Project Header | Project1:1 | Fully supported | |
| Contract / Agreement | Customer + Project Billing Rule1:1 | Fully supported | |
| Employee | Employee + Employee Class1:1 | Fully supported | |
| Vendor | Vendor1:1 | Fully supported | |
| Timesheet / Time Entry | Time Entry1:1 | Fully supported | |
| Expense Report | Expense Receipt + Employee Expense1:1 | Fully supported | |
| Purchase Order | Purchase Order1:1 | Fully supported | |
| Invoice / AR Billing | AR Invoice1:1 | Fully supported | |
| GL Account | Account + Subaccount1:1 | Fully supported | |
| AP Invoice / Voucher | AP Invoice1:1 | Fully supported | |
| Billing Rate Table | Employee Class Billing Settings + Project Rate Matrix1:1 | Fully supported | |
| Custom Fields (UDf) | Custom Fields on respective screens1:1 | Fully supported | |
| Costpoint Workflow Tables | Not migrated1:1 | Fully supported | |
| Attachment / Document | Files / Notes on respective records1:1 | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
Deltek Costpoint gotchas
Oracle-to-SQL Server database conversion required for on-premise migrations
Gross vs. net billing method is embedded at the invoice header level
Custom fields require explicit enumeration and configuration
Workflow tables are upgrade-specific and cannot be migrated
Version parity between source and destination is mandatory for cloud migrations
Acumatica gotchas
API user licenses cap concurrent sessions and request throughput
Multi-tenant filtering requires CompanyID awareness
Custom fields require separate discovery before field mapping
Notes and attachments use a separate linked table structure
Implementation timelines frequently run 3–9 months end-to-end
Pair-specific challenges
Migration approach
Map Costpoint schema to Acumatica screen equivalents
FlitStack inventories all Costpoint modules in use — Projects, Contracts, Employees, Vendors, GL, AP, AR, Time & Expense, and any Extensibility Designer custom fields — and produces a schema mapping document that assigns each to the nearest Acumatica screen. We document the three-way account crosswalk transformation, CLIN-to-task splitting logic, and custom field type recommendations. This document is the shared reference for your Acumatica admin to pre-create branches, subaccount masks, and custom fields before any data loads.
Extract master data and transactional history via Costpoint API
Using Costpoint's REST API endpoints (Projects, Employees, Vendors, Contracts hubs) and the Integration Console bulk export, FlitStack extracts all active records and open transactions in a single pass. Historical closed records (completed projects, paid invoices older than a configurable cutoff) can be excluded or summarized based on your preference. Extensibility Designer field definitions are exported separately for the Acumatica customization reference package. Costpoint remains fully operational during this read-only extraction.
Transform data and load master records first
FlitStack applies the field mapping rules — transforming account codes into Acumatica Account + Subaccount pairs, mapping labor categories to Employee Classes, splitting CLINs into Project Tasks with custom reference fields, and translating billing rate tables into Acumatica rate matrix rows. Master records (Vendors, Employees, GL Accounts, Customers) are loaded first so that transactional records can reference them by ID. We run validation queries against Acumatica after each master load to confirm referential integrity before proceeding.
Run sample migration with field-level diff
A representative sample — typically 200–500 records across Projects, Employees, open POs, recent invoices, and time entries — migrates to a staging Acumatica company. FlitStack generates a field-level diff comparing source values against the loaded Acumatica records, highlighting any truncated subaccount codes, unmapped pick-list values, or missing vendor references. Your team reviews the diff and approves or adjusts the mapping rules before the full migration commits.
Full migration with delta pickup and rollback plan
The full transactional load runs — Projects, Contracts, Employees, Vendors, GL balances, AP/AR, POs, and time/expense entries — against the target Acumatica company. A delta-pickup window of 24–48 hours captures any new Costpoint entries created during the cutover. FlitStack generates a reconciliation summary comparing total record counts, GL trial balance totals, and open PO/invoice balances between Costpoint and Acumatica. One-click rollback is available if reconciliation fails; the audit log captures every operation for post-mortem if needed.
Platform deep dives
Deltek Costpoint
Source
Strengths
Weaknesses
Acumatica
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. 1 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across Deltek Costpoint and Acumatica.
Object compatibility
1 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
Deltek Costpoint: Not publicly documented for Costpoint specifically.
Data volume sensitivity
Deltek Costpoint doesn't expose a bulk API — REST + parallelization used for high-volume runs.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during Deltek Costpoint to Acumatica migration scoping. Not seeing yours? Book a call.
Walk through your Deltek Costpoint to Acumatica migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave Deltek Costpoint
Other ways to arrive at Acumatica
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.