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
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]