Issue:

• The current Database Log report in D365 F&O displays change history in a raw FormattedData JSON format, which is not user-friendly or easily readable.

Example of the current format:

{"VendGroup": {"NewData": "Govt", "OldData": "Telcos"}, "ModifiedDateTime": {"NewData": "Apr 8 2025 12:05PM", "OldData": "Apr 8 2025 12:00PM"}}

• Users must extract this data using the Excel add-in or manual parsing to understand what actually changed.
• The report shows all fields, even when no value has changed (i.e., old and new values are the same), causing confusion and unnecessary data overload.
• There's no direct visibility of:
• Which fields were actually changed
• What were the before and after values
• Who made the change
• When the change was made

Suggested Enhancement:

Redesign the Database Log report output to display information in a user-friendly and structured format:

• Field Name: VendGroup
• Previous Value: Govt
• Current Value: Telcos
• Changed By: Admin
• Changed On: Apr 8, 2025, 12:05 PM

Only include fields where the value has actually changed (i.e., OldData ≠ NewData).

Benefits:

From Auditor’s Perspective:

• Ensures transparency and traceability of changes made to master and transactional data.
• Facilitates faster and more accurate compliance checks during internal or external audits.
• Provides clear evidence of changes with full context (what, who, and when).
• Saves significant time by avoiding technical data extraction and interpretation.

From End-User/Business User Perspective:

• Makes it easier for non-technical users to understand data changes without needing technical support.
• Helps in quickly identifying and validating recent updates for troubleshooting.
• Improves data accountability by clearly showing who made the change and when.