Vantage - Quote Table Problems

Rod Serling??

If our quote is set to expire today, it will actually show that an MES user changed the quote tomorrow as I guess it has until 11.59.59pm tonight before it expires therefore, by the time that the check is done (by the process which runs when a user logs on) it is actually tomorrow so the process back tracks, finds all quotes set to expire last night and changes them to expired.

All of the changes occur within Time = 100 which I can only assume to be seconds from midnight. So if there are a lot of quotes, I guess it goes through each one - one by one changing the status.

I have found that the change logs dont work properly. We have had people 'making changes' to customers who don't even deal with those customers and the changes they are making arent relevant to the customer in question so unless I have something set up wrong (which I dont think I do), I have little faith in the change logs.

I have analised the BAQ against the QuoteHed.ChangedBy against some (not all) of the quotes where MES users have changed quotes. Most, not all of the ones that I checked mentioned the shopfloor user in the change log on the quote, but others didnt which throughs another spanner in the works.




________________________________
From: leann_37 <lmarruffo@...>
To: vantage@yahoogroups.com
Sent: Tue, 19 January, 2010 19:12:20
Subject: [Vantage] Re: Vantage - Quote Table Problems

Â
Well, this adds a new dimension. I looked at a few of the quotes that the query believe to have been changed by someone with no access, but in my change logs, they aren't there at all. I also don't have a sales order created by conversion on that date. (??) As seen below, the change that I can't see comes one day after the expiration date. I queried the chglog table for tablename = 'QuoteHed' and key1 = 'quotenum', and there is no entry with the data from the query... though it does show the expiration and closure of the quote ocrrectly.
huh. Any day now, Rod Serling is going to step out from behind the office door...
- leAnn

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi Linda,
>
> Yes, our expiry date is set to 30 days as default. In your change log did it say that Manger and DataCollector were the last people to make changes?
>
> Thanks,
>
>
> CHRIS
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@... >
> To: vantage@yahoogroups .com
> Sent: Mon, 18 January, 2010 16:50:28
> Subject: RE: [Vantage] Vantage - Quote Table Problems
>
> ÂÂ
> Hi Chris,
>
> Is your quote expiry date set for 30 days? I tried your query and
> notice that sometimes the ChangedBy was MANAGER and sometimes it was
> DataCollector. When I looked at the change log for these quotes that
> last transaction was Expired: no->yes.
>
> Hth,
>
> Linda
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
> Of Chris Thompson
> Sent: Monday, January 18, 2010 9:55 AM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Vantage - Quote Table Problems
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that
> changes have been made to Quotations by people who don't even have
> access to the Opportunity/ Quote Entry screen, most of which are actually
> only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you
> to try the same BAQ and see if you get similar results (i.e. where
> ChangedBy user was not associated/had no access to the Opportunity/ Quote
> Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of
> the quotes were last changed by somebody who would NEVER touch
> Opportunity/ Quote Entry or anything to do with the Sales side of the
> company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who
> ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed
> by non-sales staff are done ChangeTime < 100 (i assume this to be
> seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be
> interested to see if it IS happening, but users didnt realise that it
> was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be
> appreciated.
>
> Thanks,
>
> CHRIS THOMPSON
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







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

Im wondering if you can help.

We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/Quote Entry screen, most of which are actually only MES users.

To confirm this, I did a very simple BAQÂ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/Quote Entry screens)?

The BAQ is as follows:-

Use the QuoteHed table and display the following:

QuoteHed.QuoteNum
QuoteHed.ChangedBy
QuoteHed.EntryDate
QuoteHed.ChangeDate
QuoteHed.ChangeBy

According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/Quote Entry or anything to do with the Sales side of the company.

Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.

Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).

They all tend to be changed 30 days from the Entry Date of the quote.

Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.

If you could have a try of the BAQ and let me know the results it'd be appreciated.

Thanks,


CHRIS THOMPSON




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



Is your quote expiry date set for 30 days? I tried your query and
notice that sometimes the ChangedBy was MANAGER and sometimes it was
DataCollector. When I looked at the change log for these quotes that
last transaction was Expired: no->yes.



