You’re offline. This is a read only version of the page.
88
Hi,
Is there OOB Audit history/logs for Products?
For example if a user changes the price of a product will the audit history show who change it, date/time and old/new price? Just wanted further information on what changes were tracked in Audit history.
Thanks
Hy Matty,
yes there is an option that is called "database log". It need to be ssswitched on for specific table and fields. It is located under System administration/Setup/Database Log/Database Log setup.
From there add the new table you want to log and run through the wizard.. You can use "Show all tables" and "Show table names" for easier search for the table you want to log.
In your case this could be inventtablemodule, the table where standard sales, purch and inventory prices are stored.
Select the table and go through the wizard to select specific fields and what kind of change should be logged (new, update, delete, ..)
Confirm that you understand that this can negative performance impact if you log tables with high volumne of changes, This should be avoided!
To see the changed values you can query the database log with System administration/Inquiries/Database/Database log. If you filter or sort by tables name or created date time you will find the log entries and user name who changed something on the logged table/field.
As there are multiple ways ro define your sales prices this is just the logging of the "base sales price" at item master. If you you are using trade agreements or cost versions the prices are located on different tables.
It is recommended to avoid log tables with high frequency of changes as it can have negative impact.
Share
Report
All responses (
Answers (
