Quick Search Issues in Epicor 9.05 700c

Yahoo Archive
1
Hi guys,

this has been recently fixed in the new release of E9.05.701. Check out the release notes. So many bugs that i had seen in 700 have been fixed with several performance enhancements added. Incase you are not up for an upgrade contact epicor to give you the fix.

I am doing a new installation and an upgrade to our test servers as well as our new clients servers and will be in better position to give more details.

Regard

Anthony
--- In vantage@yahoogroups.com, "chan213419" <chan213419@...> wrote:
>
> Thanks for all of your replies...
>
> This was solved: how?
>
> The "Company is Null" error is a known error like Neil said below. Epicor provided a one off fix for that one. If you run into this, contact Epicor.
>
> The Quick Search error described below. Epicor has confirmed that this is indeed an error and they are currently developing a fix for it. Both errors reported are known epicor issues for 700C.
>
> hope this helps for anyone else who runs into it.
>
> Chan.
>
> --- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@> wrote:
> >
> > I think there is a check box in the quick search maintenance screen that had something about checking for null...If you uncheck that checkbox does that not work? In our WI EUG meeting yesterday Jennifer demonstrated that and suggested esp part does not need the checkbox checked since you will always have a part in part entry...
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Neil Buckman
> > Sent: Thursday, September 20, 2012 5:29 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Quick Search Issues in Epicor 9.05 700c
> >
> >
> >
> > Hi Chan,
> >
> > I had the same issue (the error) and received this from Support:
> >
> > The issue you are reporting has already been reported via SCR 98271, which has the following Description:
> >
> > PROBLEM DESCRIPTION: When a Quick Search on Part.PartNum is run and a record selected, the following error is received:
> >
> > Column 'Company' does not allow nulls
> >
> > PROGRAM ID: Searches/Quick Search/BAQ
> >
> > EXPECTED BEHAVIOR: No error should be received and the selected record data should be loaded into the Part Entry form.
> >
> > Development has set a Target Fix Service Pack at E9.05.701.
> >
> > However I activated the Full Text Searching and it is much better than my part number search.
> >
> > - Neil
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of chan213419
> > Sent: Friday, 21 September 2012 12:08 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Quick Search Issues in Epicor 9.05 700c
> >
> > I am working in a Pilot environment, setting up a company before they go live.
> >
> > I have 2 issues with Quick Searches
> >
> > 1.) When I set-up the Quick Search (that returns the CustID) I allow it to be applied to any application where a Customer can be searched. When I click on the 'Customer' button and select the Quick Search tab (on the Customer Maintenance OR Order Entry screens) I see my Quick search. However, these are the only two screens where I can see my Quick Search. If I go to Quote/Entry or the Customer Tracker Screens and click on the Quick Search tab, there are NO Quick Searches listed.
> >
> > Even more buggy: when I am in these same applications and I navigate to the Quick Search in a different way, (i.e. right click on empty Customer field --> 'Quick Searches') I find my Quick Searches there.
> >
> > So they wont show up on the tab, but when I right click they are there. Is this a known Epicor bug?
> >
> > 2.) I created a Quick Search that grabs a partnum. The Quick Search runs just fine, but when I select a part that i want to use I get a exception error:
> >
> > System.Data.NoNullAllowedException: Column 'Company' does not allow nulls.
> >
> > Thank you for your help!
> >
> > Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.
> >
> > The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au
> >
> > P Please consider our shared environment before printing this communication.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
I am working in a Pilot environment, setting up a company before they go live.

I have 2 issues with Quick Searches

1.) When I set-up the Quick Search (that returns the CustID) I allow it to be applied to any application where a Customer can be searched. When I click on the 'Customer' button and select the Quick Search tab (on the Customer Maintenance OR Order Entry screens) I see my Quick search. However, these are the only two screens where I can see my Quick Search. If I go to Quote/Entry or the Customer Tracker Screens and click on the Quick Search tab, there are NO Quick Searches listed.

Even more buggy: when I am in these same applications and I navigate to the Quick Search in a different way, (i.e. right click on empty Customer field --> 'Quick Searches') I find my Quick Searches there.

So they wont show up on the tab, but when I right click they are there. Is this a known Epicor bug?

2.) I created a Quick Search that grabs a partnum. The Quick Search runs just fine, but when I select a part that i want to use I get a exception error:

System.Data.NoNullAllowedException: Column 'Company' does not allow nulls.

