All Dynamics Business Central community (Business Owners, Project Managers, Solution Architects, Functional Consultants, Business Analysts, CAL/AL Developers, BI Developers and End Users) get used to it!
If for some reason, some of these persons needs to go deep to analyse some data in BC database, they expect to see some System fields table to help to audit them.
Amazing news from MSFT to be released next month (October 2020) in Dynamics 365 2020 Release wave 2.
New feature
Four new system fields are added to all tables:
SystemLastModifiedOn
SystemLastModifiedBy
SystemCreatedBy
SystemCreatedOn
The platform will populate the content of the fields when a record is created and modified. It isn't possible for a developer to control the values that are saved to the database.
Business value
This gives developers an easy and performant way to program against historical data, such as writing AL queries that return changed data since some specified point in time.
The official information is here https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/data-audit-system-fields-are-added-every-table.
Let me remind you that you read: All the tables :):)
Comments