ERP Log & Forensic Audit Report

ERP Log & Forensic Audit - User Guide

1. Introduction 🛡️🔍

Trust is built on transparency. The ERP Log Report is the ultimate security layer of ERPCrystal/MFG. It maintains an unalterable, chronological record of every significant action performed within the software. Whether a purchase bill was edited, a customer profile was deleted, or an AI agent was consulted for sales predictions, this module captures the “Who, What, and When” of your organizational data.

This report is essential for Internal Auditors, IT Administrators, and Business Owners.

2. Log Categories 🚀

A. ERP Log (The Activity Trail)

• Operational History: Records every “Insert,” “Edit,” and “Delete” across all ERP modules.
• Modification Notes: Shows the internal data state before and after a change, allowing you to “Digital Trace” any clerical error back to its source.
• Activity Summary: Provides a high-level view of which users are the most active and which modules (Sales, Inventory, Finance) are being updated most frequently.

B. Scheduler Log (The Background Health)

• Automation Monitoring: Monitors the “invisible” parts of the ERP—the automated scripts that run in the background. Use this to verify that daily backups, automated ledger updates, and scheduled email reports were completed successfully.

C. AI Interaction Log (Agent Audit)

• Smart Usage Tracking: If your organization uses the integrated AI agents, this log tracks the prompts given to the AI and the category of assistance requested.
• Cost Control: Links AI usage to your organization’s “Credit Balance,” providing a clear view of which departments are utilizing AI resources.

3. Key Forensic Indicators 🛠️

• Operation Code: Identifies if a record was Created (C), Modified (M), or Deleted (D).
• Timestamp Precision: Logs the exact second an action occurred, which is critical for resolving disputes about “When” a particular order was processed.
• Doc ID Reference: Every log entry is permanently linked to the specific Record ID in the database, ensuring 100% traceability.

4. Understanding Data Columns 📊

• Date & Time: The precise moment of the action.
• User Name: The unique login ID of the person who performed the action.
• Module (DocType): The area of the ERP where the action took place (e.g., Invoice, GRN, Voucher).
• Operation: The nature of the change (Edit, Delete, etc.).
• Audit Notes: The specific details of the change (e.g., “Changed Rate from 100 to 110”).
• AI Credit Use: For AI logs, shows the resource cost of the interaction.

5. Source Transactions 🔄

The reporting engine synthesizes data from:

1. ERP One Log: The master security table that serializes all system operations.
2. AI System Logs: The central database tracking agent interactions and credit consumption.
3. Physical Scheduler Logs: Automated text files generated by background processing units.

6. Best Practices / Tips 💡