Out of the box the Change Log facility is only available for selected tables in Epicor 9 and ERP 10.
You can however switch it on for any table you wish to track by enabling it through SQL. After you run the following statement, the ChgLog function will be available in the BPM Designer.
– Principal Technical Support Engineer at Epicor Software
UPDATE [Ice].[zDataTable] SET ChgLogId = 'UD100A', TableLabel = 'UD100A' WHERE [DataTableId] = 'UD100A'
Please note that this method only enables the option in the Workflow Designer, it will not add any display option to the maintenance screen; that would have to be done via customization, only if you need it.
new ChangeLogHelper(this.UD100Form).AddViewToWatch(this.oTrans.Factory("UD100A"));
baseToolbarsManager.Tools["ChangeLogTool"].SharedProps.Enabled = true;
I followed the information on the steps to get the widget to show up on projectcst table and the information is not showing in the change log information screen the button is already there and the information is in the table not sure what I am missing currently.
I am not sure if I completely understand your question. But, if it is why don’t I see my changes made to my table now that I’ve set it up for audit? Then maybe it is the ChgLogId field in the zdatatable that shows what data is shown when audit log is clicked in a program. See below screenshot, the reason why PORel and POMisc data changes show up in PO change log when clicked.
I suggest you look at the ChgLog data overall via BAQ to see if your changes are being logged, then look here if it’s not showing up in expected record.
Sadly this solution is not available to those of us who are not in control of our own hosting. I asked someone from the cloud team to run the SQL command for us but they were not allowed to. I was told to file an enhancement request, which was promptly denied:
Hello Evan,
I received a response from Development and it was stated in their response that Change log is not going to be supported for UDxx child tables.
Please consider some other table or method to track your necessary changes. thank you.
I attempted this for Supplier Price Lists. Change Logs are being written in SQL. I was able to get the Icon to show in the form but its empty. The little star even shows that changes were made but nothing there.
new ChangeLogHelper(this.SupplierPriceListEntryForm).AddViewToWatch(this.oTrans.Factory("venPartView"));
baseToolbarsManager.Tools["ChangeLogTool"].SharedProps.Enabled = true;