Hth,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Monday, January 18, 2010 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - Quote Table Problems





Hi All,

Im wondering if you can help.

We are having a problem where our Change Logs are telling us that
changes have been made to Quotations by people who don't even have
access to the Opportunity/Quote Entry screen, most of which are actually
only MES users.

To confirm this, I did a very simple BAQ - Would it be possible for you
to try the same BAQ and see if you get similar results (i.e. where
ChangedBy user was not associated/had no access to the Opportunity/Quote
Entry screens)?

The BAQ is as follows:-

Use the QuoteHed table and display the following:

QuoteHed.QuoteNum
QuoteHed.ChangedBy
QuoteHed.EntryDate
QuoteHed.ChangeDate
QuoteHed.ChangeBy

According to my BAQ, out of 4207 quotes done since going live, 3296 of
the quotes were last changed by somebody who would NEVER touch
Opportunity/Quote Entry or anything to do with the Sales side of the
company.

Out of these 3296, 1326 of them were changed by ShopFloor terminals who
ONLY have access to the MES modules and that is all.

Generally I find that the ChangeTime for the ones that have been changed
by non-sales staff are done ChangeTime < 100 (i assume this to be
seconds from midnight).

They all tend to be changed 30 days from the Entry Date of the quote.

Epicor say that they haven't come across this before so I would be
interested to see if it IS happening, but users didnt realise that it
was happening.

If you could have a try of the BAQ and let me know the results it'd be
appreciated.

Thanks,

CHRIS THOMPSON

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





[Non-text portions of this message have been removed]
Ironically, we just discovered the same problem a couple of weeks ago. We use DCUser for all of our MES stations and this user-id can't do anything else. It has no Security Groups assigned to it and you must be in the Quotes group to maintain Quotes. Yet it shows up as the last user changing quote headers/lines frequently.

Please let me know your incident number and I'll report it as well. Thanks.
----- Original Message -----
From: Chris Thompson
To: vantage@yahoogroups.com
Sent: Monday, January 18, 2010 6:54 AM
Subject: [Vantage] Vantage - Quote Table Problems


Hi All,

Im wondering if you can help.

We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/Quote Entry screen, most of which are actually only MES users.

To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/Quote Entry screens)?

The BAQ is as follows:-

Use the QuoteHed table and display the following:

QuoteHed.QuoteNum
QuoteHed.ChangedBy
QuoteHed.EntryDate
QuoteHed.ChangeDate
QuoteHed.ChangeBy

According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/Quote Entry or anything to do with the Sales side of the company.

Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.

Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).

They all tend to be changed 30 days from the Entry Date of the quote.

Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.

If you could have a try of the BAQ and let me know the results it'd be appreciated.

Thanks,


CHRIS THOMPSON




