Provide consolidated Audit Trail / Edit Log reports (ERP ) Fiscal Year Wise

Hi,

For statutory audit purposes, we need to produce Audit Trail / Edit Log reports covering all systems used for financial record-keeping in FY wise, including the ERP (Frappe/ERPNext) and any other accounting software in use by the Company.

Requirement Provide Audit Trail / Edit Log reports that include, wherever applicable:

User who made the change Date and time of the change Nature of the change (Created / Updated / Cancelled / Amended / Deleted) Original value and revised value for each changed field Document/record reference (DocType and document name/number) Scope

ERP (Frappe): Financial DocTypes at minimum — Journal Entry, Sales Invoice, Purchase Invoice, Payment Entry, Stock Entry, Delivery Note, Purchase Order/Receipt, and Chart of Accounts (Account) — plus any DocType where Track Changes is enabled. Any other accounting software used in parallel (if applicable) — confirm scope with Accounts team. Technical notes for implementation

In Frappe, change history is stored in the Version doctype whenever Track Changes is enabled on a DocType, and can be viewed per-record at /app/audit-trail?doctype_name=&document=. Track Changes is currently not enabled on all financial DocTypes — this needs to be confirmed/enabled first, since a DocType with Track Changes off will have no version history to export, even retroactively. A consolidated, exportable report (rather than the per-document Audit Trail view) will likely need a custom Query/Script Report that pulls from the Version table joined with tabVersion's data field (JSON diff of old/new values), filtered to FY and the in-scope DocTypes. Acceptance Criteria

Confirm which DocTypes had Track Changes enabled. Build/identify a report that exports: User, Timestamp, DocType, Document, Field Changed, Old Value, New Value, Nature of Change Cover all in-scope DocTypes for the full FY date range Confirm whether any non-ERP accounting software needs a separate export, and obtain that

Regards, Deepak Singh