Ana içeriğe atla
Ürün ayrıntıları İngilizce olarak görüntülenir. Çeviriler yakında gelecek.
Mass Data Edit & Excel Round-Trip for Business Central — Bulk-edit BC records via Excel export and validated re-import — fast — 1/1Örnek önizleme

Bulk-edit BC records via Excel export and validated re-import

— fast price updates, master-data cleanup, and reposting, with change preview and rollback. Built and installed by

ECOSIRE as a per-tenant extension.

Mass Data Edit & Excel Round-Trip for Business Central nedir?

Bulk-edit BC records via Excel export and validated re-import — fast price updates, master-data cleanup, and reposting, with change preview and rollback. Built and installed by ECOSIRE as a per-tenant extension. Built to order by ECOSIRE for Dynamics 365 BC (build-to-order) — indicative price from $999.00 USD; request a quote for a scoped proposal.

Temel Özellikler

Export any Business Central list (Items, Customers, Vendors, prices, dimensions, or custom tables) to a structured Excel edit sheet via page-extension actions
Validated bulk re-import that runs the same AL field validation, table relations, and posting-group checks as the standard BC card — no silent corruption
Mass field-update rules: apply a value, find/replace, percentage/factor math (e.g. raise all prices by 8%), or conditional updates across thousands of rows
Reusable template library so recurring jobs (price updates, master-data cleanup) use a saved, pre-mapped column layout
Change preview before commit: a row-by-row old-value → new-value diff on a staging table, approved before anything is written
Rollback of a committed batch, including reversal of posted entries where applicable
Permission-set integration so mass-edit and import rights are granted only to authorized roles
Job Queue offloading for large imports so big updates run in the background without blocking users
Built on the BC OData/REST API and Excel interop for reliable two-way round-trips in both cloud SaaS and on-prem environments
Detailed import log capturing who changed what, when, and which rows were rejected and why
Per-tenant extension install — clean upgrades, no source-code modification of base BC objects
Optional Power Platform / Dataverse hooks so edit sheets can also be driven from a Power Automate flow

Siparişe özel, sizin için baştan sona

Kendiniz kurmanıza gerek yok — ECOSIRE tarafından geliştirilen, kurulan ve desteklenen çalışır bir uygulama.

  1. 1

    Sipariş verirsiniz

    Tek seferlik geliştirme fiyatıyla başlayın. Kapsamı başlangıçta sizinle birlikte belirleriz.

  2. 2

    Geliştirir ve kurarız

    ECOSIRE, Dynamics 365 Business Central ortamınızda geliştirir, yapılandırır ve kurar.

  3. 3

    Yayına alma + destek

    Yaklaşık bir iş haftasında yayına alırsınız; canlıya geçiş sonrası iki hafta destek dahildir. Teslim ettiğimiz koddaki hatalar ücretsiz düzeltilir.

Bu Ürün Hakkında

Editing hundreds or thousands of records one card at a time is the quiet tax on every Business Central rollout. Mass Data Edit & Excel Round-Trip removes it. ECOSIRE builds you a per-tenant AL extension that lets authorized users export any BC list to Excel, edit in the tool everyone already knows, then re-import through a validation engine that runs the same AL field validation, table relations, and permission checks as the standard BC pages — so a bad import can't silently corrupt your data.

This is build-to-order software, not an instant AppSource download. You buy the build; ECOSIRE develops the extension against your tables and pages (Items, Customers, Vendors, Resources, dimensions, prices, or your own custom tables), installs it as a per-tenant extension on your Business Central environment (cloud SaaS or on-prem), and supports it afterward. We scope the exact lists, field rules, and permission sets with you before a line of AL is written.

Under the hood it uses page extensions to add "Export to Edit Sheet" and "Import Changes" actions, the BC OData/REST layer and Microsoft.Office.Excel interop for structured round-trips, event subscribers to enforce validation, and a staging table so every batch gets a change preview (old value → new value, per row) before commit and a rollback if a posted batch needs reversing. Heavy imports can run through the Job Queue so large updates don't block users.

Typical jobs it eliminates: quarterly price-list updates, master-data cleanup after a migration, bulk dimension or posting-group corrections, and re-tagging records before a reposting run. Permission sets keep mass-edit rights with the people who should have them.

Ne elde edeceksin

  • A per-tenant Business Central AL extension built to your scoped list of tables, fields, and validation rules
  • Installation and activation on your BC environment (cloud SaaS or on-prem) by ECOSIRE
  • Configured permission sets controlling who can export, edit, and import
  • A starter template library covering your priority recurring jobs (e.g. price updates, master-data cleanup)
  • Admin and end-user documentation plus a short handover walkthrough
  • Source AL code and the extension package (.app) handed to you, with a post-delivery support and update window

Bu kimin için

