AUDIT TRAIL REPORT ON SUPPLIERS ( HOW TO ADD COLUMNS TO AN EXISTING AP_SUPPLIERS_A AUDIT TABLE AND

 

Hi,

Now iam working on supplier audit report.

steps

1.   System Administrator > Security > AuditTrail > Groups

Create Group ap_suppliers_group
Application Name: Payables
Audit Group: ap_suppliers_group
Group State: Enabled
Add tables:
AP_SUPPLIERS

AP_SUPPLIER_SITES_ALL
Save

2.   System Administrator > Security > AuditTrail > Tables

Query table name AP_SUPPLIERS
Add row for column TAX_REPORTING_NAME
Add row for column VAT_REGISTRATION_NUM

Save

Query table name AP_SUPPLIER_SITES_ALL
Add row for column ADDRESS_LINE1
Add row for column ADDRESS_LINE2

Save

3.   System Administrator > Security > AuditTrail > Install

Query User AP
Check Audit Enabled if not already checked
Save