Incorrect "Reviewed Date" after upgrade to version 27 in Review General Ledger Entries module

[AlaWeslati]

Why do you need this change?

After upgrading to Business Central version 27, an issue has been identified in the module "Review General Ledger Entries".

During the upgrade process, data is transferred from:

Table "G/L Entry Review Entry" (ID 22216)
to
Table "G/L Entry Review Log" (ID 22218)

On the page "Review G/L Entries" (ID 22207), the field "Reviewed Date" is now calculated using a FlowField that looks up:

SystemCreatedAt from table "G/L Entry Review Log"

Describe the request

Issue

The use of SystemCreatedAt is not correct for representing the actual reviewed date because:

SystemCreatedAt is a system-managed field
It reflects the record creation timestamp, not the business action date
During the upgrade, all migrated records receive a new SystemCreatedAt value
→ resulting in incorrect "Reviewed Date" values (equal to upgrade date)
Expected Behavior

The "Reviewed Date" should reflect the original review date from the legacy data (table 22216), not the system creation date.

Impact
Loss of historical accuracy for reviewed entries
Misleading audit and financial review information
All reviewed entries appear as if they were reviewed on the upgrade date
Suggested Fix

It is recommended to:

Add a dedicated field (e.g., "Reviewed Date") in table "G/L Entry Review Log" (ID 22218)
During upgrade, populate this field with the original reviewed date from table "G/L Entry Review Entry" (ID 22216)
Update the FlowField or page logic to use this new field instead of SystemCreatedAt