Price List not showing up in Search

Epicor ERP 10
,
1

In Price List Maintenance, our price list codes are set up as our part number. When we click on the Price List button to search, we key in the part number in the box where it says Starting At and click search. The issue we are having is that it shows Price lists after that part number but not the one for the part number itself:

image
image1339Ă—358 36.2 KB

If we type the part number into the box next to the Price List button and press the tab key, then the Price List appears:

image
image855Ă—309 14.3 KB

Any idea what is going on? This doesn’t make sense. Just asking before I open a case.

2

There’s not a " " before the 13728A is there? Like " 13728A" instead of “13728A”?

3

I have seen that in some other UIs as well, can’t recall which maybe the PO Search or PackSlip Search – where if I entered the number it didnt show. But If I left the last character out it did.

4

Enable tracing, and see if the WhereClause value has > or >=

EDIT

Because that search field is for the Description, not the code.

If the description for 13728A started with 13728A and not Lid, 10ML, it would find it.

Try searching for Lid, 10ML and I bet it appears first

image
image1097Ă—342 17.5 KB

2 Likes
5

Thanks, Calvin! I didn’t notice that the Description for the Price List is wrong. It should say, “13728A Reprice Schedule” like most of our Price Lists do. Chances are, someone is changing the description and shouldn’t be.

6

There was a just another topic the other day regarding Price List searches. And the fact that it uses the Description and not the Code, should have jumped out at me (or at least to @hkeric.wci)

1 Like
7

Me too! I just read it this morning but didn’t put two and two together! It’s Monday…LOL!