Heads up:
It you create a report to verify the accuracy of the LastLaborDate field
compaired to labor tickets you may find some errors. What I have found is if
you go back say 2 days to fix a labor ticket for a job that finished today
the last guy wins. In other words the lastlabordate will now show two days
ago. In other words the write trigger needs to only update the lastlabordate
when the date is greater than the current lastlabordate not every time.
Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.10.130, Progress 9.1C
-----Original Message-----
From: Michael D. Howard [mailto:mike@...]
Sent: Wednesday, April 30, 2003 8:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] LastLaborDate on JobOper
Can't answer as to why JobOper doesn't seem to update for you .. but I have
a similar reporting feature using PartWip.LastActivityDate ... never had a
poblem with it ... might work better for you?
Mike
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, April 29, 2003 2:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] LastLaborDate on JobOper
I'm trying to use the last labor date on JobOper to determine roughly when
the operation was completed (not that they always get marked completed). But
I am notcing that often (but not always) this is returning "?" as if there
is no value there. But when I run the production detail report for the job
it shows labor transactions for the job. Any reason why the JobOper field
is not being updated with the date?
5.20.313
Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/xaxhjB/hdqFAA/bW3JAA/PhFolB/TM
---------------------------------------------------------------------~->
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
It you create a report to verify the accuracy of the LastLaborDate field
compaired to labor tickets you may find some errors. What I have found is if
you go back say 2 days to fix a labor ticket for a job that finished today
the last guy wins. In other words the lastlabordate will now show two days
ago. In other words the write trigger needs to only update the lastlabordate
when the date is greater than the current lastlabordate not every time.
Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.10.130, Progress 9.1C
-----Original Message-----
From: Michael D. Howard [mailto:mike@...]
Sent: Wednesday, April 30, 2003 8:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] LastLaborDate on JobOper
Can't answer as to why JobOper doesn't seem to update for you .. but I have
a similar reporting feature using PartWip.LastActivityDate ... never had a
poblem with it ... might work better for you?
Mike
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, April 29, 2003 2:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] LastLaborDate on JobOper
I'm trying to use the last labor date on JobOper to determine roughly when
the operation was completed (not that they always get marked completed). But
I am notcing that often (but not always) this is returning "?" as if there
is no value there. But when I run the production detail report for the job
it shows labor transactions for the job. Any reason why the JobOper field
is not being updated with the date?
5.20.313
Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/xaxhjB/hdqFAA/bW3JAA/PhFolB/TM
---------------------------------------------------------------------~->
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/