To Todd and Sherri!
Resolution found, thanks to Sherri. I ran a query to Excel showing
pertinant fields from "Customer" table. I found which Customer
had "2" as the "CustNum". I then went into Customer File Maintenance
and deleted the customer. This seemed to fix the problem!!
Great solution for a company that has not implimented Vantage yet.
The error was caught before we went live. If issue happened after
going live, with 100s of customers, and a myriad of quotes, orders,
and jobs tied to them, this solution would be a nightmare!
Thanks again to both of you!!
Alan
Resolution found, thanks to Sherri. I ran a query to Excel showing
pertinant fields from "Customer" table. I found which Customer
had "2" as the "CustNum". I then went into Customer File Maintenance
and deleted the customer. This seemed to fix the problem!!
Great solution for a company that has not implimented Vantage yet.
The error was caught before we went live. If issue happened after
going live, with 100s of customers, and a myriad of quotes, orders,
and jobs tied to them, this solution would be a nightmare!
Thanks again to both of you!!
Alan
--- In vantage@yahoogroups.com, "Sherri Hill" <sherrih@g...> wrote:
> Alan,
>
>
>
> It is not complaining about the custid field, it is complaining
about
> the custnum field. The customer.custnum field is a sequential
number
> behind the scenes that is used in the customer table.
>
>
>
> Customer custnum field = A unique integer assigned by the system
to new
> customers by the customer maintenance program. This field is used
as the
> foreign key to identify the customer in other files such as
OrderHed or
> InvcHead. The end user should never need to know about the value of
> this field.
>
>
>
> See if you have a record in the customer table that has company
= "FMI"
> and custnum = 2.
>
>
>
> Sherri Hill
>
> Sr. Programmer Analyst, GBS
>
> 330-494-5330, Ext. #2405
>
> _____
>
> From: Alan Palmer [mailto:service@f...]
> Sent: Thursday, February 10, 2005 4:59 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Error 132
>
>
>
>
> Todd,
>
> Thanks so much for the advice! I did check for special characters
and
> found none in Customer ID. Vantage is new for me, what is the "RB
> Report"?
>
> Alan
>
> --- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...>
wrote:
> > Glen Woods at M&M Manufacturing had this issue back in April of
> 2003 but there were no followup posts about it. Not sure if he is
> still involved with Vantage or at M&M but his email address was:
> <mailto:gwoods@m...> gwoods@m... Perhaps if they ever resolved it
> there he might have some advice to share.
> >
> > The only thing I can think of is a blank Customer ID in the
> Customer table or perhaps some other oddity in a Customer ID.
Maybe
> you could do a quick RB report listing all the Customer ID's and
> their corresponding number. Another thought is the possibility of
a
> special character in an ID, such as a comma or semi-colon, since
the
> ID is a character field.
> >
> > -Todd C.
> >
> > -----Original Message-----
> > From: customcables2005 [mailto:service@f...]
> > Sent: Thursday, February 10, 2005 1:41 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Error 132
> >
> >
> >
> > Has anyone come across an Error 132 when attempting to add a new
> > customer? I discovered it 2 days ago and Epicor has yet to
provide
> > much of a solution.
> >
> > Here is the full report:
> >
> > From a quote or at the Master Maintenance level (Customer Table),
> > when you either hit "Insert" on your keyboard or go to
> the "Customer"
> > menu and select "Add", before the "Customer Entry" form appears,
> the
> > error message dialogue box appears saying, "**b_Customer already
> > exists with Company "FMI" Customer 2. (132)"
> >
> > When I click "OK", a second error appears saying, "**Unable to
> update
> > Customer Field. (142)"
> >
> > Nothing happens after you "OK" out of second error. The Customer
> > Entry form never appears.
> >
> > Please let me know if you have seen this before and what the
> > resolution and cause was. Customer Service is saying that one of
> the
> > customer records either has a duplicate ID or a blank ID, but I
> > cannot find either of these conditions.
> >
> > Thanks,
> >
> > Alan Palmer
> >
> >
> >
> >
> >
> > 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/.
> <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
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> > ADVERTISEMENT
> >
> >
> >
>
<http://us.ard.yahoo.com/SIG=12936sv16/M=298184.6018725.7038619.300117
>
6/D=groups/S=1705007183:HM/EXP=1108150898/A=2532114/R=2/SIG=12k5dm018/
>
*http://clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=110
> 8064498024362>
> > <http://us.adserver.yahoo.com/l?
>
M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2532114/rand=9470944
> 04>
> >
> >
> > _____
> >
> > Yahoo! Groups Links
> >
> >
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/vantage/
> >
> >
> > * To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com <mailto:vantage-
> unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> >
> > * 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/.
> <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
>
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
<http://us.ard.yahoo.com/SIG=129ohlnph/M=298184.6018725.7038619.300117
6/
>
D=groups/S=1705007183:HM/EXP=1108159128/A=2532114/R=2/SIG=12km06qra/*h
tt
>
p:/clk.atdmt.com/NFX/go/yhxxxnfx0020000014nfx/direct/01/&time=11080727
28
> 317778>
>
>
<http://view.atdmt.com/NFX/view/yhxxxnfx0020000014nfx/direct/01/&time=
11
> 08072728317778>
>
>
> <http://us.adserver.yahoo.com/l?
M=298184.6018725.7038619.3001176/D=group
> s/S=:HM/A=2532114/rand=722252369>
>
>
>
> _____
>
> Yahoo! Groups Links
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * 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]