Introduction
Recently Steve Endow posted a question on X (formerly Twitter) about the possibility of importing data into system tables using Configuration Packages. This is a common limitation faced by many users of Microsoft Dynamics 365 Business Central, as system tables are considered sensitive and are not accessible by default.
)
A The Solution: A Custom Application
To address this issue, I developed a custom application (PTE) called UnrestrictedConfigPackage that extends the capabilities of Configuration Packages, allowing for controlled access to system tables.
How It Works
The app introduces a new setup in the ‘User Setup’ table that administrators can toggle to enable or disable system table access. This ensures that the functionality is controlled and can be limited to users who understand the implications of interacting with system data.
Get the Tool
Visit my GitHub repository to access the source code, make it your own, use it and abuse it… on your own risk 😁
Or contact me directly for help.
GitHub Repository Link: UnrestrictedConfigPackage
Bonus Content
The marketing text is stored in the table Entity Text in the field Text which is a Blob field. The rich text is stored in HTML format encoded in Base64.