[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




[Non-text portions of this message have been removed]
FYI: I created your BAQ and had the same results - non Quote users
showing up.



8.03.407C



Randy Weber



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Monday, January 18, 2010 8:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - Quote Table Problems





Hi All,

Im wondering if you can help.

We are having a problem where our Change Logs are telling us that
changes have been made to Quotations by people who don't even have
access to the Opportunity/Quote Entry screen, most of which are actually
only MES users.

To confirm this, I did a very simple BAQ - Would it be possible for you
to try the same BAQ and see if you get similar results (i.e. where
ChangedBy user was not associated/had no access to the Opportunity/Quote
Entry screens)?

The BAQ is as follows:-

Use the QuoteHed table and display the following:

QuoteHed.QuoteNum
QuoteHed.ChangedBy
QuoteHed.EntryDate
QuoteHed.ChangeDate
QuoteHed.ChangeBy

According to my BAQ, out of 4207 quotes done since going live, 3296 of
the quotes were last changed by somebody who would NEVER touch
Opportunity/Quote Entry or anything to do with the Sales side of the
company.

Out of these 3296, 1326 of them were changed by ShopFloor terminals who
ONLY have access to the MES modules and that is all.

Generally I find that the ChangeTime for the ones that have been changed
by non-sales staff are done ChangeTime < 100 (i assume this to be
seconds from midnight).

They all tend to be changed 30 days from the Entry Date of the quote.

Epicor say that they haven't come across this before so I would be
interested to see if it IS happening, but users didnt realise that it
was happening.

If you could have a try of the BAQ and let me know the results it'd be
appreciated.

Thanks,

CHRIS THOMPSON

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





[Non-text portions of this message have been removed]
We show the exact same thing. ChangeDate = QuoteHed.Expires+1, ChangeTime = 3600, ChangedBy = our MES user

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQÂ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>
Hi Linda,

Yes, our expiry date is set to 30 days as default. In your change log did it say that Manger and DataCollector were the last people to make changes?

Thanks,


CHRIS




________________________________
From: Linda Lowney <llowney@...>
To: vantage@yahoogroups.com
Sent: Mon, 18 January, 2010 16:50:28
Subject: RE: [Vantage] Vantage - Quote Table Problems

Â
Hi Chris,

Is your quote expiry date set for 30 days? I tried your query and
notice that sometimes the ChangedBy was MANAGER and sometimes it was
DataCollector. When I looked at the change log for these quotes that
last transaction was Expired: no->yes.

Hth,

Linda

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Monday, January 18, 2010 9:55 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Vantage - Quote Table Problems

Hi All,

Im wondering if you can help.

We are having a problem where our Change Logs are telling us that
changes have been made to Quotations by people who don't even have
access to the Opportunity/ Quote Entry screen, most of which are actually
only MES users.

To confirm this, I did a very simple BAQ - Would it be possible for you
to try the same BAQ and see if you get similar results (i.e. where
ChangedBy user was not associated/had no access to the Opportunity/ Quote
Entry screens)?

The BAQ is as follows:-

Use the QuoteHed table and display the following:

QuoteHed.QuoteNum
QuoteHed.ChangedBy
QuoteHed.EntryDate
QuoteHed.ChangeDate
QuoteHed.ChangeBy

According to my BAQ, out of 4207 quotes done since going live, 3296 of
the quotes were last changed by somebody who would NEVER touch
Opportunity/ Quote Entry or anything to do with the Sales side of the
company.

Out of these 3296, 1326 of them were changed by ShopFloor terminals who
ONLY have access to the MES modules and that is all.

Generally I find that the ChangeTime for the ones that have been changed
by non-sales staff are done ChangeTime < 100 (i assume this to be
seconds from midnight).

They all tend to be changed 30 days from the Entry Date of the quote.

Epicor say that they haven't come across this before so I would be
interested to see if it IS happening, but users didnt realise that it
was happening.

If you could have a try of the BAQ and let me know the results it'd be
appreciated.

Thanks,

CHRIS THOMPSON

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

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







[Non-text portions of this message have been removed]
By incident number, do you mean call number?

Thanks,

CHRIS




________________________________
From: Chris Robisch <bluewine@...>
To: vantage@yahoogroups.com
Sent: Mon, 18 January, 2010 16:56:56
Subject: Re: [Vantage] Vantage - Quote Table Problems

Â
Ironically, we just discovered the same problem a couple of weeks ago. We use DCUser for all of our MES stations and this user-id can't do anything else. It has no Security Groups assigned to it and you must be in the Quotes group to maintain Quotes. Yet it shows up as the last user changing quote headers/lines frequently.

Please let me know your incident number and I'll report it as well. Thanks.
----- Original Message -----
From: Chris Thompson
To: vantage@yahoogroups .com
Sent: Monday, January 18, 2010 6:54 AM
Subject: [Vantage] Vantage - Quote Table Problems

Hi All,

Im wondering if you can help.

We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.

To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?

The BAQ is as follows:-

Use the QuoteHed table and display the following:

QuoteHed.QuoteNum
QuoteHed.ChangedBy
QuoteHed.EntryDate
QuoteHed.ChangeDate
QuoteHed.ChangeBy

According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.

Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.

Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).

They all tend to be changed 30 days from the Entry Date of the quote.

Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.

If you could have a try of the BAQ and let me know the results it'd be appreciated.

Thanks,

CHRIS THOMPSON

