Jobs Entered Daily Report Builder Report

Yahoo Archive
1
If all of your jobs are linked to sales order and the job is created the
same day the Sales order is created (like it is here), you can use the
earliest Sales Order date from the OrderHead table or from the booking
table. This is what we do here, and it works well for us.




[Non-text portions of this message have been removed]
2
I am suppose write a Report Builder report which should have been a
peice of cake. Job#, PartNum, ProdQty, DueDate, CompletedDate. The
only thing I am missing is the date the Job was created which is the
point of the report. Is there a system date somewhere that I can
join to JobHead table?? I've tried ChangeDate in the JobAudit Table
and looked in PartTran, but no luck. Hopefully we don't have to add
another User Field. Any help is appreciated. Thanks!!

Ann Harrell
AMFAB
219-264-2190
3
I looked for this for months and ended up with a user field. It would have
been enormously useful if a date/time stamp and username had been added to
the JobHead table (and other tables) when a new record is created.
-Todd C.

-----Original Message-----
From: amfabllc [mailto:amfab@...]
Sent: Thursday, February 07, 2002 8:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Jobs Entered Daily Report Builder Report


I am suppose write a Report Builder report which should have been a
peice of cake. Job#, PartNum, ProdQty, DueDate, CompletedDate. The
only thing I am missing is the date the Job was created which is the
point of the report. Is there a system date somewhere that I can
join to JobHead table?? I've tried ChangeDate in the JobAudit Table
and looked in PartTran, but no luck. Hopefully we don't have to add
another User Field. Any help is appreciated. Thanks!!

Ann Harrell
AMFAB
219-264-2190



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=221000.1882886.3380087.1261774/D=egroupweb/S=17050071
83:HM/A=965713/R=0/O=1/I=brandr-promo-flowersale-lrecg/*http://shopping.yaho
o.com/promotions/flowers/index.html>

<http://us.adserver.yahoo.com/l?M=221000.1882886.3380087.1261774/D=egroupmai
l/S=1705007183:HM/A=965713/rand=656165960>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
4
I think I remember a similar thread from a few months back. You
could write a small Progress program executing every evening which
updates one of the VB form reserved fields (Date01 - 05). Something
like...

/* override db write triggers */
ON write OF jobhead OVERRIDE DO: END.

/* record in log */
output to x:\JobLog.txt append.
put "Program Running " at 1 today format "99/99/9999".

for each jobhead where jobhead.company = "YourCompanyField"
and jobhead.date01 = ? break by jobhead.jobnum:
jobhead.date01 = today.
put jobhead.jobnum at 1 format "x(20)" today at 22
format "99/99/9999".
end.

... running from a task scheduler in Windows with command line such
as...

F:\epic50\progress\bin\prowin32.exe vantage -q -N TCP -H Bdc_lon -S
epic50 -p x:\vantage\ud\udJob.p.

You could even have this program automatically run your Report
Builder report every day or week.

Lonnie

--- In vantage@y..., Todd Caughey <caugheyt@h...> wrote:
> I looked for this for months and ended up with a user field. It
would have
> been enormously useful if a date/time stamp and username had been
added to
> the JobHead table (and other tables) when a new record is created.
> -Todd C.
>
> -----Original Message-----
> From: amfabllc [mailto:amfab@a...]
> Sent: Thursday, February 07, 2002 8:04 AM
> To: vantage@y...
> Subject: [Vantage] Jobs Entered Daily Report Builder Report
>
>
> I am suppose write a Report Builder report which should have been a
> peice of cake. Job#, PartNum, ProdQty, DueDate, CompletedDate.
The
> only thing I am missing is the date the Job was created which is
the
> point of the report. Is there a system date somewhere that I can
> join to JobHead table?? I've tried ChangeDate in the JobAudit
Table
> and looked in PartTran, but no luck. Hopefully we don't have to
add
> another User Field. Any help is appreciated. Thanks!!
>
> Ann Harrell
> AMFAB
> 219-264-2190
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=221000.1882886.3380087.1261774/D=egroupweb/S=17
050071
> 83:HM/A=965713/R=0/O=1/I=brandr-promo-flowersale-
lrecg/*http://shopping.yaho
> o.com/promotions/flowers/index.html>
>
> <http://us.adserver.yahoo.com/l?
M=221000.1882886.3380087.1261774/D=egroupmai
> l/S=1705007183:HM/A=965713/rand=656165960>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]