Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Manufacturing & Supply Chain

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th July 2004, 04:35
khyou99's Avatar
khyou99 khyou99 is offline
Junior Member
 
Join Date: Aug 2003
Location: Australia
Posts: 24
khyou99 is on a distinguished road
Baan: BaaN4c4 - DB: Oracle - OS: Unix
Question Time stamp and user who report an operation complete

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 ?
Reply With Quote
  #2  
Old 13th July 2004, 22:55
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Guru
 
Join Date: Mar 2002
Location: Malvern, England
Posts: 309
EdHubbard is on a distinguished road
Baan: 4c4 MCR - DB: MS SQL Server 2000 - OS: Windows 2003 Server
You could turn auditing on for the table tisfc010 and then interrogate the auditing as and when you need it.
Reply With Quote
  #3  
Old 14th July 2004, 06:57
khyou99's Avatar
khyou99 khyou99 is offline
Junior Member
 
Join Date: Aug 2003
Location: Australia
Posts: 24
khyou99 is on a distinguished road
Baan: BaaN4c4 - DB: Oracle - OS: Unix
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 ?
Reply With Quote
  #4  
Old 14th July 2004, 07:05
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
separate table

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.
Reply With Quote
Sponsored Links
  #5  
Old 14th July 2004, 07:30
malutz's Avatar
malutz malutz is offline
Senior Member
 
Join Date: Oct 2002
Location: Sweden / Switzerland
Posts: 160
malutz is on a distinguished road
Baan: Baan IVc4, Baan ERP 5c - DB: Oracle / MS SQL 2000 - OS: HP-Ux 11 / Windows 2000
Trigger

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.
__________________
//Marcel
Reply With Quote
  #6  
Old 12th August 2004, 13:09
pergerp's Avatar
pergerp pergerp is offline
Member
 
Join Date: Sep 2002
Posts: 31
pergerp is on a distinguished road
Baan: BAAN IV c4 - DB: Oracle 8 - OS: HP-UX
you can get user information from integration table tfgld410.
although you lose this info if you purge this table.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 02:20.


©2001-2017 - Baanboard.com - Baanforums.com