Skip to content
Import Export PowerTool app iconImport Export PowerToolUpdate and delete

Protected Tables for Microsoft Dynamics 365 Business Central

Some data problems sit in tables Business Central protects, such as item ledger entries and customer ledger entries, or in fields marked non-editable, and fixing them normally means writing an extension. Import Export PowerTool can work with system-protected tables, including fields marked non-editable and tables with no page of their own. This is a completely free app from Insight Works for Business Central.

How Protected tables works in Import Export PowerTool

  1. A manager grants protected table access on the Import Export PowerTool Setup page.
  2. The user prepares the update, import, or delete for the protected table.
  3. The user previews the affected records.
  4. The operation runs within the user's Business Central permissions.

Key capabilities

Protected sub-ledger tables

Update, import, or delete in tables such as item ledger entries and customer ledger entries when protected table access is granted.

Non-editable fields

Fields that Business Central does not let a user edit on a page can be updated, which is a route to fixing a bad entry without a developer.

Historical sales without posting

Historical sales can be written directly into the item ledger entry table instead of imported as journal lines and posted, so no general ledger or value entries are created. One pattern is an opening balance as a positive quantity, then monthly negative entries that draw it down to zero.

Summarize first

Large history files can be summarized to monthly totals, for example with a database query or a spreadsheet pivot table, before they are imported.

Manager control

Protected table access is set on the setup page, which only the manager permission set can change. See Permission Sets.

See Protected tables on screen

Real screens from Import Export PowerTool, shown with demo data.

Details that matter on the floor

Nothing beyond existing permissions

Import Export PowerTool respects each user's Business Central table permissions. It does not grant a capability that someone able to publish an extension does not already have; it makes the work easier.

Dependent entries

Ledger entries have related value and general ledger entries. Deleting or changing one without the others leaves data in a bad state, so plan changes to protected tables carefully.

Keep access narrow

Grant protected table access to the consultants and administrators who need it, not to everyday users.

Who uses Protected tables

Business Central consultants

Fix bad entries in protected tables without writing an extension.

Data migration specialists

Load item sales history for planning and analysis without posting it.

Business Central administrators

Decide who has protected table access.

Questions about Protected tables

Can I edit ledger entries in Business Central?

With Import Export PowerTool and protected table access, you can update, import, or delete records in protected tables such as item ledger entries and customer ledger entries, within your Business Central permissions.

Is protected table access safe?

It needs care. Access is set on the setup page by a manager, enhanced confirmation can be required, and the tool never goes beyond a user's existing permissions. Changing ledger entries without their related entries can leave data inconsistent.

How do I load sales history without posting it?

Write the history directly into the item ledger entry table with Import Export PowerTool, which creates no general ledger or value entries. Summarize detailed history to monthly rows first.

Can I work with general ledger entries?

Ask Insight Works or your Microsoft Partner about general ledger and journal tables for your setup before planning that work.

Import Export PowerTool app icon

Part of Import Export PowerTool

Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.

Have a question about Protected tables?

Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions