Job Last Activity date

Yahoo Archive
1
Vantage 8.03.408A

Depending on what you are looking for you may need to watch.

I just wrote a BAQ Report where Production Control wanted to see the Last Activity Date (JobOper.LastLaborDate) on Open Jobs. They were not concerned with the Last Activity Date of each operation. They only wanted the most recent posting on the entire Job. To do this I had to perform that filter in my Crystal Report (could not be done in the BAQ). The suggestion from this group was to use the 'Max' option on JobOper.LastLaborDate. Worked like a charm.

My BAQ shows me all the operations with the Last Activity Date. If that is what you want you should be golden. Otherwise, you want to consider the above thought.

Jeff

--- In vantage@yahoogroups.com, "benoit.marquez" <benoit.desjardins@...> wrote:
>
> Is there a table with the date or time of last activity on a given job, whether it be a material transaction, labour transaction,...
>
> Many thanks
>
2
Is there a table with the date or time of last activity on a given job, whether it be a material transaction, labour transaction,...

Many thanks
3
Under the table JobOper look for the coloum LastLaborDate, this gives us the last activity of labor on the job.
Â
Â
--- On Wed, 6/30/10, benoit.marquez <benoit.desjardins@...> wrote:


From: benoit.marquez <benoit.desjardins@...>
Subject: [Vantage] Job Last Activity date
To: vantage@yahoogroups.com
Date: Wednesday, June 30, 2010, 11:07 AM


Â



Is there a table with the date or time of last activity on a given job, whether it be a material transaction, labour transaction,...

Many thanks











[Non-text portions of this message have been removed]
4
The best table for ALL inquires is the parttran table







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of benoit.marquez
Sent: Wednesday, June 30, 2010 11:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Last Activity date





Is there a table with the date or time of last activity on a given job,
whether it be a material transaction, labour transaction,...

Many thanks





[Non-text portions of this message have been removed]
5
Perfect thank you!

--- In vantage@yahoogroups.com, Doma Reddy <domareddy@...> wrote:
>
> Under the table JobOper look for the coloum LastLaborDate, this gives us the last activity of labor on the job.
> ÂÂ
> ÂÂ
> --- On Wed, 6/30/10, benoit.marquez <benoit.desjardins@...> wrote:
>
>
> From: benoit.marquez <benoit.desjardins@...>
> Subject: [Vantage] Job Last Activity date
> To: vantage@yahoogroups.com
> Date: Wednesday, June 30, 2010, 11:07 AM
>
>
> ÂÂ
>
>
>
> Is there a table with the date or time of last activity on a given job, whether it be a material transaction, labour transaction,...
>
> Many thanks
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>