Entry date of materials in job entry - Audit Files

system · August 13, 2004, 2:26pm

I got it!! This report works great! There is a change log table (chglog) that holds all the data provided you have it turned on. When a record is created, it lists it as "Username - time - New Record."

In CorVu, I did a join between a query for this table and one for the jobmtl table. Linked the common fields, find those with "Record" in them, and away we go.

It calculates the release leadtime in calendar days (required date minus release date) and the comparison of this versus the leadtime in part master (most of which are set to zero).

This is awesome. Thanks to those who helped rattle the cobwebs.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Babette Welch [mailto:bwelch@...]
Sent: Friday, August 13, 2004 12:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: entry date of materials in job entry - Audit Files

In case this has not been answered....
A few change log tables are:
Quote = quoteadt
Job = Jobaudit
Part = partaudit

Have not found the Labor audit table or
the Sales Order Audit table

Hope this helps... also... there is a CorVu user list (just beginning)
Which you can sign on through Yahoo.

BW

_________________________________________

Message: 21
Date: Wed, 11 Aug 2004 23:19:02 +0300
From: "Tyira Eric" <eric.tyira@...>
Subject: RE: entry date of materials in job entry

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@... <mailto:eric.tyira@...>
_________________________________________________
Babette Welch
IT Director
Argonics, Inc
1110 Wright Street
Marquette MI 49855
906.226.9747 ext 235
906.228.0951

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=129miks25/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1092499841/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=646383121>

_____

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]

system · August 13, 2004, 12:10pm

In case this has not been answered....
A few change log tables are:
Quote = quoteadt
Job = Jobaudit
Part = partaudit

Have not found the Labor audit table or
the Sales Order Audit table

Hope this helps... also... there is a CorVu user list (just beginning)
Which you can sign on through Yahoo.

BW

_________________________________________

Message: 21
Date: Wed, 11 Aug 2004 23:19:02 +0300
From: "Tyira Eric" <eric.tyira@...>
Subject: RE: entry date of materials in job entry

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@... <mailto:eric.tyira@...>
_________________________________________________
Babette Welch
IT Director
Argonics, Inc
1110 Wright Street
Marquette MI 49855
906.226.9747 ext 235
906.228.0951