BC Finance / Pricing Manager

Runs quarterly price-list and posting-group updates across thousands of items and needs them done in minutes with a preview and rollback, not days of manual card edits.

ERP Administrator / BC Functional Consultant

Owns master data after a go-live or migration and needs a safe, validated way to clean up duplicate, mistyped, or mis-dimensioned records in bulk without writing one-off SQL or AL each time.

Operations / Inventory Lead

Frequently re-tags, re-categorizes, or corrects large batches of items, customers, or vendors and wants self-service bulk edits scoped to their permission set, without raising a ticket for every change.

Mass Data Edit & Excel Round-Trip for Business Central Nasıl Karşılaştırılır

KriterECOSIREÖzel YapıRakipDynamics 365 Business Central Yerleşik
Two-way Excel round-trip with AL-level validation on re-importDahilKısmi destekKısmi destekKısmi destek
Pre-commit row-by-row change preview and batch rollbackDahilKısmi destekKısmi destekDahil değil
Reusable mass-update rules (percentage math, conditional find/replace) and template libraryDahilKısmi destekKısmi destekDahil değil
Built, installed, and supported by ECOSIRE on your environmentDahilDahil değilDahil değilDahil değil
Tailored to your exact tables, custom fields, and permission setsDahilDahilKısmi destekKısmi destek
Ships as an upgrade-safe per-tenant extension (no base-object modification)DahilKısmi destekDahilDahil
No internal AL developer or ongoing dev backlog requiredDahilDahil değilDahilDahil
Job Queue offloading and import audit logging out of the boxDahilKısmi destekKısmi destekDahil değil

Mass Data Edit & Excel Round-Trip for Business Central hakkında Sıkça Sorulan Sorular

How long does delivery take, and how is it installed?

This is a build-to-order extension, not an instant download. After a short scoping call to confirm which lists, fields, validation rules, and permission sets you need, a typical build runs about one working week depending on how many tables and custom rules are involved. ECOSIRE then installs it as a per-tenant extension on your Business Central environment (cloud SaaS or on-prem), configures permissions, and walks your team through it. You receive the .app package and the AL source on handover.

What ongoing support and updates do I get?

Every build includes a post-delivery support window for bug fixes and questions. Because it ships as a per-tenant extension that doesn't modify base BC objects, it survives Microsoft's monthly and major BC updates cleanly; if a future BC release changes an API or table we depend on, we patch the extension under support. Beyond the initial window, you can add new lists, fields, or rules as scoped change requests, or take an ongoing maintenance agreement.

Is my data safe during a bulk import?

Yes — that's the core design. Imports land in a staging table first and run the same AL field validation, table relations, and posting-group checks as the standard BC pages, so invalid rows are rejected with a reason instead of corrupting your tables. You review a row-by-row old-value → new-value change preview before anything is committed, and a committed batch can be rolled back, including reversal of posted entries where applicable.

Can it edit our custom tables and fields, not just standard BC ones?

Yes. Because we build the extension against your specific environment, we can target standard tables (Items, Customers, Vendors, prices, dimensions) and any custom or ISV tables and fields you ask us to scope, as long as they're accessible via AL and the BC API. We confirm the full list during scoping so the export sheets and validation match your real data model.

Why buy this instead of just exporting to Excel and editing manually?

Standard BC can open a list in Excel and even edit-and-publish simple cases, but it doesn't give you reusable mass-update rules (percentage math, conditional find/replace), a saved template library, a pre-commit change preview, batch rollback, Job Queue offloading for large runs, or permission-scoped control over who can do it. This tool packages all of that as one governed, validated workflow built around your environment.

Teklif isteyin

Mass Data Edit & Excel Round-Trip for Business Central

Bulk-edit BC records via Excel export and validated re-import — fast price updates, master-data cleanup, and reposting, with change preview and rollback. Built and installed by ECOSIRE as a per-tenant extension.

  • Export any Business Central list (Items, Customers, Vendors, prices, dimensions, or custom tables) to a structured Excel edit sheet via page-extension actions
  • Validated bulk re-import that runs the same AL field validation, table relations, and posting-group checks as the standard BC card — no silent corruption
  • Mass field-update rules: apply a value, find/replace, percentage/factor math (e.g. raise all prices by 8%), or conditional updates across thousands of rows
  • Reusable template library so recurring jobs (price updates, master-data cleanup) use a saved, pre-mapped column layout

Teklif isteyin

Mass Data Edit & Excel Round-Trip for Business Central ihtiyaçlarınızı bize anlatın; fiyatları, lisans seçeneklerini ve size özel bir teklifi genellikle bir iş günü içinde gönderelim.

Şimdi ödeme yok. Bu, ekibimize bir teklif talebi gönderir — fiyat ve sonraki adımlarla e-posta ile dönüş yapacağız.