[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

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







[Non-text portions of this message have been removed]
By any chance have any of you had any customisations done in the quote screens (either in-house or by CSG)?

Thanks,

CHRIS




________________________________
From: Kirstin Brandt <kirstin.brandt@...>
To: vantage@yahoogroups.com
Sent: Mon, 18 January, 2010 20:51:55
Subject: [Vantage] Re: Vantage - Quote Table Problems

Â
We show the exact same thing. ChangeDate = QuoteHed.Expires+ 1, ChangeTime = 3600, ChangedBy = our MES user

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQÂ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>







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

This is not related to CSG or customisations, it is an element of the framework,

When logging onto the system standard routines get executed one of these expires quotes.

This also applies to data collection users so if they are the first to logon they mark the quotes as expired in the change log.

It doesn’t mean they have access to the menu of the system.



It is a another argument if this is acceptable behaviour, but it is the cause of the behaviour you are experiencing.



Regards,

Stephen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: 19 January 2010 10:14
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Vantage - Quote Table Problems





By any chance have any of you had any customisations done in the quote screens (either in-house or by CSG)?

Thanks,

CHRIS

________________________________
From: Kirstin Brandt <kirstin.brandt@... <mailto:kirstin.brandt%40dat-corp.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Mon, 18 January, 2010 20:51:55
Subject: [Vantage] Re: Vantage - Quote Table Problems


We show the exact same thing. ChangeDate = QuoteHed.Expires+ 1, ChangeTime = 3600, ChangedBy = our MES user

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>

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





[Non-text portions of this message have been removed]
Thank you. Makes sense - although not good.

Have had this logged with Epicor for about 4 months and havent had an answer as to why it is happening.

Did Epicor tell you why it had happened?




________________________________
From: Stephen Edginton <stephene@...>
To: vantage@yahoogroups.com
Sent: Tue, 19 January, 2010 11:08:24
Subject: RE: [Vantage] Re: Vantage - Quote Table Problems

Â
Chris,

This is not related to CSG or customisations, it is an element of the framework,

When logging onto the system standard routines get executed one of these expires quotes.

This also applies to data collection users so if they are the first to logon they mark the quotes as expired in the change log.

It doesn’t mean they have access to the menu of the system.



It is a another argument if this is acceptable behaviour, but it is the cause of the behaviour you are experiencing.



Regards,

Stephen



From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Chris Thompson
Sent: 19 January 2010 10:14
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Re: Vantage - Quote Table Problems





By any chance have any of you had any customisations done in the quote screens (either in-house or by CSG)?

Thanks,

CHRIS

____________ _________ _________ __
From: Kirstin Brandt <kirstin.brandt@ dat-corp. com <mailto:kirstin. brandt%40dat- corp.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Mon, 18 January, 2010 20:51:55
Subject: [Vantage] Re: Vantage - Quote Table Problems


We show the exact same thing. ChangeDate = QuoteHed.Expires+ 1, ChangeTime = 3600, ChangedBy = our MES user

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>

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




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







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



On some quotes it was Manager and other quotes it was DataCollector, but they were all expiry transactions and they were all the last “people” to make changes.



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Tuesday, January 19, 2010 4:55 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage - Quote Table Problems





Hi Linda,

Yes, our expiry date is set to 30 days as default. In your change log did it say that Manger and DataCollector were the last people to make changes?

Thanks,

CHRIS

________________________________
From: Linda Lowney <llowney@... <mailto:llowney%40pridesigns.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Mon, 18 January, 2010 16:50:28
Subject: RE: [Vantage] Vantage - Quote Table Problems


Hi Chris,

Is your quote expiry date set for 30 days? I tried your query and
notice that sometimes the ChangedBy was MANAGER and sometimes it was
DataCollector. When I looked at the change log for these quotes that
last transaction was Expired: no->yes.

Hth,

Linda

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Monday, January 18, 2010 9:55 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Vantage - Quote Table Problems

Hi All,

Im wondering if you can help.

We are having a problem where our Change Logs are telling us that
changes have been made to Quotations by people who don't even have
access to the Opportunity/ Quote Entry screen, most of which are actually
only MES users.

To confirm this, I did a very simple BAQ - Would it be possible for you
to try the same BAQ and see if you get similar results (i.e. where
ChangedBy user was not associated/had no access to the Opportunity/ Quote
Entry screens)?

The BAQ is as follows:-

Use the QuoteHed table and display the following:

QuoteHed.QuoteNum
QuoteHed.ChangedBy
QuoteHed.EntryDate
QuoteHed.ChangeDate
QuoteHed.ChangeBy

According to my BAQ, out of 4207 quotes done since going live, 3296 of
the quotes were last changed by somebody who would NEVER touch
Opportunity/ Quote Entry or anything to do with the Sales side of the
company.

Out of these 3296, 1326 of them were changed by ShopFloor terminals who
ONLY have access to the MES modules and that is all.

Generally I find that the ChangeTime for the ones that have been changed
by non-sales staff are done ChangeTime < 100 (i assume this to be
seconds from midnight).

They all tend to be changed 30 days from the Entry Date of the quote.

Epicor say that they haven't come across this before so I would be
interested to see if it IS happening, but users didnt realise that it
was happening.

If you could have a try of the BAQ and let me know the results it'd be
appreciated.

Thanks,

CHRIS THOMPSON

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

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

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





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



Yes, we have customized quote entry.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Tuesday, January 19, 2010 5:14 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Vantage - Quote Table Problems





By any chance have any of you had any customisations done in the quote screens (either in-house or by CSG)?

Thanks,

CHRIS

________________________________
From: Kirstin Brandt <kirstin.brandt@... <mailto:kirstin.brandt%40dat-corp.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Mon, 18 January, 2010 20:51:55
Subject: [Vantage] Re: Vantage - Quote Table Problems


We show the exact same thing. ChangeDate = QuoteHed.Expires+ 1, ChangeTime = 3600, ChangedBy = our MES user

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>

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





[Non-text portions of this message have been removed]
No I verified this myself while working on another issue.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: 19 January 2010 12:36
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Vantage - Quote Table Problems





Thank you. Makes sense - although not good.

Have had this logged with Epicor for about 4 months and havent had an answer as to why it is happening.

Did Epicor tell you why it had happened?

________________________________
From: Stephen Edginton <stephene@... <mailto:stephene%40dotnetit.co.uk> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 19 January, 2010 11:08:24
Subject: RE: [Vantage] Re: Vantage - Quote Table Problems


Chris,

This is not related to CSG or customisations, it is an element of the framework,

When logging onto the system standard routines get executed one of these expires quotes.

This also applies to data collection users so if they are the first to logon they mark the quotes as expired in the change log.

It doesn’t mean they have access to the menu of the system.

It is a another argument if this is acceptable behaviour, but it is the cause of the behaviour you are experiencing.

Regards,

Stephen

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Chris Thompson
Sent: 19 January 2010 10:14
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Re: Vantage - Quote Table Problems

By any chance have any of you had any customisations done in the quote screens (either in-house or by CSG)?

Thanks,

CHRIS

____________ _________ _________ __
From: Kirstin Brandt <kirstin.brandt@ dat-corp. com <mailto:kirstin. brandt%40dat- corp.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Mon, 18 January, 2010 20:51:55
Subject: [Vantage] Re: Vantage - Quote Table Problems

We show the exact same thing. ChangeDate = QuoteHed.Expires+ 1, ChangeTime = 3600, ChangedBy = our MES user

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

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

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





[Non-text portions of this message have been removed]
You could get a job with them! :-)




