Last activity date

system · November 19, 2012, 4:31pm

Yep, sort by TranNum Descending. The first record will be the most recent.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Karen Schoenung
Sent: Monday, November 19, 2012 4:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Last activity date

How about last TranNum? I think that should work...

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Neil Buckman
Sent: Monday, November 19, 2012 2:48 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Last activity date

Thanks Jose,

How do I pick the most recent date out? Using First or Last does not work...

- Neil

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On
Behalf Of Jose Gomez
Sent: Tuesday, 20 November 2012 12:18 AM
To: Vantage
Subject: Re: [Vantage] Last activity date

PartTran TransactioDate will be your best bet.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Mon, Nov 19, 2012 at 6:07 AM, nbuckman@...
<mailto:nbuckman%40ymail.com> <mailto:nbuckman%40ymail.com> <
nbuckman@...
<mailto:nbuckman%40gibsonshopfitters.com.au>
<mailto:nbuckman%40gibsonshopfitters.com.au>> wrote:

> **
>
>
>
> Hello,
>
> Can anyone give me some tips on how I can find or calculate the date a
> part was last active?
>
> I know that PartDtl has the future demand and supply in it, and
> PartTran has transactions. How do I find the date of the last
> transaction using a BAQ?
>
> Thanks,
>
> - Neil
>
>
>

[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/.
<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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

Notice:This e-mail and any attachments are confidential and are only for the
use of the person to whom they are addressed. If you are not the intended
recipient please advise the sender by return e-mail and delete the message
and any attachments. Any use, interference with, disclosure or copying of
this message or any attachments is unauthorised and prohibited. The sender
does not warrant that the information is free of a virus or any other defect
or error, and any views expressed herein, unless specifically indicated
otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5405 - Release Date: 11/19/12

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5405 - Release Date: 11/19/12

[Non-text portions of this message have been removed]

system · November 19, 2012, 6:07am

Hello,

Can anyone give me some tips on how I can find or calculate the date a part was last active?

I know that PartDtl has the future demand and supply in it, and PartTran has transactions. How do I find the date of the last transaction using a BAQ?

Thanks,

- Neil

system · November 19, 2012, 8:19am

PartTran TransactioDate will be your best bet.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Mon, Nov 19, 2012 at 6:07 AM, nbuckman@... <
nbuckman@...> wrote:

> **
>
>
>
> Hello,
>
> Can anyone give me some tips on how I can find or calculate the date a
> part was last active?
>
> I know that PartDtl has the future demand and supply in it, and PartTran
> has transactions. How do I find the date of the last transaction using a
> BAQ?
>
> Thanks,
>
> - Neil
>
>
>

[Non-text portions of this message have been removed]

system · November 19, 2012, 10:24am

If lots are active, partlot contains a lastrefdate field that can be useful. However, parttran.trandate is my go to for this type of trace.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Monday, November 19, 2012 6:18 AM
To: Vantage
Subject: Re: [Vantage] Last activity date

PartTran TransactioDate will be your best bet.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Mon, Nov 19, 2012 at 6:07 AM, nbuckman@... < nbuckman@...> wrote:

> **
>
>
>
> Hello,
>
> Can anyone give me some tips on how I can find or calculate the date a
> part was last active?
>
> I know that PartDtl has the future demand and supply in it, and
> PartTran has transactions. How do I find the date of the last
> transaction using a BAQ?
>
> Thanks,
>
> - Neil
>
>
>

[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/linksYahoo! Groups Links

system · November 19, 2012, 3:48pm

Thanks Jose,

How do I pick the most recent date out? Using First or Last does not work...

- Neil

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, 20 November 2012 12:18 AM
To: Vantage
Subject: Re: [Vantage] Last activity date

PartTran TransactioDate will be your best bet.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Mon, Nov 19, 2012 at 6:07 AM, nbuckman@... < nbuckman@...> wrote:

> **
>
>
>
> Hello,
>
> Can anyone give me some tips on how I can find or calculate the date a
> part was last active?
>
> I know that PartDtl has the future demand and supply in it, and
> PartTran has transactions. How do I find the date of the last
> transaction using a BAQ?
>
> Thanks,
>
> - Neil
>
>
>

[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/linksYahoo! Groups Links

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

system · November 19, 2012, 4:21pm

How about last TranNum? I think that should work...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Neil Buckman
Sent: Monday, November 19, 2012 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Last activity date

Thanks Jose,

How do I pick the most recent date out? Using First or Last does not work...

- Neil

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Jose Gomez
Sent: Tuesday, 20 November 2012 12:18 AM
To: Vantage
Subject: Re: [Vantage] Last activity date

PartTran TransactioDate will be your best bet.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Mon, Nov 19, 2012 at 6:07 AM, nbuckman@...<mailto:nbuckman%40ymail.com> < nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au>> wrote:

> **
>
>
>
> Hello,
>
> Can anyone give me some tips on how I can find or calculate the date a
> part was last active?
>
> I know that PartDtl has the future demand and supply in it, and
> PartTran has transactions. How do I find the date of the last
> transaction using a BAQ?
>
> Thanks,
>
> - Neil
>
>
>

[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/.<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/linksYahoo! Groups Links

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

system · November 19, 2012, 4:26pm

I thought someone had posted this report on the files sections of the group....not to say that Jose or Karen doesn't know what they are talking about.

There is a files section with reports like this and other goodies as well! Just to refresh your memories, guys!

M. Manasa Reddy
manasa@...<mailto:manasa@...>
630.806.2000 x1515

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Neil Buckman
Sent: Monday, November 19, 2012 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Last activity date

Thanks Jose,

How do I pick the most recent date out? Using First or Last does not work...

- Neil

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Jose Gomez
Sent: Tuesday, 20 November 2012 12:18 AM
To: Vantage
Subject: Re: [Vantage] Last activity date

PartTran TransactioDate will be your best bet.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Mon, Nov 19, 2012 at 6:07 AM, nbuckman@...<mailto:nbuckman%40ymail.com> < nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au>> wrote:

> **
>
>
>
> Hello,
>
> Can anyone give me some tips on how I can find or calculate the date a
> part was last active?
>
> I know that PartDtl has the future demand and supply in it, and
> PartTran has transactions. How do I find the date of the last
> transaction using a BAQ?
>
> Thanks,
>
> - Neil
>
>
>

[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/.<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/linksYahoo! Groups Links

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]