What is the database effect of enable "Created by " & "Modified By" property in all transaction tables

Finance and Operations/AX Developer Forum
1

Hi All,

we have a requirement to enable all transaction table’s “Created By” and “Modified By” property. What will be the effect of this function in our database. Should we enable it for all Tables ?

Also want to know same for “Created date And time” and “Modified Date time” property.

2

Enabling these properties creates appropriate fields, which are then filled by kernel. For example, “Created By” property creates the CreatedBy field, which will contain ID of the user who created the record.
You definitely shouldn’t enable it for all tables. It would mean potential upgrade conflicts on all tables (which would be a big problem) and you would also waste storage and computation resources. Enable only those properties on those tables that you actually need.

3

Thanks Martin,

How the database will be effective.

We are thinking to enable it for all Transaction type tables . Is it a good idea ?

4

I already gave you three reasons why it’s a bad idea. The fourth it’s that it simply makes no sense for many tables.