Vantage 8 - Way to see change history on an Employee record

Yahoo Archive
1
Hi Ted,


Thanks for the tip.

>> You can try this bit of code and hook it to a button click event.
>>Dim edvRes As EpiDataView = CType(oTrans.EpiDataViews("Resource"), EpiDataView)
>>Dim resIdent As String = edvRes.dataView(edvRes.Row)("RowIdent")
>>Dim chg As Epicor.Mfg.UI.App.ChgLogEntry.ChgLogArgs
>>chg.Start(oTrans, "Resource", resIdent, True)
>> I Found the example in this post:
>> http://tech.groups.yahoo.com/group/vantage/message/95340

I tested and it worked well.
FYI - I added these assembly references to the form too.
- Epicor.Mfg.AD.ChgLog
- Epicor.MFG.BO.ChgLog
- Epicor.Mfg.IF.IChgLog



>
> Hope it helps,
> -Ted
>
>
>
> ________________________________
> From: b_ordway <cooner_55421@...>
> To: vantage@yahoogroups.com
> Sent: Friday, December 28, 2012 1:11 PM
> Subject: [Vantage] Re: Vantage 8 - Way to see change history on an Employee record
>
> Hi Jeanette,
>
> Do you know if your system set up includes a BAM to create the change logs? You may need to set that up first.
>
> EmpBasic table BAM for a "Shop Employee".
> (or User table BAM for a "User Account").
> The fields to log changes would be specified in the BAM too.
>
>
> You can then build a BAQ as mentioned.
> ChgLog Table
> - Criteria: TableName = EmpBasic (or User)
> - Changes listed in field: ChgLog.LogTest.
>
>
>
> Like you, I've noticed that not all forms provide access to the change logs.
> I've never tried but maybe someone else on this forum knows how to add them with a customization?
>
>
> --- In vantage@yahoogroups.com, Ted Koch <tkoch77@> wrote:
> >
> > Jeanette,
> >
> > In Epicor 9 you can create a BAQ and look in the ChgLog table. I'm not sure if V8 has the ChgLog table but if it does you should be able to find what you're looking for.
> >
> > Hope it helps,
> > -Ted
> >
> >
> > ________________________________
> >Â From: redden.jeanette <redden.jeanette@>
> > To: vantage@yahoogroups.com
> > Sent: Wednesday, December 26, 2012 1:00 PM
> > Subject: [Vantage] Vantage 8 - Way to see change history on an Employee record
> >Â
> > Need your expertise please.....I am looking to see who made an update on an employee record. I know job tracker has a change log icon that you can see changes, but I do not see this option on the employee record. Is there a log or another method to be able to see this please?
> >
> > Thank you!
> > Jeanette
2
Need your expertise please.....I am looking to see who made an update on an employee record. I know job tracker has a change log icon that you can see changes, but I do not see this option on the employee record. Is there a log or another method to be able to see this please?

Thank you!
Jeanette
3
Jeanette,

In Epicor 9 you can create a BAQ and look in the ChgLog table. I'm not sure if V8 has the ChgLog table but if it does you should be able to find what you're looking for.

Hope it helps,
-Ted


________________________________
From: redden.jeanette <redden.jeanette@...>
To: vantage@yahoogroups.com
Sent: Wednesday, December 26, 2012 1:00 PM
Subject: [Vantage] Vantage 8 - Way to see change history on an Employee record

Need your expertise please.....I am looking to see who made an update on an employee record. I know job tracker has a change log icon that you can see changes, but I do not see this option on the employee record. Is there a log or another method to be able to see this please?

Thank you!
Jeanette



------------------------------------

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/.%c2%a0
(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



[Non-text portions of this message have been removed]
4
Hi Jeanette,

Do you know if your system set up includes a BAM to create the change logs? You may need to set that up first.

EmpBasic table BAM for a "Shop Employee".
(or User table BAM for a "User Account").
The fields to log changes would be specified in the BAM too.


You can then build a BAQ as mentioned.
ChgLog Table
- Criteria: TableName = EmpBasic (or User)
- Changes listed in field: ChgLog.LogTest.



Like you, I've noticed that not all forms provide access to the change logs.
I've never tried but maybe someone else on this forum knows how to add them with a customization?


--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Jeanette,
>
> In Epicor 9 you can create a BAQ and look in the ChgLog table. I'm not sure if V8 has the ChgLog table but if it does you should be able to find what you're looking for.
>
> Hope it helps,
> -Ted
>
>
> ________________________________
> From: redden.jeanette <redden.jeanette@...>
> To: vantage@yahoogroups.com
> Sent: Wednesday, December 26, 2012 1:00 PM
> Subject: [Vantage] Vantage 8 - Way to see change history on an Employee record
>
> Need your expertise please.....I am looking to see who made an update on an employee record. I know job tracker has a change log icon that you can see changes, but I do not see this option on the employee record. Is there a log or another method to be able to see this please?
>
> Thank you!
> Jeanette
>
>
>
> ------------------------------------
>
> 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/.%c2%a0
> (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
>
>
>
> [Non-text portions of this message have been removed]
>
5
You can try this bit of code and hook it to a button click event. This example shows how to get the change log to show on Resource Group Maintenance since there is no button for it on the standard toolbar.

      Dim edvRes As EpiDataView = CType(oTrans.EpiDataViews("Resource"), EpiDataView)
      Dim resIdent As String = edvRes.dataView(edvRes.Row)("RowIdent")
      Dim chg As Epicor.Mfg.UI.App.ChgLogEntry.ChgLogArgs
      chg.Start(oTrans, "Resource", resIdent, True)


I Found the example in this post: http://tech.groups.yahoo.com/group/vantage/message/95340

Hope it helps,
-Ted



________________________________
From: b_ordway <cooner_55421@...>
To: vantage@yahoogroups.com
Sent: Friday, December 28, 2012 1:11 PM
Subject: [Vantage] Re: Vantage 8 - Way to see change history on an Employee record

Hi Jeanette,

Do you know if your system set up includes a BAM to create the change logs? You may need to set that up first.

EmpBasic table BAM for a "Shop Employee".
(or User table BAM for a "User Account").
The fields to log changes would be specified in the BAM too.


You can then build a BAQ as mentioned.
ChgLog Table
- Criteria: TableName = EmpBasic (or User)
- Changes listed in field: ChgLog.LogTest.



Like you, I've noticed that not all forms provide access to the change logs.
I've never tried but maybe someone else on this forum knows how to add them with a customization?


--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Jeanette,
>
> In Epicor 9 you can create a BAQ and look in the ChgLog table. I'm not sure if V8 has the ChgLog table but if it does you should be able to find what you're looking for.
>
> Hope it helps,
> -Ted
>
>
> ________________________________
>Â From: redden.jeanette <redden.jeanette@...>
> To: vantage@yahoogroups.com
> Sent: Wednesday, December 26, 2012 1:00 PM
> Subject: [Vantage] Vantage 8 - Way to see change history on an Employee record
>Â
> Need your expertise please.....I am looking to see who made an update on an employee record. I know job tracker has a change log icon that you can see changes, but I do not see this option on the employee record. Is there a log or another method to be able to see this please?
>
> Thank you!
> Jeanette
>
>
>
> ------------------------------------
>
> 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/.%c2%a0
> (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
>
>
>
> [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/.%c2%a0
(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



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