________________________________
From: Stephen Edginton <stephene@...>
To: vantage@yahoogroups.com
Sent: Tue, 19 January, 2010 14:27:46
Subject: RE: [Vantage] Re: Vantage - Quote Table Problems

Â
No I verified this myself while working on another issue.



From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Chris Thompson
Sent: 19 January 2010 12:36
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Re: Vantage - Quote Table Problems





Thank you. Makes sense - although not good.

Have had this logged with Epicor for about 4 months and havent had an answer as to why it is happening.

Did Epicor tell you why it had happened?

____________ _________ _________ __
From: Stephen Edginton <stephene@dotnetit. co.uk <mailto:stephene% 40dotnetit. co.uk> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Tue, 19 January, 2010 11:08:24
Subject: RE: [Vantage] Re: Vantage - Quote Table Problems


Chris,

This is not related to CSG or customisations, it is an element of the framework,

When logging onto the system standard routines get executed one of these expires quotes.

This also applies to data collection users so if they are the first to logon they mark the quotes as expired in the change log.

It doesn’t mean they have access to the menu of the system.

It is a another argument if this is acceptable behaviour, but it is the cause of the behaviour you are experiencing.

Regards,

Stephen

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of Chris Thompson
Sent: 19 January 2010 10:14
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Re: Vantage - Quote Table Problems