Thank you for your help!
3
In summary the Quick Searches I created were made available to the user whenever they need to search customers. The user can find these Quick Searches under the Quick Search tab in the Customer Maintenance, and Order Entry screens (after clicking 'customer' to search).

These searches should be available on ANY screen that searches a customer, BUT THEY ARE ONLY AVAILABLE UNDER THE QUICK SEARCH TAB ON THE PREVIOUSLY MENTIONED SCREENS.

The headscratching part? when you pull up the Quick Searches by right clicking on the customer field and going to 'Quick Searches' the Quick Searches I created ARE THERE, THEY JUST WONT APPEAR IN THE QUICK SEARCH TAB LIKE THEY SHOULD.

I'm really confused.

Thanks for your help :)

--- In vantage@yahoogroups.com, "chan213419" <chan213419@...> wrote:
>
> I am working in a Pilot environment, setting up a company before they go live.
>
> I have 2 issues with Quick Searches
>
> 1.) When I set-up the Quick Search (that returns the CustID) I allow it to be applied to any application where a Customer can be searched. When I click on the 'Customer' button and select the Quick Search tab (on the Customer Maintenance OR Order Entry screens) I see my Quick search. However, these are the only two screens where I can see my Quick Search. If I go to Quote/Entry or the Customer Tracker Screens and click on the Quick Search tab, there are NO Quick Searches listed.
>
> Even more buggy: when I am in these same applications and I navigate to the Quick Search in a different way, (i.e. right click on empty Customer field --> 'Quick Searches') I find my Quick Searches there.
>
> So they wont show up on the tab, but when I right click they are there. Is this a known Epicor bug?
>
> 2.) I created a Quick Search that grabs a partnum. The Quick Search runs just fine, but when I select a part that i want to use I get a exception error:
>
> System.Data.NoNullAllowedException: Column 'Company' does not allow nulls.
>
> Thank you for your help!
>
4
Have you tried these?

In the BAQ, add the Company field to its display.
In Quick Search Entry check the boxes for "Shared' & "All Occurrences"

--- In vantage@yahoogroups.com, "chan213419" <chan213419@...> wrote:
>
> In summary the Quick Searches I created were made available to the user whenever they need to search customers. The user can find these Quick Searches under the Quick Search tab in the Customer Maintenance, and Order Entry screens (after clicking 'customer' to search).
>
> These searches should be available on ANY screen that searches a customer, BUT THEY ARE ONLY AVAILABLE UNDER THE QUICK SEARCH TAB ON THE PREVIOUSLY MENTIONED SCREENS.
>
> The headscratching part? when you pull up the Quick Searches by right clicking on the customer field and going to 'Quick Searches' the Quick Searches I created ARE THERE, THEY JUST WONT APPEAR IN THE QUICK SEARCH TAB LIKE THEY SHOULD.
>
> I'm really confused.
>
> Thanks for your help :)
>
> --- In vantage@yahoogroups.com, "chan213419" <chan213419@> wrote:
> >
> > I am working in a Pilot environment, setting up a company before they go live.
> >
> > I have 2 issues with Quick Searches
> >
> > 1.) When I set-up the Quick Search (that returns the CustID) I allow it to be applied to any application where a Customer can be searched. When I click on the 'Customer' button and select the Quick Search tab (on the Customer Maintenance OR Order Entry screens) I see my Quick search. However, these are the only two screens where I can see my Quick Search. If I go to Quote/Entry or the Customer Tracker Screens and click on the Quick Search tab, there are NO Quick Searches listed.
> >
> > Even more buggy: when I am in these same applications and I navigate to the Quick Search in a different way, (i.e. right click on empty Customer field --> 'Quick Searches') I find my Quick Searches there.
> >
> > So they wont show up on the tab, but when I right click they are there. Is this a known Epicor bug?
> >
> > 2.) I created a Quick Search that grabs a partnum. The Quick Search runs just fine, but when I select a part that i want to use I get a exception error:
> >
> > System.Data.NoNullAllowedException: Column 'Company' does not allow nulls.
> >
> > Thank you for your help!
> >
>
5
Good Day Chan:

It was a known problem, in 9.05.605, that some fields could not have
a Quick-Search linked to them. Bug in program. No date for fix.

Also, if you execute a Quick-Search using a right click method, then
it may run incorrectly. I have seen it happen - it is random.



