ADempiere and iDempiere – User Activity and Change Log Reporting

Hi Everyone,

One of my favorite features of ADempiere and iDempiere is that you can track every little footstep (change tracking) everyone makes in the system. This is true for IT personnel changes as well. The purpose of this post is explain how I made change log information more accessible and reportable for one customer. This change took me about 15 minutes.

1. I created a view “create view yourco_changelog_v as select * from ad_changelog”. Note: always report off a view. You have infinitely more options for enhancing the report than just reporting off the table itself.
2. Bring in the newly created view into iDempiere’s ‘Table and Column’. Deactivate the columns you do not need. I recommend keeping the bare minimum (client, org, created, createdby, updated, updatedby, new, old, table and column). You can add the other columns as needed later.
3. Create an ADempiere ‘Report View’ for your new view.
4. 
5. Create an iDempiere ‘Report & Process’. Point it to your new ‘Report View’. Add parameters for Users (CreatedBy), Date Range (Created), and Table.
6. 
7. Create a new entry under ‘Menu’. Point the new entry to your new ‘Report & Process’.
8. 
9. Log out of System Administrator, and log into iDempiere as your client’s administrator, and run your new report!

I hope this helps!!

ADempiere vs iDempiere vs Openbravo vs Compiere

Please note that ADempiere, iDempiere and Openbravo are forks or copies from Compiere. Therefore, they have similar abilities mentioned above. The biggest difference is that ADempiere and iDempiere are pure open source. There are no features held behind a commercial or paid license.