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
- A manager grants protected table access on the Import Export PowerTool Setup page.
- The user prepares the update, import, or delete for the protected table.
- The user previews the affected records.
- 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.
Related Import Export PowerTool features
All Import Export PowerTool features →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.
