Our Finance team reached out to me in IT to help find a way to review the COA for inactivity.. "get a list of a chart of accounts that hasn't been used in months/years? Like inactive line items that have been sitting around for years not being used?"
This seems like a normal request to evaluate what's not being used and keep your COA 'clean'. I couldn't find anything using ISD so opened a ticket.
Support indicated there is no way to get this data.. if I'm interpreting correctly.
"We reviewed this further with an internal resource but we have confirm that the audits are only tracked on the creation and update of the records. When a record is created or changed, it is created in the audit log file. There is no audit for a record that is just viewed nor when a dimension is just last used from a transaction as it would create millions of records and would quickly grow to a size that wouldn't be manageable."
How do the rest of you review your COA to keep it clean? Or is that really not a 'standard thing'?
