1

Currently, when setting up Database logging on Table LedgerFiscalCalendarPeriod (Ledger fiscal calendar period) – on ‘Update’, on fields Reference, Ledger, Period Status, you'd see the following scenario/results:


=====

Action taken:

Change the Fiscal period Status on a specific Period, from ‘Open’ to ‘On hold’

Result:

Only the Status field is logging the ‘Value’ and ‘Previous value’ entries

FiscalCalendarPeriod, Ledger fields are not getting recorded in the log


That is happening as there are no ‘Updates’ done on the FiscalCalendarPeriod and Ledger fields (only the 'Period Status' value was updated). The History tab will show cumulative changes, and just shows the recent change that had happened and on which particular field (i.e. Period Status).

=====


Due to that current design behavior in database logging, that means the user would not know which Period was updated and from which Ledger it is from.


Thus, it would be good to have a way to track data changes on Table LedgerFiscalCalendarPeriod, and also show the current values on fields: FiscalCalendarPeriod, Ledger, to help users understand which Period was updated and from which Ledger it is from.

Category: General Ledger
STATUS DETAILS
New