Sage 100

From time to time I've had users inquire about whether Sage offers a more detailed audit capability. For example, my most recent inquiry was from someone asking if Inventory could track who made changes to pricing. Presumably, they'd track the value before, the value after and who made the change. While the idea seems interesting I think the implementation might be a little more challenging. Each company is probably looking to monitor different aspects of their system and I could imagine the log file growing very quickly. Has anyone tackled this before? I've used a third-party which monitors who goes into and out of Sage and at what time but that only logs general login and not exact changes.

Alerts and Workflows?

Oh @DavidSpeckII ......

Can I append that to a file / log?

I'm with @MaryJoKrueger, though you could do it in Premium with SQL triggers for 'free'.

With SQL triggers you create log table(s), and point a Crystal report at them. Alerts could probably do any kind of output with scripting, or add to a table you can report off of.

The Item Audit Report can be turned on and set to track changes - overkill since ALL changes are reported, but maybe use the IM_Audit file via Crystal and filter by field-name for Std or Retail price.

I tried testing this for changes to a price schedule (which is what the customer seemed to be looking to track) and it did not seem to write a record when I updated a price schedule.

Audit would only get change to the price-code change itself, since the price code-schedules are in the price-code file.

The audit files used to roll after a certain number of transactions. Questions may be coming as most SQL based systems are going audit logs in a way similar to what @PhilMcIntosh suggested. In SAP B1 not only does it track every change made by whom and when down to the field level, it includes all UDFs and lets you actually see the previous versions by rendering your screens with the old data in a view only mode. Sounds like a project for @JimWoodhead DSD with SQL!

Assuming that the audit information would be used in a ~60-day period and it's being used ad hoc instead of periodic reports, Knowledesync is the lowest cost way to address this. Setup events triggering on different changes to send email notices to Administrator. Use email rules to sort and filter them automatically into appropriate folders. the information is now readily accessible to research, and very easy to modify as you go. Writing audit logs is straightforward, but hard to maintain. Customers tend to completely ignore them until an emergency, when they discover it screwed up 3 weeks earlier ...