Deletion audit

[chanls]

Hi all,

I am using adempiere 361 with postgresql as the backend DB.

I can enable "Maintain Change Log" for a specific role and the log tracks all the changes (insert and update). However, it seems deletions are not tracked.

For example, if I create an invoice and prepare it, all the "invoice line" items are added to the DB. If I delete an item from the invoice line and complete the invoice, there is no way for me to find out when/who deleted the item. The only way I can tell that the item was deleted is from the missing "c_invoiceline_id" in the DB.

Is there a way to track the "delete actions" as well?

Thanks!


Nelson Chan

[globalqss]

Nelson, I just tested on http://demo.globalqss.com and change log is saving deletion records, indeed it saves all the columns that you marked as loggable, so if you have enough columns the records can be reconstructed from there.

Regards,

Carlos Ruiz

[chanls]

Thanks Carlo. I tried in http://demo.globalqss.com and as you said, the change log tracked the delete actions.

Now I need to find out how I can patch my adempiere 361 to enable this tracking feature.


Nelson Chan

[chanls]

It seems I can answer this question myself.

Once I enable "Maintain Change Log" of a particular table (e.g., c_invoiceline) in the application dictionary, the "delete" actions are logged.

Thanks a lot!


Nelson Chan