Skip to content

Sales kit for resellers

Import Export PowerTool sales kit

Bulk import, export, update, and delete data in effectively any Business Central table. Everything you need to qualify, demo, and quote it.

The pitch

Import Export PowerTool moves data into, out of, and around Microsoft Dynamics 365 Business Central with bulk import, export, update, and delete operations. This is a completely free app from Insight Works for Business Central. It works on effectively any table and stays within each user's existing Business Central permissions.

Who it is for

Consultants, integrators, and developers handling data migration and cleanup in Business Central online. Administrators control who can reach update, delete, and protected tables.

Selling points

  • Many tables, one file. It reads and writes plain text files that can carry many tables in one file, with no Excel dependency. Existing RapidStart configuration package definitions can be reused as export templates.
  • Rerun only what failed. Imports can commit per table, so an error in a later table does not force a full reimport.
  • Update and delete with a preview. Update and Delete apply a value to, or remove, a filtered set of records, including non-editable fields and protected tables. A preview shows which records a filter will affect.
  • Ledger tables supported. It can write to protected ledger tables such as item ledger entries and customer ledger entries. General ledger entries are supported in the latest release.
  • Access under control. Two permission sets separate managers, who can change setup, from users, who cannot. The app never grants more than a user's existing Business Central table permissions.
  • Opening inventory with tracking. Item journal imports create lot and serial number entries automatically. Record links and record notes can be exported and imported, so legacy notes carry across.
  • Licensing. It needs no Insight Works license or subscription and has no limit on users on Business Central online (cloud). Each user needs a full user or Team Member license on the Essentials or Premium tier.

Qualify the opportunity

Fit-gap questions to ask before a demo. The answers tell you whether Import Export PowerTool fits, and what to show.

  1. Are you using Microsoft Dynamics 365 Business Central online today, or moving to it from another system? If another, which one?
  2. How much data do you need to migrate, and from how many tables?
  3. How do you import data into Business Central today, and how long does a rerun take after a fix?
  4. Do you already have RapidStart configuration packages you want to reuse?
  5. Do you need to load opening inventory for items tracked by lot or serial number?
  6. Do you need to bring notes and record links across from a legacy system?
  7. How do you fix a wrong value across hundreds of records today?
  8. Do you need to correct fields or tables that Business Central does not let users edit?
  9. Do you need to import into ledger entry tables, such as item or customer ledger entries?
  10. Who should be allowed to update or delete data, and who should only import and export?

Licensing at a glance

Business Central
Business Central online
Insight Works license
Free, no user limit
Business Central license
Full user or Team Member license (Essentials or Premium tier)
Languages
English
Availability
All countries where Business Central is available

Current requirements for every app are in the licensing FAQ. For prices, request the price list.

Files

Help with a Import Export PowerTool opportunity

  • Melonie Wood, Partner Success Manager, Insight Works

    Melonie Wood

    Partner Success, North America and global

    Pre-sales meetings, pricing questions, implementation guidance, and connecting you with the right technical people.

    Message Melonie →
  • Erik Garstad, Product Consultant, Insight Works

    Erik Garstad

    Product Consultant

    Pre-sales meetings, pricing questions, implementation guidance, and onboarding for European partners.

    Message Erik →
  • Brian Neufeld, Director of Marketing, Insight Works

    Brian Neufeld

    Marketing

    Co-marketing, your reseller listing, webinars, and content for your campaigns.

    Message Brian →