Skip to content

Data Migration

Data Migration supports controlled onboarding of existing records and balances into Pinkapple ERP. It is intended for administrators and implementation teams, not for normal day-to-day corrections after go-live.

Use migration screens only when moving an organisation from previous records, spreadsheets, another system, or an opening-balance exercise into Pinkapple ERP.

Workspace Reference

WorkspaceHow Users Reach ItWhat Users Usually Do There
Data MigrationAdministration -> General Setup -> Data MigrationReview migration state, load migration batches, manage catch-up activity, and confirm go-live readiness.
Import EnginePlatform import workspaces where availableValidate and submit structured import files for supported records.
Accounting, Loans, Deposits, Shares, Wallets, Inventory, And Other Service WorkspacesService-specific setup and operations screensReconcile migrated records against live module views before go-live.
ReportingReporting and Accounting reportsCompare imported balances with approved source records and sign-off totals.

What Data Migration Helps Manage

Data Migration helps administrators manage:

  • Migration readiness.
  • Migration batches.
  • Imported balances or records.
  • Catch-up activity.
  • Reconciliation checks.
  • Trial balance or balance sheet comparisons where applicable.
  • Final readiness before users begin live operations.

Migration Overview

The overview area is used to check the migration state and determine whether the tenant is still in migration mode, ready for catch-up, or ready for live use.

Use this area to confirm that migration work is deliberate and controlled before users begin normal operations.

Typical migration step order is:

  • Clients.
  • Shares.
  • Deposits.
  • Loans.
  • Inventory opening stock.
  • TB / BS.
  • Reconciliation.
  • Catch-up.
  • Lock or go-live completion.

Inventory Opening Stock

Use the Opening Stock migration step when the organisation must load opening warehouse stock balances as of the migration date.

This flow is intended for:

  • approved opening stock snapshots
  • stock imported from spreadsheets or a previous system
  • one-time migration of starting inventory value and quantity

It is not intended for normal receipts after go-live.

For the detailed warehouse-specific import flow, see Inventory Opening Stock Migration.

Migration Batches

Migration batches group imported records or balances so they can be reviewed, validated, and reconciled together.

Good batch practice:

  • Keep batches focused by module or migration stage.
  • Use clear descriptions.
  • Review validation results before accepting a batch.
  • Do not mix unrelated records in one batch if it makes reconciliation harder.

Catch-Up Activity

Catch-up activity is used when operational movement must be brought forward from the migration snapshot date to the go-live position.

Use catch-up carefully. It should bridge the migration period, not replace normal transaction processing after go-live.

Reconciliation

Migration reconciliation checks whether imported balances and records agree with the approved source records. Review differences before allowing users to rely on the migrated data.

Common reconciliation checks include:

  • Opening balances.
  • Customer or member balances.
  • Loan, deposit, share, wallet, stock, and accounting totals where applicable.
  • Trial balance and balance sheet comparisons.
  • Exceptions that need correction or sign-off.

Go-Live Readiness

Before go-live, confirm:

  • Required migration batches are loaded.
  • Validation exceptions are resolved or approved.
  • Reconciliation differences are understood.
  • Opening balances agree with signed-off records.
  • Users understand when migration mode ends and normal processing begins.

Common Mistakes

  • Using migration screens to correct live operational mistakes.
  • Importing balances without reconciling totals.
  • Mixing test and approved migration data.
  • Running catch-up without agreeing the snapshot date.
  • Allowing users to transact before migration differences are resolved.

Good Practice

Treat migration as a controlled implementation phase. After go-live, process corrections through the relevant business module so approvals, audit history, and financial effects remain clear.

Pinkapple ERP by Stat Solutions Network