Sun is on 9.05.605 since 10/2/11 - SQL-Unidata- 64 bit
Live on 9.05.601B since 11/29/10
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)


Len
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...

www.Sunautomation.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of chan213419
Sent: Thursday, September 20, 2012 12:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Quick Search Issues in Epicor 9.05 700c




In summary the Quick Searches I created were made available to the user
whenever they need to search customers. The user can find these Quick
Searches under the Quick Search tab in the Customer Maintenance, and
Order Entry screens (after clicking 'customer' to search).

These searches should be available on ANY screen that searches a
customer, BUT THEY ARE ONLY AVAILABLE UNDER THE QUICK SEARCH TAB ON THE
PREVIOUSLY MENTIONED SCREENS.

The headscratching part? when you pull up the Quick Searches by right
clicking on the customer field and going to 'Quick Searches' the Quick
Searches I created ARE THERE, THEY JUST WONT APPEAR IN THE QUICK SEARCH
TAB LIKE THEY SHOULD.

I'm really confused.

Thanks for your help :)

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"chan213419" <chan213419@...> wrote:
>
> I am working in a Pilot environment, setting up a company before they
go live.
>
> I have 2 issues with Quick Searches
>
> 1.) When I set-up the Quick Search (that returns the CustID) I allow
it to be applied to any application where a Customer can be searched.
When I click on the 'Customer' button and select the Quick Search tab
(on the Customer Maintenance OR Order Entry screens) I see my Quick
search. However, these are the only two screens where I can see my Quick
Search. If I go to Quote/Entry or the Customer Tracker Screens and click
on the Quick Search tab, there are NO Quick Searches listed.
>
> Even more buggy: when I am in these same applications and I navigate
to the Quick Search in a different way, (i.e. right click on empty
Customer field --> 'Quick Searches') I find my Quick Searches there.
>
> So they wont show up on the tab, but when I right click they are
there. Is this a known Epicor bug?
>
> 2.) I created a Quick Search that grabs a partnum. The Quick Search
runs just fine, but when I select a part that i want to use I get a
exception error:
>
> System.Data.NoNullAllowedException: Column 'Company' does not allow
nulls.
>
> Thank you for your help!
>






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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

I had the same issue (the error) and received this from Support:


The issue you are reporting has already been reported via SCR 98271, which has the following Description:



PROBLEM DESCRIPTION: When a Quick Search on Part.PartNum is run and a record selected, the following error is received:



Column 'Company' does not allow nulls



PROGRAM ID: Searches/Quick Search/BAQ

EXPECTED BEHAVIOR: No error should be received and the selected record data should be loaded into the Part Entry form.



Development has set a Target Fix Service Pack at E9.05.701.



However I activated the Full Text Searching and it is much better than my part number search.

- Neil



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of chan213419
Sent: Friday, 21 September 2012 12:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Quick Search Issues in Epicor 9.05 700c



I am working in a Pilot environment, setting up a company before they go live.

I have 2 issues with Quick Searches

1.) When I set-up the Quick Search (that returns the CustID) I allow it to be applied to any application where a Customer can be searched. When I click on the 'Customer' button and select the Quick Search tab (on the Customer Maintenance OR Order Entry screens) I see my Quick search. However, these are the only two screens where I can see my Quick Search. If I go to Quote/Entry or the Customer Tracker Screens and click on the Quick Search tab, there are NO Quick Searches listed.

Even more buggy: when I am in these same applications and I navigate to the Quick Search in a different way, (i.e. right click on empty Customer field --> 'Quick Searches') I find my Quick Searches there.

So they wont show up on the tab, but when I right click they are there. Is this a known Epicor bug?

2.) I created a Quick Search that grabs a partnum. The Quick Search runs just fine, but when I select a part that i want to use I get a exception error:

System.Data.NoNullAllowedException: Column 'Company' does not allow nulls.

Thank you for your help!



Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.



[Non-text portions of this message have been removed]
7
I think there is a check box in the quick search maintenance screen that had something about checking for null...If you uncheck that checkbox does that not work? In our WI EUG meeting yesterday Jennifer demonstrated that and suggested esp part does not need the checkbox checked since you will always have a part in part entry...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Neil Buckman
Sent: Thursday, September 20, 2012 5:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quick Search Issues in Epicor 9.05 700c



Hi Chan,

I had the same issue (the error) and received this from Support:

