Change Log for the the UD100A Table


(Andrew Murdock) #1

I’m I missing something or is there not a Change Log for the UD1XXA tables?

The option is there in UD100 - UD110 but not in UD100A - UD110A

I thought it might be in the table drop down for UD100 but as a data directive it makes sense that it is not listed there either.

(Haso Keric) #2

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;

(Andrew Murdock) #3

Thank you @hasokeric! :+1: