Part Creation Date

You could try populating one of the character## (or shortchar##) fields in Customer or Vendor to be set equal to the Integer type CustNum or VendorNum. Trigger it via a post process (BPM) or AfterMethod (client VB customization) of the Customer or Vendor BO's New method.

That would allow you to create a BAQ join to ChgLog through these char fields rather than the Cust/VendorNum fields.

To make it all neat and tidy, you'd probably want to go backfill the char field data in any existing records.

Make sense or am I missing the intent entirely?

Rob



--- On Fri, 11/28/08, Brian W, Spolarich <bspolarich@...> wrote:
From: Brian W, Spolarich <bspolarich@...>
Subject: Re: [Vantage] Re: Part Creation Date
To: vantage@yahoogroups.com
Date: Friday, November 28, 2008, 3:47 PM











I have one better. All of those changelog records are stored in the

chglog table, with the primary ID of the changed record in the Key1 field

(if I recall) as a string.



So I can write a BAQ that queries for that and joins it with Part

information and generate a ³Part Change Log² report that shows just new

parts, or modified parts, etc.



However I can¹t do the same thing with the Customer or Vendor tables,

because the Key1 value stored in ChgLog is CustNum or VendorNum, and that

field is an integer in the source table and a string in the Chglog table.

The resulting BAQ returns no data because of (presumably) the type mismatch.



Is there any way around this? I¹d like to be able to provide BAQs that

show new customers, new vendors, etc. in a generic way.



-bws



On 11/26/08 12:40 PM, "Nigel Kerley" <nigel.kerley@ johnhinde. com> wrote:



>

>

>

> If you're just looking for the date, and don't want to use it for

> anything: we have a BAM setup against the Part table, the only field

> selected is PartNum and Create Log is ticked.

>

> This records the date/time that a Part is created and the User that

> created it.

>

> To view, we just open the Part in Part Maintenance and slect Change

> Log from the Actions menu.



[Non-text portions of this message have been removed]
Does anyone know a quick way to get the date that a part number was
entered into the system? I did not see that field in the part table or
the partdtl table. I have added a ud field that is supposed to default
to the current date on a new add but if the user duplicates a part, it
brings over the date from the original record. I am logging this
information but trying to parse the chglog table through Crystal is
terribly slow. Is there somewhere else this information may be kept?

Thanks
Kersten
We have wanted this information as well but the only thing we have come up
with is turning on the logging and getting it through that.







_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
kam4085
Sent: Wednesday, November 26, 2008 11:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Creation Date



Does anyone know a quick way to get the date that a part number was
entered into the system? I did not see that field in the part table or
the partdtl table. I have added a ud field that is supposed to default
to the current date on a new add but if the user duplicates a part, it
brings over the date from the original record. I am logging this
information but trying to parse the chglog table through Crystal is
terribly slow. Is there somewhere else this information may be kept?

Thanks
Kersten



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.10/1810 - Release Date: 11/26/2008
8:53 AM




[Non-text portions of this message have been removed]
You could use a BPM to set the date field, part.getnewpart would be the method you want.







________________________________
From: kam4085 <kmaclennan@...>
To: vantage@yahoogroups.com
Sent: Wednesday, November 26, 2008 10:52:48 AM
Subject: [Vantage] Part Creation Date


Does anyone know a quick way to get the date that a part number was
entered into the system? I did not see that field in the part table or
the partdtl table. I have added a ud field that is supposed to default
to the current date on a new add but if the user duplicates a part, it
brings over the date from the original record. I am logging this
information but trying to parse the chglog table through Crystal is
terribly slow. Is there somewhere else this information may be kept?

Thanks
Kersten






[Non-text portions of this message have been removed]
If you're just looking for the date, and don't want to use it for
anything: we have a BAM setup against the Part table, the only field
selected is PartNum and Create Log is ticked.

This records the date/time that a Part is created and the User that
created it.

To view, we just open the Part in Part Maintenance and slect Change
Log from the Actions menu.

Nigel.


--- In vantage@yahoogroups.com, "kam4085" <kmaclennan@...> wrote:
>
> Does anyone know a quick way to get the date that a part number was
> entered into the system? I did not see that field in the part table
or
> the partdtl table. I have added a ud field that is supposed to
default
> to the current date on a new add but if the user duplicates a part,
it
> brings over the date from the original record. I am logging this
> information but trying to parse the chglog table through Crystal is
> terribly slow. Is there somewhere else this information may be kept?
>
> Thanks
> Kersten
>
Kersten,

There was a lab at perspectives which did exactly as you are asking
about. The BPM Lab Part 2 Excercise one: Display Created by and date
information. The exercise talks about doing this for the ABCcode part I
walked through it and actually did it for the Part. It appears to be
working for us. I have not confirmed what date it uses when a part is
duplicated but for new parts it appears correct. I will try to test for
duplicating parts.

Jim

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Wednesday, November 26, 2008 11:30 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Part Creation Date



You could use a BPM to set the date field, part.getnewpart would be the
method you want.

________________________________
From: kam4085 <kmaclennan@... <mailto:kmaclennan%40semrock.com>
>
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, November 26, 2008 10:52:48 AM
Subject: [Vantage] Part Creation Date

Does anyone know a quick way to get the date that a part number was
entered into the system? I did not see that field in the part table or
the partdtl table. I have added a ud field that is supposed to default
to the current date on a new add but if the user duplicates a part, it
brings over the date from the original record. I am logging this
information but trying to parse the chglog table through Crystal is
terribly slow. Is there somewhere else this information may be kept?

Thanks
Kersten

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






[Non-text portions of this message have been removed]
Same here: Change log.
Rob

--- On Wed, 11/26/08, Charlie Wilson <foamdesigncsw@...> wrote:

From: Charlie Wilson <foamdesigncsw@...>
Subject: RE: [Vantage] Part Creation Date
To: vantage@yahoogroups.com
Date: Wednesday, November 26, 2008, 12:19 PM






We have wanted this information as well but the only thing we have come up
with is turning on the logging and getting it through that.

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
kam4085
Sent: Wednesday, November 26, 2008 11:53 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Part Creation Date

Does anyone know a quick way to get the date that a part number was
entered into the system? I did not see that field in the part table or
the partdtl table. I have added a ud field that is supposed to default
to the current date on a new add but if the user duplicates a part, it
brings over the date from the original record. I am logging this
information but trying to parse the chglog table through Crystal is
terribly slow. Is there somewhere else this information may be kept?

Thanks
Kersten

No virus found in this incoming message.
Checked by AVG - http://www.avg com
Version: 8.0.175 / Virus Database: 270.9.10/1810 - Release Date: 11/26/2008
8:53 AM

[Non-text portions of this message have been removed]
Change log is not a flexible tool for saving/tracking changes. The
biggest disadvantage is that you need to open particular record to be
able to obtain a changes for it.
Moreover - the way how 'ChangeLog' is loging data into table makes very
difficult to analyze the information.

I would suggest to create a simple BPM that can do it for you.

Grzegorz Szczepański

Dnia Wed, 26 Nov 2008 17:40:30 -0000
"Nigel Kerley" <nigel.kerley@...> napisał(a):

> If you're just looking for the date, and don't want to use it for
> anything: we have a BAM setup against the Part table, the only field
> selected is PartNum and Create Log is ticked.
>
> This records the date/time that a Part is created and the User that
> created it.
>
> To view, we just open the Part in Part Maintenance and slect Change
> Log from the Actions menu.
>
> Nigel.
>
>
> --- In vantage@yahoogroups.com, "kam4085" <kmaclennan@...> wrote:
> >
> > Does anyone know a quick way to get the date that a part number was
> > entered into the system? I did not see that field in the part table
> or
> > the partdtl table. I have added a ud field that is supposed to
> default
> > to the current date on a new add but if the user duplicates a part,
> it
> > brings over the date from the original record. I am logging this
> > information but trying to parse the chglog table through Crystal is
> > terribly slow. Is there somewhere else this information may be kept?
> >
> > Thanks
> > Kersten
> >
>
>
I have one better. All of those changelog records are stored in the
chglog table, with the primary ID of the changed record in the Key1 field
(if I recall) as a string.

So I can write a BAQ that queries for that and joins it with Part
information and generate a ³Part Change Log² report that shows just new
parts, or modified parts, etc.

However I can¹t do the same thing with the Customer or Vendor tables,
because the Key1 value stored in ChgLog is CustNum or VendorNum, and that
field is an integer in the source table and a string in the Chglog table.
The resulting BAQ returns no data because of (presumably) the type mismatch.

Is there any way around this? I¹d like to be able to provide BAQs that
show new customers, new vendors, etc. in a generic way.

-bws


On 11/26/08 12:40 PM, "Nigel Kerley" <nigel.kerley@...> wrote:

>
>
>
> If you're just looking for the date, and don't want to use it for
> anything: we have a BAM setup against the Part table, the only field
> selected is PartNum and Create Log is ticked.
>
> This records the date/time that a Part is created and the User that
> created it.
>
> To view, we just open the Part in Part Maintenance and slect Change
> Log from the Actions menu.



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