Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is attractive because of the ability to trigger SQL scripts to automate the task (the audit table does not need to be accessible in Sage 100, so does not need to be a UDT and could be completely invisible to Sage 100).
However, during my research I realized an even easier approach might be to add the necessary date/time fields to allow SQL to track changes using temporal tables. It appears the needed date/time fields can be invisible to Sage 100, so in theory it shouldn't cause problems with the application itself.
Before spending a lot of time testing this theory I thought I'd throw it out to the community to see if anyone else is using temporal tables in SQL to track changes to any of their Sage 100 tables, or if there might be reasons to avoid this of which I am unaware. Your thoughts?