Dear All,
I would like to know what are all the changes made to a table say 'tdpur040' during a period. Can anyone pls tell me the tips how to achieve this using Audit management?
Or if there is any better way to do this please let me know.

Regards,
Sat

Please do *not* cross-post.

Did you search the board for "audit" and did you (among others) read this thread (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=8053&highlight=audit)?

The best way is to use the tool already provided for that effect: audit management.
If you are concerned about changes thru General Table Maintenance, this session has it's own change (=audit) log.

And as posted, always search the threads before posting, the answer may be already answered.

For finding what changes were made to Purchase Order Header or Lines, you can also check the History tables. For any other tables you can use the audit.
However, for using audit, the audit must be on for the specific tables and also the table fields.

Manish.

Has anybody tried extracting audit information throgh Baan scripts?


Regards,
Ram

Baan stores the audit logs in flat files which are very slow and unwieldly to sort as they grow larger. We have had good success in building a smaller "mirror" audit table for tdpur040 and then adding database (oracle in this case) triggers that capture each modification/insert/delete of a record. It then is very easy to build some baan sessions to display or report from this data


If you are interested in more details let me know and I will post example data structure layout as well as trigger logic.