Missing Customers (5.20)

system · September 18, 2002, 5:31pm

Epicor says this is a bug in the conversion to 5.20 and there is a fix
program special for it. So it looks like something in the data causes some
to be ignored by selection screens. I should have a copy of the fix
tomorrow and know more about what the issue is.
-Todd C.

-----Original Message-----
From: Paul Lipham [mailto:pml@...]
Sent: Wednesday, September 18, 2002 12:30 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Missing Customers (5.20)

Todd,

We have seen a similar problem when we were on version 4.00 of Vantage. We
ended up having to do an IDXBUILD on all the indexes for the system. It
really wasn't that tough to do and corrected the problem. I'm thinking you
are having an indexing problem. It's strange that Support didn't jump on
that band wagon... they may know something we don't?

I'm also thinking we had to run an IDXBUILD when upgrading to version 5.00
It was part of the standard procedures.

Paul

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 18, 2002 11:30 AM
To: 'Vantage@...'
Subject: [Vantage] Missing Customers (5.20)

I called support on this but their computers are down and they can't
investigate at the moment so thought perhaps someone in the group would know
about this.

Somewhere in the conversion to 5.20.210 we have lost about 25% of our
customers from any customer selection screen. For example when entering an
order if you click on the magnifying glass to get a list of customers many
of them are not there. Can't see them in Customer Maintenance either. But
if I pull up an order for a missing customer and right-click to Customer
Tracker it pulls them up fine. All the info is there.

When I called Epicor they thought it was related to CRM (which we do not
have) and something to do with the Territory or Region. I have found, with
RB, that all the missing customers have a TaxRegion = 0001 and all the
visible ones have nothing for TaxRegion. If I change a visible customer to
0001 it stays visible so this correlation might be a coincidence. The new
customer type on all the missing ones is all over the place but mostly CUS
(but a lot of SUS too) and I've set selection filter to <ALL>. BTW -
Haven't figured out the difference between Prospect and Suspect customer
yet.

Even if I figure out what causes this I can't get into customer maintenance
for the missing customer because the main screen does not allow manual entry
of an ID, just selection from the list. But I was wondering if anyone else
on or testing 5.20 has seen or fixed this.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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

Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=234081.2377872.3808768.2225242/D=egroupweb/S=17050071
83:HM/A=1225251/R=0/*http://ad.doubleclick.net/clk;4547219;7007303;d?http://
www.ameriquestmortgage.com/welcome.html?ad=Yahoo01>

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

[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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · September 18, 2002, 12:29pm

I called support on this but their computers are down and they can't
investigate at the moment so thought perhaps someone in the group would know
about this.

Somewhere in the conversion to 5.20.210 we have lost about 25% of our
customers from any customer selection screen. For example when entering an
order if you click on the magnifying glass to get a list of customers many
of them are not there. Can't see them in Customer Maintenance either. But
if I pull up an order for a missing customer and right-click to Customer
Tracker it pulls them up fine. All the info is there.

When I called Epicor they thought it was related to CRM (which we do not
have) and something to do with the Territory or Region. I have found, with
RB, that all the missing customers have a TaxRegion = 0001 and all the
visible ones have nothing for TaxRegion. If I change a visible customer to
0001 it stays visible so this correlation might be a coincidence. The new
customer type on all the missing ones is all over the place but mostly CUS
(but a lot of SUS too) and I've set selection filter to <ALL>. BTW -
Haven't figured out the difference between Prospect and Suspect customer
yet.

Even if I figure out what causes this I can't get into customer maintenance
for the missing customer because the main screen does not allow manual entry
of an ID, just selection from the list. But I was wondering if anyone else
on or testing 5.20 has seen or fixed this.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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

system · September 18, 2002, 12:52pm

This sounds like an indexing problem. Do you see any logical breaks when
you switch your browser from searching on ID or name. I would expect
support to guide you through a reindex of that table. I've seen similar
effects when a key index is broken.

Shirley

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 18, 2002 12:30 PM
To: 'Vantage@...'
Subject: [Vantage] Missing Customers (5.20)

I called support on this but their computers are down and they can't
investigate at the moment so thought perhaps someone in the group would
know
about this.

Somewhere in the conversion to 5.20.210 we have lost about 25% of our
customers from any customer selection screen. For example when entering
an
order if you click on the magnifying glass to get a list of customers many
of them are not there. Can't see them in Customer Maintenance either.
But
if I pull up an order for a missing customer and right-click to Customer
Tracker it pulls them up fine. All the info is there.

When I called Epicor they thought it was related to CRM (which we do not
have) and something to do with the Territory or Region. I have found,
with
RB, that all the missing customers have a TaxRegion = 0001 and all the
visible ones have nothing for TaxRegion. If I change a visible customer
to
0001 it stays visible so this correlation might be a coincidence. The new
customer type on all the missing ones is all over the place but mostly CUS
(but a lot of SUS too) and I've set selection filter to <ALL>. BTW -
Haven't figured out the difference between Prospect and Suspect customer
yet.

Even if I figure out what causes this I can't get into customer
maintenance
for the missing customer because the main screen does not allow manual
entry
of an ID, just selection from the list. But I was wondering if anyone
else
on or testing 5.20 has seen or fixed this.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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

Yahoo! Groups Sponsor
ADVERTISEMENT

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

system · September 18, 2002, 1:30pm

Todd,

We have seen a similar problem when we were on version 4.00 of Vantage. We
ended up having to do an IDXBUILD on all the indexes for the system. It
really wasnï¿½t that tough to do and corrected the problem. Iï¿½m thinking you
are having an indexing problem. Itï¿½s strange that Support didnï¿½t jump on
that band wagonï¿½ they may know something we donï¿½t?

Iï¿½m also thinking we had to run an IDXBUILD when upgrading to version 5.00
It was part of the standard procedures.

Paul

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 18, 2002 11:30 AM
To: 'Vantage@...'
Subject: [Vantage] Missing Customers (5.20)

I called support on this but their computers are down and they can't
investigate at the moment so thought perhaps someone in the group would know
about this.

Somewhere in the conversion to 5.20.210 we have lost about 25% of our
customers from any customer selection screen. For example when entering an
order if you click on the magnifying glass to get a list of customers many
of them are not there. Can't see them in Customer Maintenance either. But
if I pull up an order for a missing customer and right-click to Customer
Tracker it pulls them up fine. All the info is there.

When I called Epicor they thought it was related to CRM (which we do not
have) and something to do with the Territory or Region. I have found, with
RB, that all the missing customers have a TaxRegion = 0001 and all the
visible ones have nothing for TaxRegion. If I change a visible customer to
0001 it stays visible so this correlation might be a coincidence. The new
customer type on all the missing ones is all over the place but mostly CUS
(but a lot of SUS too) and I've set selection filter to <ALL>. BTW -
Haven't figured out the difference between Prospect and Suspect customer
yet.

Even if I figure out what causes this I can't get into customer maintenance
for the missing customer because the main screen does not allow manual entry
of an ID, just selection from the list. But I was wondering if anyone else
on or testing 5.20 has seen or fixed this.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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

Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=234081.2377872.3808768.2225242/D=egroupweb/S=17050071
83:HM/A=1225251/R=0/*http://ad.doubleclick.net/clk;4547219;7007303;d?http://
www.ameriquestmortgage.com/welcome.html?ad=Yahoo01>

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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