Vendor Electronic Payment Table Audit

We need to track all additions/changes/deletions in the AP_VendorElectronicPayment table. Has anyone used scripts to track the changes successfully? We are using Sage 100 Premium. I have not used scripting in Sage, but I believe this could be a solution.

If anyone has information on how to handle in SQL, that will work as well.

Parents
  • 0

    Pre-write & pre-delete script on the table should do it.  Get all the details you want into a text string then write to the Activity Log.

    oSession.WriteLog "M", "New / changed / deleted AP_VendorElectronicPayment data... " & sTheDetailsYouWantToLog

    You could write to a UDT too, but with the Activity Log, there are no extra permissions required.

  • 0 in reply to Kevin M

    Once I add a field to the script (e.g., oSession.WriteLog "M", "New / changed / deleted AP_VendorElectronicPayment data... " & getvalue("APDivisionNo$"), I receive Error 88 when I try to modify data in Electronic Payment. 

    Not sure what I am doing.

Reply Children