unable to match the distribution records in Audit table and base table
Hi,
We have enable the audit trial in payables invoice and related tables are ap_invoices_all, ap_invoice_lines_all, ap_invoice_distributions_all. we have enabled some columns in those table for auditing. In that distributions table we enable the gl_date and account column for audit. if user update or delete the records then it will be stored in shadow table ap_invoice_distributions_a.
Our problem is, invoice having more than 100 lines and enduser change the account in particular invoice distributions and changed records are stored in audit table. we unable to match the records using invoice_distribution_id in ap_invoice_distributions_all and ap_invoice_distributions_a which table is shadow table and stored the audit records. in that audit table, invoice_id and distribution_line_number is having the records. invoice_distribution_id value is null in audit table. Please help us in this regards.