Thanks for the data, but this is not quite what I am looking for.
I'm trying to write a report in CorVu that will compare the record creation date for a material to the due date of the material. We have done this for purchasing (order date vs. due date) and it works well. We're trying to identify our bottlenecks and work on these problem areas.
If you go to job entry, select job, view change log, there is a list of Vantage generated changes to each line item in the bom (provided you have this feature turned on). If you sort it by assembly, the first record for each material line item gives the user, the time and the text 'New Record'. It is this date I am trying to capture. That way I can compare this date to the due date to come up with the amount of time given by engineering to get the part here.
Any suggestions?
Eric L. Tyira
Tamglass Tempering Systems
P: (856) 786-1200
F: (856) 786-7606
eric.tyira@...
-----Original Message-----
From: jim.kennedy@... [mailto:jim.kennedy@...]
Sent: Tuesday, August 10, 2004 5:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] entry date of materials in job entry
Have you tried creating a change log using the Business Activity Manager
Add/Update?
Use the Business Activity Manager dialog box to add or update change logs
assigned to tables. Change Logs are valuable when you want to track
activity on a table, and send out a global alert or create a log on the
basis of the activity.
To update Change Logs, from the Business Activity Manager window, take the
following steps:
1. To add a change log to a table, highlight the table, and from the
Change Log menu, select Add. To update a change log, highlight it, and
from the Change Log menu, select Update. For either action, the Business
Activity Manager dialog box appears.
Perhaps this is what you're looking for?
--------------------------------------------------------------------
Jim Kennedy
Manager, Information Systems
ST Inverter America
Cell: (832) 922-1364
Phone: (281) 506-3144
Fax: (281) 506-3101
"Tyira Eric" <eric.tyira@...>
08/10/2004 01:49 PM
Please respond to vantage
To: <vantage@yahoogroups.com>
cc:
Subject: RE: [Vantage] entry date of materials in job entry
That's good. How about the Vantage generated changed log instead of the
user entered audit log? It that available?
Eric L. Tyira
Tamglass Tempering Systems
P: (856) 786-1200
F: (856) 786-7606
eric.tyira@...
-----Original Message-----
From: jim.kennedy@... [mailto:jim.kennedy@...]
Sent: Tuesday, August 10, 2004 1:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] entry date of materials in job entry
Eric,
Inner joins between the PUB_JobAudit, PUB_JobOper, PUB_JobDtl, and
PUB_PartTran tables, you can get all the details for any job, the related
materials used, transaction dates, transaction types, accounts
credited/debited, manufacturing variances, etc...
Hope that's what you're looking for.
--------------------------------------------------------------------
Jim Kennedy
Manager, Information Systems
ST Inverter America
Cell: (832) 922-1364
Phone: (281) 506-3144
Fax: (281) 506-3101
"Tyira Eric" <eric.tyira@...>
08/10/2004 12:05 PM
Please respond to vantage
To: "Vantage User Group (E-mail)" <vantage@yahoogroups.com>
cc:
Subject: [Vantage] entry date of materials in job entry
Does anyone know how to capture the entry date (record creation) of a
material in job entry? In what table/field etc.?
Thanks in advance.
Eric L. Tyira
Tamglass Tempering Systems
P: (856) 786-1200
F: (856) 786-7606
eric.tyira@...
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
< http://us.ard.yahoo.com/SIG=129rkoudv/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1092247260/A=2164331/R=0/SIG=11eaelai9/*http://www.netflix.com/Default?mqso=60183351> click here
< http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2164331/rand=210974277>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of < http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129hbct0n/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1092258834/A=2164330/R=0/SIG=11eamf8g4/*http://www.netflix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2164330/rand=363172094>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
I'm trying to write a report in CorVu that will compare the record creation date for a material to the due date of the material. We have done this for purchasing (order date vs. due date) and it works well. We're trying to identify our bottlenecks and work on these problem areas.
If you go to job entry, select job, view change log, there is a list of Vantage generated changes to each line item in the bom (provided you have this feature turned on). If you sort it by assembly, the first record for each material line item gives the user, the time and the text 'New Record'. It is this date I am trying to capture. That way I can compare this date to the due date to come up with the amount of time given by engineering to get the part here.
Any suggestions?
Eric L. Tyira
Tamglass Tempering Systems
P: (856) 786-1200
F: (856) 786-7606
eric.tyira@...
-----Original Message-----
From: jim.kennedy@... [mailto:jim.kennedy@...]
Sent: Tuesday, August 10, 2004 5:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] entry date of materials in job entry
Have you tried creating a change log using the Business Activity Manager
Add/Update?
Use the Business Activity Manager dialog box to add or update change logs
assigned to tables. Change Logs are valuable when you want to track
activity on a table, and send out a global alert or create a log on the
basis of the activity.
To update Change Logs, from the Business Activity Manager window, take the
following steps:
1. To add a change log to a table, highlight the table, and from the
Change Log menu, select Add. To update a change log, highlight it, and
from the Change Log menu, select Update. For either action, the Business
Activity Manager dialog box appears.
Perhaps this is what you're looking for?
--------------------------------------------------------------------
Jim Kennedy
Manager, Information Systems
ST Inverter America
Cell: (832) 922-1364
Phone: (281) 506-3144
Fax: (281) 506-3101
"Tyira Eric" <eric.tyira@...>
08/10/2004 01:49 PM
Please respond to vantage
To: <vantage@yahoogroups.com>
cc:
Subject: RE: [Vantage] entry date of materials in job entry
That's good. How about the Vantage generated changed log instead of the
user entered audit log? It that available?
Eric L. Tyira
Tamglass Tempering Systems
P: (856) 786-1200
F: (856) 786-7606
eric.tyira@...
-----Original Message-----
From: jim.kennedy@... [mailto:jim.kennedy@...]
Sent: Tuesday, August 10, 2004 1:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] entry date of materials in job entry
Eric,
Inner joins between the PUB_JobAudit, PUB_JobOper, PUB_JobDtl, and
PUB_PartTran tables, you can get all the details for any job, the related
materials used, transaction dates, transaction types, accounts
credited/debited, manufacturing variances, etc...
Hope that's what you're looking for.
--------------------------------------------------------------------
Jim Kennedy
Manager, Information Systems
ST Inverter America
Cell: (832) 922-1364
Phone: (281) 506-3144
Fax: (281) 506-3101
"Tyira Eric" <eric.tyira@...>
08/10/2004 12:05 PM
Please respond to vantage
To: "Vantage User Group (E-mail)" <vantage@yahoogroups.com>
cc:
Subject: [Vantage] entry date of materials in job entry
Does anyone know how to capture the entry date (record creation) of a
material in job entry? In what table/field etc.?
Thanks in advance.
Eric L. Tyira
Tamglass Tempering Systems
P: (856) 786-1200
F: (856) 786-7606
eric.tyira@...
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
< http://us.ard.yahoo.com/SIG=129rkoudv/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1092247260/A=2164331/R=0/SIG=11eaelai9/*http://www.netflix.com/Default?mqso=60183351> click here
< http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2164331/rand=210974277>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of < http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129hbct0n/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1092258834/A=2164330/R=0/SIG=11eamf8g4/*http://www.netflix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2164330/rand=363172094>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]