1

(0 replies, posted in Wish List)

Please see for context: https://frontaccounting.com/punbb/viewtopic.php?id=10514

The desired enhancement is for the audit trail report to be able to answer the question "who changed what value to what and when".

Who changed and when is available. The "what value" does not capture historical data, so the report cannot tell if I changed "8.55" to "88.55", since "8.55" is never stored in the database today.

This is also now a legal requirement for some types of organizations starting 2023 in India.

More details here: https://taxguru.in/company-law/audit-trail-companies-act-2013-wef-01-04-2023.html

Dear dz, thanks for your response. This is a setback for us. We are committed users of FA for many years, and now we have a critical requirement to maintain audit trail which includes the historical value changes.

The audit trail must be able to answer "who changed what to what and when".

This would have to be a core functional enhancement I suppose, since FA is currently not storing historical values in the audit trail table.

I will post on the wish list forum.

Meanwhile, if anyone has a workaround to this, kindly share!

My accounting team members are long-time users of FA and are now exploring the audit trail feature for GL entries. I am the IT system admin posting on their behalf.

In the latest frontaccounting demo server at https://demo.frontaccounting.eu

the accountant posted a bank payment entry for 8,199 . This is transaction 161. Then he searched for it, clicked on the 'edit' (pencil icon), updated the amount to 8,201. This is transaction 162.

The audit trail report shows these relevant entries after the edit. Attaching a screenshot of the audit trail pdf report generated in FA.

161 | changed | 0.00
162 | changed | 8,201
161 | closed  | 0.00
162 | closed  | 8,201

This seems incomplete. The original 'changed from' value "8,199" from transaction 161 is missing, only the final 'changed to' value "8,201" is recorded. Is this the designed/expected behavior?

The original value is important for us. It does not seem to get persisted anywhere in the database once it is updated to the new value, so there is no way to recover/report it?

Appreciate suggestions, inputs.