This website uses only technically necessary cookies. Further information can be found in the menu [?] [Privacy Notice]

Introduction

TET is an extension for Microsoft Dynamics 365 Business Central (soon available at Microsoft AppSource).

What TET can do

  • You urgently need to change a value in BC, but the application is preventing you from doing so?

    An update, import or incorrect entry may result in a value being saved that causes an error at this or another point. If this brings your production to a standstill or prevents you from working, you need a quick, pragmatic solution if your application does not offer you one. In this case, you cannot wait for someone to write a solution for you. TET can help you here, as it allows you to access the values at field level and correct them directly or delete the problematic record.

  • Would you like changes at field level to be logged?

    You may have the option of directly accessing the database underlying your application in order to simply change a field in an emergency, but is this change then logged? With TET, this is the case. You can even store a reason for the change and give individual users access to this Log List .

  • Would you like to view specific records at table level?

    If you have the appropriate rights, you can access table contents in BC in read-only mode. However, you cannot filter this view in advance, which can take a long time when opening very large tables. You can only apply filters afterwards. With TET, you can set filters in advance and then navigate through each record.

In TET there is a Test Area with its own table including an extension, so you can try out TET without having to make changes to your own tables.

Music in the video by https://www.musicfox.com
Please note

TET is an app for administrators. Only a small, select group of people should be given TET - Admin right in order to act in an emergency. In order to change or delete data in this way, validation, properties (e.g. for min. or max. values) and triggers programmed in the corresponding table are bypassed so that problems can be resolved; even a read-only field can be written to. However, due to this feature, it is impossible to prevent inconsistencies from entering the system if an incorrect value is entered.

In TET, no tables or fields from the 2 billion system area are displayed, nor is the table for the Log List so that changes can be traced. Some other tables I created (tables ‘HHi*’) are also not offered. If you would like more flexibility here, please contact me for customization.

Currently, changes (renaming) to a primary key can only be made if this key consists of exactly one attribute.

Data types

In general, calculated fields of type ‘FlowField’ and ‘FlowFilter’ cannot be changed. Neither can fields that have been marked as ‘Removed’. The values must match the data type, i.e., you cannot write text to an integer or store more characters in a text field than the specified length.

Currently, the following data types can be modified:

  • BigInteger
  • Boolean
  • Code
  • Date
  • DateFormula
  • DateTime
  • Decimal
  • Duration
  • GUID
  • Integer
  • Option
  • Text
  • Time

Changes for the following data types are still in the planning stage:

  • BLOB
  • Media
  • MediaSet
Documentation on TET

All TET documentation is available in German or English.

TET is available for the following Microsoft Dynamics 365 Business Central versions
for older BC versions or On-Prem available on request (may be subject to a charge)
Pricing Model
TET is available as a [ Free trial ] version until end of December 2025. After that, I reserve the right to make changes to the pricing model.