By any chance have any of you had any customisations done in the quote screens (either in-house or by CSG)?

Thanks,

CHRIS

____________ _________ _________ __
From: Kirstin Brandt <kirstin.brandt@ dat-corp. com <mailto:kirstin. brandt%40dat- corp.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Mon, 18 January, 2010 20:51:55
Subject: [Vantage] Re: Vantage - Quote Table Problems

We show the exact same thing. ChangeDate = QuoteHed.Expires+ 1, ChangeTime = 3600, ChangedBy = our MES user

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

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

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




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







[Non-text portions of this message have been removed]
Yes, the call number. It's helpful to refer to another call number if another customer has already reported it.

The reason we never reported it is we're on 8.03.405a, going to E9, and didn't want to burden Epicor with a problem that perhaps was fixed in a later version. We don't do enough testing in 8.03.408b and thought we'd wait until we're on E9 to see if it keeps happening.

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> By incident number, do you mean call number?
>
> Thanks,
>
> CHRIS
>
>
>
>
> ________________________________
> From: Chris Robisch <bluewine@...>
> To: vantage@yahoogroups.com
> Sent: Mon, 18 January, 2010 16:56:56
> Subject: Re: [Vantage] Vantage - Quote Table Problems
>
> ÂÂ
> Ironically, we just discovered the same problem a couple of weeks ago. We use DCUser for all of our MES stations and this user-id can't do anything else. It has no Security Groups assigned to it and you must be in the Quotes group to maintain Quotes. Yet it shows up as the last user changing quote headers/lines frequently.
>
> Please let me know your incident number and I'll report it as well. Thanks.
> ----- Original Message -----
> From: Chris Thompson
> To: vantage@yahoogroups .com
> Sent: Monday, January 18, 2010 6:54 AM
> Subject: [Vantage] Vantage - Quote Table Problems
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
> CHRIS THOMPSON
>
> [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
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Well, this adds a new dimension. I looked at a few of the quotes that the query believe to have been changed by someone with no access, but in my change logs, they aren't there at all. I also don't have a sales order created by conversion on that date. (??) As seen below, the change that I can't see comes one day after the expiration date. I queried the chglog table for tablename = 'QuoteHed' and key1 = 'quotenum', and there is no entry with the data from the query... though it does show the expiration and closure of the quote ocrrectly.
huh. Any day now, Rod Serling is going to step out from behind the office door...
- leAnn



--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi Linda,
>
> Yes, our expiry date is set to 30 days as default. In your change log did it say that Manger and DataCollector were the last people to make changes?
>
> Thanks,
>
>
> CHRIS
>
>
>
>
> ________________________________
> From: Linda Lowney <llowney@...>
> To: vantage@yahoogroups.com
> Sent: Mon, 18 January, 2010 16:50:28
> Subject: RE: [Vantage] Vantage - Quote Table Problems
>
> ÂÂ
> Hi Chris,
>
> Is your quote expiry date set for 30 days? I tried your query and
> notice that sometimes the ChangedBy was MANAGER and sometimes it was
> DataCollector. When I looked at the change log for these quotes that
> last transaction was Expired: no->yes.
>
> Hth,
>
> Linda
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
> Of Chris Thompson
> Sent: Monday, January 18, 2010 9:55 AM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Vantage - Quote Table Problems
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that
> changes have been made to Quotations by people who don't even have
> access to the Opportunity/ Quote Entry screen, most of which are actually
> only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you
> to try the same BAQ and see if you get similar results (i.e. where
> ChangedBy user was not associated/had no access to the Opportunity/ Quote
> Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of
> the quotes were last changed by somebody who would NEVER touch
> Opportunity/ Quote Entry or anything to do with the Sales side of the
> company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who
> ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed
> by non-sales staff are done ChangeTime < 100 (i assume this to be
> seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be
> interested to see if it IS happening, but users didnt realise that it
> was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be
> appreciated.
>
> Thanks,
>
> CHRIS THOMPSON
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Are you on E9 now? If so which version?

I believe I have a couple of calls about this ones as both calls are linked in one way but separate in another. Both refer to MES users making changes to quotes.

1229483PSC

1208583PSC - The original call for this was for exactly the reason (where MES users were last people to make changes to quotes). Epicor told us this was 'cosmetic' and to set up the change logs. Now the change logs tell us the same things as the BAQ. MES users are making the last changes to Quotes.




________________________________
From: chris_robisch <bluewine@...>
To: vantage@yahoogroups.com
Sent: Tue, 19 January, 2010 17:45:53
Subject: [Vantage] Re: Vantage - Quote Table Problems

Â
Yes, the call number. It's helpful to refer to another call number if another customer has already reported it.

The reason we never reported it is we're on 8.03.405a, going to E9, and didn't want to burden Epicor with a problem that perhaps was fixed in a later version. We don't do enough testing in 8.03.408b and thought we'd wait until we're on E9 to see if it keeps happening.

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...> wrote:
>
> By incident number, do you mean call number?
>
> Thanks,
>
> CHRIS
>
>
>
>
> ____________ _________ _________ __
> From: Chris Robisch <bluewine@.. .>
> To: vantage@yahoogroups .com
> Sent: Mon, 18 January, 2010 16:56:56
> Subject: Re: [Vantage] Vantage - Quote Table Problems
>
> ÂÂ
> Ironically, we just discovered the same problem a couple of weeks ago. We use DCUser for all of our MES stations and this user-id can't do anything else. It has no Security Groups assigned to it and you must be in the Quotes group to maintain Quotes. Yet it shows up as the last user changing quote headers/lines frequently.
>
> Please let me know your incident number and I'll report it as well. Thanks.
> ----- Original Message -----
> From: Chris Thompson
> To: vantage@yahoogroups .com
> Sent: Monday, January 18, 2010 6:54 AM
> Subject: [Vantage] Vantage - Quote Table Problems
>
> Hi All,
>
> Im wondering if you can help.
>
> We are having a problem where our Change Logs are telling us that changes have been made to Quotations by people who don't even have access to the Opportunity/ Quote Entry screen, most of which are actually only MES users.
>
> To confirm this, I did a very simple BAQ - Would it be possible for you to try the same BAQ and see if you get similar results (i.e. where ChangedBy user was not associated/had no access to the Opportunity/ Quote Entry screens)?
>
> The BAQ is as follows:-
>
> Use the QuoteHed table and display the following:
>
> QuoteHed.QuoteNum
> QuoteHed.ChangedBy
> QuoteHed.EntryDate
> QuoteHed.ChangeDate
> QuoteHed.ChangeBy
>
> According to my BAQ, out of 4207 quotes done since going live, 3296 of the quotes were last changed by somebody who would NEVER touch Opportunity/ Quote Entry or anything to do with the Sales side of the company.
>
> Out of these 3296, 1326 of them were changed by ShopFloor terminals who ONLY have access to the MES modules and that is all.
>
> Generally I find that the ChangeTime for the ones that have been changed by non-sales staff are done ChangeTime < 100 (i assume this to be seconds from midnight).
>
> They all tend to be changed 30 days from the Entry Date of the quote.
>
> Epicor say that they haven't come across this before so I would be interested to see if it IS happening, but users didnt realise that it was happening.
>
> If you could have a try of the BAQ and let me know the results it'd be appreciated.
>
> Thanks,
>
> CHRIS THOMPSON
>
> [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
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







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