I failed to find the time stamp and user ID who report an operation complete in production order.

Without the time stamp, we are not able to calculate the lead time and the waiting time between operations.

Without the user ID, we are not able to identify the user who reported an operation complete. This imformation is especially useful for QC operation. Now, we have to base on paper (outside BaaN) to trace who is the QC who approved an in-process QC operation or final QC.

Does anyone have a better idea ?

You could turn auditing on for the table tisfc010 and then interrogate the auditing as and when you need it.

Perhaps auditing is my last choice. Retrieving data from audit tray is not as efficient as retrieving data from database table.

I am thinking of adding fields to table tisfc010 to store the user id and the time stamp when an operation is reported complete. Anyone implemented this before ?

We have a separate table parallel to tisfc010 wherein we update date,time and user when the operation is finished . As a policy we do not amend the Baan standard tables, though u can do it technically very easily.

We choose a simular approach. We designed a table called atisfc010 with the same fields as the original plus timestamp and user and function (Insert, Update, Delete). Then we wrote a trigger for the Baan Table ttisfc010. Within this trigger we update the atisfc010 with data records.

This way no Baan table or script had to be modified.
:D

you can get user information from integration table tfgld410.
although you lose this info if you purge this table.