The issue you are reporting has already been reported via SCR 98271, which has the following Description:

PROBLEM DESCRIPTION: When a Quick Search on Part.PartNum is run and a record selected, the following error is received:

Column 'Company' does not allow nulls

PROGRAM ID: Searches/Quick Search/BAQ

EXPECTED BEHAVIOR: No error should be received and the selected record data should be loaded into the Part Entry form.

Development has set a Target Fix Service Pack at E9.05.701.

However I activated the Full Text Searching and it is much better than my part number search.

- Neil

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of chan213419
Sent: Friday, 21 September 2012 12:08 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Quick Search Issues in Epicor 9.05 700c

I am working in a Pilot environment, setting up a company before they go live.

I have 2 issues with Quick Searches

1.) When I set-up the Quick Search (that returns the CustID) I allow it to be applied to any application where a Customer can be searched. When I click on the 'Customer' button and select the Quick Search tab (on the Customer Maintenance OR Order Entry screens) I see my Quick search. However, these are the only two screens where I can see my Quick Search. If I go to Quote/Entry or the Customer Tracker Screens and click on the Quick Search tab, there are NO Quick Searches listed.

Even more buggy: when I am in these same applications and I navigate to the Quick Search in a different way, (i.e. right click on empty Customer field --> 'Quick Searches') I find my Quick Searches there.

So they wont show up on the tab, but when I right click they are there. Is this a known Epicor bug?

2.) I created a Quick Search that grabs a partnum. The Quick Search runs just fine, but when I select a part that i want to use I get a exception error:

System.Data.NoNullAllowedException: Column 'Company' does not allow nulls.

Thank you for your help!

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

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



[Non-text portions of this message have been removed]
8
Thanks for all of your replies...

This was solved: how?

The "Company is Null" error is a known error like Neil said below. Epicor provided a one off fix for that one. If you run into this, contact Epicor.

The Quick Search error described below. Epicor has confirmed that this is indeed an error and they are currently developing a fix for it. Both errors reported are known epicor issues for 700C.

hope this helps for anyone else who runs into it.

Chan.

--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> I think there is a check box in the quick search maintenance screen that had something about checking for null...If you uncheck that checkbox does that not work? In our WI EUG meeting yesterday Jennifer demonstrated that and suggested esp part does not need the checkbox checked since you will always have a part in part entry...
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Neil Buckman
> Sent: Thursday, September 20, 2012 5:29 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Quick Search Issues in Epicor 9.05 700c
>
>
>
> Hi Chan,
>
> I had the same issue (the error) and received this from Support:
>
> The issue you are reporting has already been reported via SCR 98271, which has the following Description:
>
> PROBLEM DESCRIPTION: When a Quick Search on Part.PartNum is run and a record selected, the following error is received:
>
> Column 'Company' does not allow nulls
>
> PROGRAM ID: Searches/Quick Search/BAQ
>
> EXPECTED BEHAVIOR: No error should be received and the selected record data should be loaded into the Part Entry form.
>
> Development has set a Target Fix Service Pack at E9.05.701.
>
> However I activated the Full Text Searching and it is much better than my part number search.
>
> - Neil
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of chan213419
> Sent: Friday, 21 September 2012 12:08 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Quick Search Issues in Epicor 9.05 700c
>
> I am working in a Pilot environment, setting up a company before they go live.
>
> I have 2 issues with Quick Searches
>
> 1.) When I set-up the Quick Search (that returns the CustID) I allow it to be applied to any application where a Customer can be searched. When I click on the 'Customer' button and select the Quick Search tab (on the Customer Maintenance OR Order Entry screens) I see my Quick search. However, these are the only two screens where I can see my Quick Search. If I go to Quote/Entry or the Customer Tracker Screens and click on the Quick Search tab, there are NO Quick Searches listed.
>
> Even more buggy: when I am in these same applications and I navigate to the Quick Search in a different way, (i.e. right click on empty Customer field --> 'Quick Searches') I find my Quick Searches there.
>
> So they wont show up on the tab, but when I right click they are there. Is this a known Epicor bug?
>
> 2.) I created a Quick Search that grabs a partnum. The Quick Search runs just fine, but when I select a part that i want to use I get a exception error:
>
> System.Data.NoNullAllowedException: Column 'Company' does not allow nulls.
>
> Thank you for your help!
>
> Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.
>
> The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au
>
> P Please consider our shared environment before printing this communication.
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>