7.06 Audit Trail (SQL log activity)

Where to find the document/transactions CREATED by the user?

Where to find the document/transactions EDIT/MODIFY by the user?

Where to find the document/transactions DELETE by the user?

The above common questions, you can find it follow below steps:-

1. Tools | Print Audit Trail...

2. Define the date range.

3. Select user ID (if you wish to search for selected user, otherwise unticked it)

4. Tick Event either

INSERT - created, input or entered by user.

EDIT - edit, modify or changed by user.

DELETE - delete or removed by user.

#INFORMATION - Override Credit Limit by user.

5. Where: select the module to search.

6. Apply it.

Audit Trail Posting...

- Insert Operation = Only Master document is posted.

- Edit Operation = *Both Master & Detail is posted.

- Delete Operation = *Both Master & Detail is posted.

Notes

* For Stock, Sales & Purchase Detail will only posted if the option at

Tools | Options | Miscellaneous | Post Audit Trail for Stock/Sales/Purchase Detail is Tick (Default is untick)

# Only available on SQL Accounting Version 3 only - Feature #1765

# Don't Select any module at Where option (Point 5 above) else no result - Bug #2359